#33076 closed Bug (duplicate)
SyntaxError when using __in lookup with F() expression.
| Reported by: | Awais Qureshi | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 3.0 |
| Severity: | Normal | Keywords: | F expression, Q expression, ORM |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
I am trying to run tests again django3.0 and I am getting sql error in a generated query.
I am sharing part of query which is causing error
WHERE (U5."organization_id" IN "course_metadata_course_authoring_organizations"."organization_id" this line triggers error
Result: no such table: course_metadata_course_authoring_organizations.organization_id
Code is some thing like this
editors__user__groups__organization_extension__organization__in=F('authoring_organizations')
authoring_organizations is manytomanyfield.
I did't find any thing in release notes.
Thanks
Awais
Change History (3)
comment:1 by , 3 years ago
| Description: | modified (diff) |
|---|
comment:2 by , 3 years ago
| Resolution: | → duplicate |
|---|---|
| Status: | new → closed |
| Summary: | Djang3.0 generate invalid query → SyntaxError when using __in lookup with F() expression. |
Note:
See TracTickets
for help on using tickets.
Duplicate of #31135, see also #32414.