Hi all,

I've been playing around with h2 v2.1.210 and observed quite an odd behaviour when having SYSDATE Keyword inside an inner select

Running SELECT SYSDATE FROM DUAL is going to work without any issues, but using sysdate inside an inner select is going to throw an error, because it seems like sysdate is expected to be an identifier.

SELECT * FROM (SELECT SYSDATE FROM DUAL) returns

Column "SYSDATE" not found; SQL statement: CREATE FORCE VIEW ( SELECT "SYSDATE" ) AS SELECT "SYSDATE" [42122-210]