#31699: Fields placed at the SELECT clause in an erroneous order
-------------------------------------------------+------------------------
Reporter: Thodoris Sotiropoulos | Owner: nobody
Type: Uncategorized | Status: new
Component: Uncategorized | Version: 3.0
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------------------+------------------------
I have a query of the form (simplified for opening issue)
{{{#!python
q1 = Model.objects.values('col_a', 'col_b')
q2 = Model.objects.annotate(col_c=F('col_a')).values('col_c', 'col_b')
q1.union(q2)
}}}
The generated SQL query is
{{{#!sql
SELECT "model"."col_a", "model"."col_b" FROM "model" UNION SELECT
"model"."col_b", "model"."col_a" AS "col_c" FROM "model"
}}}
It seems to me that when inspecting the second sub-query, django does not
place fields at the SELECT clause in the correct order, that is
{{{#!sql
SELECT "model"."col_b", "model"."col_a" AS "col_c"
}}}
instead of
{{{#!sql
SELECT "model"."col_a" AS "col_c", "model"."col_b"
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/31699>
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/051.98e3393a030971ae841fdb3284df30e1%40djangoproject.com.
