https://bugs.freedesktop.org/show_bug.cgi?id=83122
Priority: medium
Bug ID: 83122
Assignee: [email protected]
Summary: BASE MYSQL NATIVE CONNECTOR: Options to GROUP_CONCAT
not processed, error returned: SEPARATOR and DISTINCT
Severity: minor
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Database
Product: LibreOffice
MySQL/MariaDB supports the following options in GROUP_CONCAT function:
SEPARATOR and DISTINCT. For manual reference, see <
https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat
>
LO Base will not accept/execute query that contains "SEPARATOR" or "DISTINCT"
options in GROUP_CONCAT function. The back end MySQL database will, however,
process these options as documented. Problem assumed to be with LibreOffice
MySQL Native Connector for LibreOffice. FYI, JDBC driver from MySQL also
failed to handle those options.
DESIRED RESULT: GROUP_CONCAT function in LO Native Connector should not return
errors when options SEPARATOR and DISTINCT are provided. Connector should
handle syntax consistent with MySQL manual.
Workaround, of course, is to create view in back-end MySQL database itself
without using LibreOffice front end, so bug given 'minor' status.
Bug encountered Windows 7/LO 4.3.0.4/MySQL Native Connector for LibreOffice 4.x
1.0.2 (May 02, 2014)
--
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
