Bug 91989 - Query builder in UI doesn't parse GROUP_CONCAT with ORDER or SEPARATOR
Summary: Query builder in UI doesn't parse GROUP_CONCAT with ORDER or SEPARATOR
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.4.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Queries
  Show dependency tree / graph
 
Reported: 2015-06-10 19:50 UTC by Graham Horner
Modified: 2017-11-05 23:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Graham Horner 2015-06-10 19:50:34 UTC 
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.
Comment 1 Robert Großkopf 2015-06-11 15:11:47 UTC 
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 ...
Comment 2 Robert Großkopf 2015-06-11 15:22:41 UTC 
I could confirm the same behavior with MySQL/MaraiaDB on OpenSUSE 13.2 64bit rpm Linux with LO 4.4.4.1
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"
Comment 3 Graham Horner 2015-06-11 17:03:18 UTC 
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.