[
https://issues.apache.org/jira/browse/CALCITE-5242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17583342#comment-17583342
]
Julian Hyde commented on CALCITE-5242:
--------------------------------------
Can you please replace the .png with text? A png is not searchable.
Calcite can parse maps; see
[SqlParserTest.testMapItem|https://github.com/apache/calcite/blob/df833083aaa33adcb3075a25f044e67c52be6667/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserTest.java#L5573].
Can you try to identify the difference between your code and this test? Use of
ROW? Use of the reserved word MAP?
> 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.
> !image-2022-08-23-12-12-42-044.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
