Opened 5 years ago
Last modified 5 years ago
#30332 closed Bug
Postgres ordering ARRAY_AGG and STRING_AGG do not support expression. — at Initial Version
| 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
I found that if you pass and expression as an ordering argument 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.