Changes between Initial Version and Version 2 of Ticket #30315


Ignore:
Timestamp:
Apr 2, 2019, 1:39:35 PM (5 years ago)
Author:
Reupen Shah
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #30315

    • Property Summary StringAgg with ordering in subquery executes invalid string_agg() SQL function callStringAgg with ordering in subquery generates invalid string_agg() SQL function call
    • Property Component Uncategorizedcontrib.postgres
  • 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