https://bugs.freedesktop.org/show_bug.cgi?id=70433
--- Comment #4 from [email protected] --- (In reply to comment #3) > The SQL statement that I see in your file : > > SELECT LIST( "Vorname", ' and ' ) FROM "Name_VarcharID" > Hi Alex, there are two new functions in Firebird, which I missed in HSQLDB: DATEADD and LIST. In the description of Firebird I found LIST ([ALL | DISTINCT] expression [, separator]) The result type is a BLOB - could be this problem could be solved together with Bug70664. When I put SELECT LIST( "Vorname", ' and ' ) FROM "Name_VarcharID" in a query of the external Firebird database it shows in Base all Values of "Vorname" in one field - looks like 'Robert and Alex and Eva and Adam' In MySQL/MariaDB this function is called "GROUP_CONCAT()". When this function appears as a choice in the GUI it could be that users think it will work with all databases - especially with the internal databases of LO. Don't know if it should appear there anyway. -- 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
