Changes between Initial Version and Version 2 of Ticket #30315


Ignore:
Timestamp:
04/02/2019 01:39:35 PM (2 years ago)
Author:
Reupen Shah
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #30315

    • Property Component changed from Uncategorized to contrib.postgres
    • Property Summary changed from StringAgg with ordering in subquery executes invalid string_agg() SQL function call to StringAgg with ordering in subquery generates invalid string_agg() SQL function call
  • Ticket #30315 – Description

    initial v2  
    6161}}}
    6262
     63This is the case with both Django 2.2 and the (current) master branch.
     64
    6365There are two problems in `STRING_AGG(U2."first_name", U2."first_name", ', 'ORDER BY "people_person"."first_name")`:
    6466
     
    66682. the ORDER BY expression is referencing `"people_person"` instead of `U2`.
    6769
    68 
     70\\
    6971
    7072
     
    8789GROUP BY "people_book"."id"
    8890}}}
     91
     92\\
     93
    8994
    9095This query also executes correctly:
Back to Top