https://bugs.documentfoundation.org/show_bug.cgi?id=91989
Bug ID: 91989
Summary: Query builder in UI doesn't parse GROUP_CONCAT with
ORDER or SEPARATOR
Product: LibreOffice
Version: 4.4.3.2 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
