Skip to main content

    Synapse

    New

    Fix BUG in TSQL STRING_AGG() WITHIN GROUP -- Sort Order is Ignored / Erroneous in SQL Endpoint for Lakehouse

    Vote (1) Share
    Jonathan Boarman's profile image

    Jonathan Boarman on 04 Sep 2024 21:04:29

    When one needs to apply the STRING_AGG function to sort on a column within groupings, that order is being ignored on the second group. The same query in TSQL on SQL Server yields a different result for the same data.


    This bug has been validated in the SQL Endpoint for a Lakehouse.