The SQLAnyWhere Platform currently translates the JPA function "CONCAT(a, b)"
into the SQL term "a + b". Actually this is wrong and potentially leads to
crashes: In case "a" contains a string and "b" contains a number, the SQL
command will crash because the DBMS tries to convert the string into a number
(and not vice versa as one might expect).
To fix it, the SQLAnyWhere Platform must override the CONCAT translation into
the correct form. Instead of "a + b" it must produce "a || b". The difference
between the "plus" and the "||" operator is that "plus" is a numeric operating
(all operands are first converted to numbers as soon as one operand is a number,
what does not work with non-numeric strings), while "||" is a string operator
(all operands are first converted to strings, what even works for numbers).
I am the author of the SQLAnyWhere Platform, but I do not have CSV commit
rights, unfortunately. So I need to ask you to fix that for me. The fix should
be as easy as adding the CONCAT override and such is done in a few minutes.
Thanks. Unfortunately this fix is really urgent because it will be a showstopper
for people using CONCAT with numbers. There is no workaround.