A query column like:
(SELECT GROUP_CONCAT("name") FROM "table" GROUP BY "surname" WHERE ....) AS "field"
works as expected from the query builder. But if I add either a ORDER BY or SEPARATOR clause to the GROUP_CONCAT it fails unless native SQL mode is enabled.
Using HSQLDB 2.3.2.
I wonder the query-builder knows anything about GROUP_CONCAT, because the internal HSQLDB doesn't include this function.
All what should work with this special function would be an enhancement. So I will set the Importance to this.
I can't reproduce the behavior, because I haven't installed HSQLDB 2.3.2 for testing ...
I could confirm the same behavior with MySQL/MaraiaDB on OpenSUSE 13.2 64bit rpm Linux with LO 220.127.116.11
Isn't a special behavior of HSQLDB 2.3.2 ...
GROUP_CONCAT will work in the GUI without any problem, but when there is added a ORDER BY or a SEPARATOR it only works in direct SQL-mode.
I will set this bug to "New"
Yes, this is half way between a bug and an enhancement. The GUI clearly knows about GROUP_CONCAT so it should also recognise the sub-clauses which various external engines use.