Active Query Builder support area

Failed query validation by use of postgreSQL string_agg() function

Avatar
  • updated

In AQB Version 3.5.x I can use a postgreSQL string_agg() function within my sql and it worked. Now I had to add an order by to the string_agg() function. I got an error message about this unknown feature. So, I updated AQB to the current version 3.9.x. Now the effect is, that the sql parser eliminates the word "string_agg" out of the sql and generates a column with the parameters in brackets.
The correct function call is: string_agg(column, delimiter order by column)

How can this behavior be corrected?

Avatar
Andrey Zavyalov, PM

Hello Rainer,

thank you for report, it was a bug in SQL text emitting code, now it is fixed upstream, and the fix will be included in the next release.

Avatar
rainer kress

Hello Andrey,

thanks for the information. Will the "order by" clause be accepted too with that version?

Avatar
Andrey Zavyalov, PM

Hello Rainer,

yes, it is supported.

Avatar
rainer kress

Hello Andrey,

happy new year. When will the next version be released?

Avatar
rainer kress

Hello Andrey,

I see a new version, but no comment in the release notes corresponding to my issue. Is it fixed in that release?

Additional question: is it possible to use my_own_aggrgate function in AQB?