[bug] SQL for currency has CONCAT involved - ansi is partial supported

requirement

need to change columns and views in the SQL and html tables due unsupported CONCAT() function

Justification

In the Currency model we have a sql with concat involved..

SELECT 	m1.iso4217a3 || \":\" || m1.nombre_moneda FROM 
Engine CONCAT(A,B) A || B
db2 Yes Yes
ingres Yes No
mysql Yes Yes(*)
oracle No Yes
postgres No Yes
sqlserver No N/S
sybase Yes Yes
  • The || works in MySQL as well but you need to set sql_mode to PIPES_AS_CONCAT
  • sqlserver is not in our matrix support data
Edited by Герхард PICCORO Lenz McKAY