Anne
(Anne Verkleij)
1
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
Anne
(Anne Verkleij)
3
Bump up, still not solved.
Anne
(Anne Verkleij)
4
Bump, still not solved.
@Colin @Alexandre_Gigleux Could you take a look?
Anne
(Anne Verkleij)
6
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
system
(system)
Closed
11
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.