search

fcorti / Alflytics

The Open Source Business Intelligence solution over the Alfresco platform.
http://fcorti.com
GNU Lesser General Public License v2.1
16 stars 11 forks source link

Comma in SQL command on Windows platform #7

Open fcorti opened 7 years ago

fcorti commented 7 years ago

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.