[jira] [Created] (CALCITE-5128) SQL parser doesn't seem to understand UPDATE statements with fqns

["Mike Hearn (Jira)" <ji...@apache.org>]

Mike Hearn created CALCITE-5128:
-----------------------------------

             Summary: SQL parser doesn't seem to understand UPDATE statements with fqns
                 Key: CALCITE-5128
                 URL: https://issues.apache.org/jira/browse/CALCITE-5128
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.30.0
            Reporter: Mike Hearn


The following SQL fails to parse:

{{UPDATE pz.Moon t SET t.name = ? WHERE t.obj_id = ? AND t.image IS NULL AND t.mass = ? AND t.name LIKE ? ESCAPE '#' AND t.parent_id = ?}}

This sort of query is generated by DataGrip to update cells. The error is:

{{Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered "." at line 1, column 23.}}
{{Was expecting:}}
{{    "=" ...}}
{{    }}
{{    at org.apache.calcite.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:37112)}}
{{    at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:36926)}}
{{    at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlUpdate(SqlParserImpl.java:7285)}}
{{    at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:3806)}}
{{    at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:3828)}}
{{    at org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:201)}}
{{    at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:158)}}
{{    ... 35 more}}

 



--
This message was sent by Atlassian Jira
(v8.20.7#820007)