#33076: Djang3.0 generate invalid query
-------------------------------------+-------------------------------------
     Reporter:  Awais Qureshi        |                    Owner:  nobody
         Type:  Bug                  |                   Status:  new
    Component:  Database layer       |                  Version:  3.0
  (models, ORM)                      |
     Severity:  Normal               |               Resolution:
     Keywords:  F expression, Q      |             Triage Stage:
  expression, ORM                    |  Unreviewed
    Has patch:  0                    |      Needs documentation:  0
  Needs tests:  0                    |  Patch needs improvement:  0
Easy pickings:  0                    |                    UI/UX:  0
-------------------------------------+-------------------------------------
Description changed by Awais Qureshi:

Old description:

> 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

New description:

 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

--

-- 
Ticket URL: <https://code.djangoproject.com/ticket/33076#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/066.b621ffde6c975e0727c298fd06e123f0%40djangoproject.com.

Reply via email to