Querying a view that uses the POSITION() function results in an unexpected syntax error #2839
Description
Consider the following statements:
CREATE TABLE T0(c0 INT);
CREATE VIEW v0(c0) AS SELECT * FROM T0 WHERE POSITION((C0 > 0), 0);
SELECT * FROM V0; -- Syntax error in SQL statement Unexpectedly, the SELECT results in a syntax error:
Caused by: org.h2.message.DbException: Syntax error in SQL statement "SELECT
""PUBLIC"".""T0"".""C0""
FROM ""PUBLIC"".""T0""
WHERE POSITION(""C0"" >[*] 0, 0)"; expected "(, ., [, ::, AT, FORMAT, *, /, %, +, -, ||, ,, IN" [42001-201]
at org.h2.message.DbException.getSyntaxError(DbException.java:238)
at org.h2.command.Parser.getSyntaxError(Parser.java:1260)
at org.h2.command.Parser.read(Parser.java:6063)
at org.h2.command.Parser.readBuiltinFunctionIf(Parser.java:4410)
at org.h2.command.Parser.readFunction(Parser.java:4062)
at org.h2.command.Parser.readTerm(Parser.java:5428)
at org.h2.command.Parser.readFactor(Parser.java:3655)
at org.h2.command.Parser.readSum(Parser.java:3642)
at org.h2.command.Parser.readConcat(Parser.java:3607)
at org.h2.command.Parser.readCondition(Parser.java:3390)
at org.h2.command.Parser.readExpressionWithGlobalConditions(Parser.java:3300)
at org.h2.command.Parser.parseSelect(Parser.java:3169)
at org.h2.command.Parser.parseQuerySub(Parser.java:3033)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2871)
at org.h2.command.Parser.parseQuery(Parser.java:2841)
at org.h2.command.Parser.parsePrepared(Parser.java:1070)
at org.h2.command.Parser.parse(Parser.java:1045)
at org.h2.command.Parser.parse(Parser.java:1021)
at org.h2.command.Parser.prepare(Parser.java:929)
I found this based on commit 2b77de6.