[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