[
https://issues.apache.org/jira/browse/CALCITE-5242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li closed CALCITE-5242.
-------------------------------
Resolution: Duplicate
> 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)
