Bug 125161 - CONCAT not recognised by Firebird
Summary: CONCAT not recognised by Firebird
Status: RESOLVED DUPLICATE of bug 117090
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-05-07 16:24 UTC by Silvain Dupertuis
Modified: 2019-05-07 18:35 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Silvain Dupertuis 2019-05-07 16:24:26 UTC 
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.
Comment 1 Julien Nabet 2019-05-07 18:35:03 UTC 

*** This bug has been marked as a duplicate of bug 117090 ***