The SQL query (for HyperSql) MERGE INTO DWH_DIM_DATES_YEARS USING (SELECT -1,0 AS ID, 'Unknown' AS DESCRIPTION FROM (VALUES(0))) AS VALS(ID,DESCRIPTION) Seems to fail because of the comma in "-1,0" on Windows platform.
The SQL query (for HyperSql)
MERGE INTO DWH_DIM_DATES_YEARS USING (SELECT -1,0 AS ID, 'Unknown' AS DESCRIPTION FROM (VALUES(0))) AS VALS(ID,DESCRIPTION)
Seems to fail because of the comma in "-1,0" on Windows platform.