Opened 6 years ago

Last modified 6 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
Pull Requests:11172 merged

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.

Change History (0)

Note: See TracTickets for help on using tickets.
Back to Top