#31058: Ordering by the result of RawSQL with F expression and distinct.
-------------------------------------+-------------------------------------
Reporter: wilhelmhb | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: duplicate
Keywords: RawSQL, ordering, | Triage Stage:
expression | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):
* status: new => closed
* version: 2.2 => master
* resolution: => duplicate
Comment:
Executing this query in Django 2.2 fails with
{{{
django.db.utils.ProgrammingError: syntax error at or near "WHERE"
LINE 4: ... WHERE id IN (10)) AS "score", WHERE id I...
}}}
but it was fixed in 567b9928a3ad37e95b9ae17ec41342daa6968739.
I cannot reproduce `TypeError` when calling `print(queryset.query)`. I
think we can mark this as a duplicate of #29692.
--
Ticket URL: <https://code.djangoproject.com/ticket/31058#comment:2>
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/067.967eca47ee37b59a2d2c1e202da9179d%40djangoproject.com.
