Thursday, September 25, 2014

H2 LIMIT and OFFSET

Funny thing - H2 in PostgreSQL compatibility mode requires that OFFSET should go strictly after LIMIT (like LIMIT 25 OFFSET 50). Otherwise it can't parse the query:
error in SQL statement "SELECT ..........   OFFSET 0  LIMIT[*] 25 "; 
expected "[, ::, *, /, %, +, -, ||, ~, !~, NOT, 
LIKE, REGEXP, IS, IN, BETWEEN, AND, OR, ROW, ROWS"