GitHub

SQL syntax error when there is no error - SQL Error [156] [S0001]: Incorrect syntax near ...

-- cast(SUM(DATEDIFF(SECOND, DepartureBest, ArrivalBest)) / 3600 as varchar), ':', -- concat('0' , cast((SUM(DATEDIFF(SECOND, DepartureBest, ArrivalBest)) % 3600 / 60 ...
GitHub

[regression] Syntax error on valid query: expected "INTERSECTS (, NOT, EXISTS, UNIQUE ...

The following query worked on H2 1.4.200 (and MySQL, PostgreSQL as well) but fails after update to 2.2.224: Syntax error in SQL statement "SELECT * FROM params WHERE ...