Querying view that uses LTRIM/RTRIM results in a syntax error #2842
Description
Consider the following statements:
CREATE TABLE T0(c0 VARCHAR);
CREATE VIEW v0(c0) AS SELECT RTRIM(c0) FROM T0 ;
SELECT * FROM V0; -- Syntax error in SQL statementUnexpectedly, the SELECT results in a syntax error with the following stack trace:
Caused by: org.h2.message.DbException: Syntax error in SQL statement "SELECT
TRIM(TRAILING ""C0"")[*]
FROM ""PUBLIC"".""T0"""; expected "(, ., [, ::, AT, FORMAT, *, /, %, +, -, ||, NOT, IS, ILIKE, REGEXP, AND, OR, FROM" [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.readTrimFunction(Parser.java:4676)
at org.h2.command.Parser.readBuiltinFunctionIf(Parser.java:4475)
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.readExpression(Parser.java:3313)
at org.h2.command.Parser.parseSelectExpressions(Parser.java:3140)
at org.h2.command.Parser.parseSelect(Parser.java:3159)
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 fdbb3b8.