https://bugs.documentfoundation.org/show_bug.cgi?id=125161
Bug ID: 125161
Summary: CONCAT not recognised by Firebird
Product: LibreOffice
Version: 6.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
I have used CONCAT a lot in different databases.
For example CONCAT("name",CONCAT(' ',"surname")) to combine names).
It creates many errors when trying to convert my bases to Firebird and it took
me some time to find out what was the problem.
This CONCAT function is not recognised by Firebird.
It should be converted correctly to || syntax. For example:
CONCAT("name",CONCAT(' ',"surname")) => "name" || ' ' || "surname"
Or user should at least receive a warning or some indications about how to
modfy their queries.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
