Opened 6 years ago
Last modified 6 years ago
#30332 closed Bug
Postgres ordering ARRAY_AGG and STRING_AGG do not support expression. — at Version 1
| Reported by: | Simone Pellizzari | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 2.2 |
| Severity: | Release blocker | Keywords: | postgres string_agg array_agg ordering order by |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
I found that if you pass and expression as an ordering argument (introduced in https://github.com/django/django/commit/96199e562dcc409ab4bdc2b2146fa7cf73c7c5fe) an IndexError: tuple index out of range exception will be thrown when the query is executed.
This is caused by simply ignoring sql_params returned from as_sql elements contained in passed ordering argument.
Note:
See TracTickets
for help on using tickets.