-
Bug
-
Resolution: Done
-
Major
-
9.1.3.Final, 9.2.0.Final
-
None
The below code applies ON function to the data column, it should be the key column
upsertRowSql = String.format("MERGE %1$s WITH (TABLOCK) " + "USING (VALUES (?, ?, ?)) AS tmp (%2$s, %3$s, %4$s) " + "ON (%1$s.%2$s = tmp.%2$s) " + "WHEN MATCHED THEN UPDATE SET %3$s = tmp.%3$s, %4$s = tmp.%4$s " + "WHEN NOT MATCHED THEN INSERT (%2$s, %3$s, %4$s) VALUES (tmp.%2$s, tmp.%3$s, tmp.%4$s);", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName());
- is related to
-
JDG-1462 REMOTE JDBC CacheStore failing upsert on MSSql 2012
- Closed