SonarQube T-SQL plugin can't analyse STRING_AGG WITHIN GROUP with multiple arguments

We have a function which uses STRING_AGG WITHIN GROUP with a multiple columns to order by. SonarQube can’t analyse this file.

Example

SELECT    @weekStringResult = STRING_AGG(FORMAT(OWW.DienstregelWeek,'00'),', ') WITHIN GROUP (ORDER BY  OW.Dienstregelingjaar, D.Jaar, D.Week)

It does work with one column in the order by, probably because of Parse Error during Sonar TSQL Analysis and [SONARTSQL-248] Parse error on STRING_AGG...WITHIN GROUP - SonarSource.

SonarQube version 8.9.2.46101
SonarScanner version 4.6.2.2472
T-SQL plugin version 1.5.1.4340

Bump up, still not solved.

Bump, still not solved.
@Colin @Alexandre_Gigleux Could you take a look?

Bump up, still not solved

Hello @Anne,

Sorry for the late reply. I created a ticket and the bug will be fixed in our next release.

Best regard, Martin

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.