[
https://issues.apache.org/jira/browse/CALCITE-5242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17598159#comment-17598159
]
Jianhui Dong commented on CALCITE-5242:
---------------------------------------
Thanks for your response, [~libenchao], I save the CALCITE-4456 and I thought
you are right!
However, I have one more question about the issue, I had a custom parser that
extended Parser.jj with DDL `CREATE TABLE ...`, `CREATE VIEW ...`, etc with
calcite v1.26 too, and I could parse the sql correctly with my parser. As you
can see, the sql is a DML that should be parsed by the native calcite parser.
I'm confused with the problem for a while days, can you give me some
suggestions or ideas to help me figure it out?
> SQL query of row function call with nested map cannot be parsed
> ---------------------------------------------------------------
>
> Key: CALCITE-5242
> URL: https://issues.apache.org/jira/browse/CALCITE-5242
> Project: Calcite
> Issue Type: Bug
> Reporter: Jianhui Dong
> Priority: Major
> Attachments: image-2022-08-23-12-12-42-044.png
>
>
> I am not sure if this is a bug, calcite can not parse
> {code:java}
> select row(map['1']) FROM tableA
> {code}
> correctly, it would throw an exception as follows:
> {code:java}
> org.apache.calcite.sql.parser.SqlParseException: Encountered "[" at line 1,
> column 16.
> Was expecting one of:
> ")" ...
> "," ...
> {code}
> However, I had a parser that extended Parser.jj with custom DDL, and it could
> parse this DML normally.
> {code:java}
> @Test
> public void testSelectCase() throws Exception {
> String dml = "select row(map['1']) FROM tableA";
> parse(XflowSqlParserImpl.FACTORY, dml);
> parse(SqlParserImpl.FACTORY, dml);
> }
> private void parse(SqlParserImplFactory factory, String dml) throws
> SqlParseException {
> final SqlParser.Config configBuilder =
> SqlParser.config()
> .withParserFactory(factory)
> .withQuoting(Quoting.DOUBLE_QUOTE)
> .withUnquotedCasing(Casing.TO_UPPER)
> .withQuotedCasing(Casing.UNCHANGED)
> .withConformance(SqlConformance.DEFAULT);
> UnaryOperator<SqlParser.Config> transform = UnaryOperator.identity();
> Config config = transform.apply(configBuilder);
> SqlParser sqlParser = SqlParser.create(new StringReader(dml), config);
> SqlNode sqlNode = sqlParser.parseStmt();
> System.out.println(sqlNode);
> } {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
