[Libreoffice-bugs] [Bug 125161] New: CONCAT not recognised by Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: silvain-dupertuis at bluewin.ch

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190507/9231f705/attachment.html>