[jira] [Created] (CALCITE-5242) SQL query of row function call with nested map cannot be parsed

["Jianhui Dong (Jira)" <ji...@apache.org>]

Jianhui Dong created CALCITE-5242:
-------------------------------------

             Summary: 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
         Attachments: image-2022-08-23-12-12-42-044.png

I am not sure if this is a bug, calcite can not parse 
`select row(map['1']) FROM tableA`
correctly, it would throw an exception as following:
```
org.apache.calcite.sql.parser.SqlParseException: Encountered "[" at line 1, column 16.
Was expecting one of:
    ")" ...
    "," ...
```
However, I had a parser which 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)