[ 
https://issues.apache.org/jira/browse/CALCITE-5242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jianhui Dong updated CALCITE-5242:
----------------------------------
    Description: 
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 following:
{code:java}
org.apache.calcite.sql.parser.SqlParseException: Encountered "[" at line 1, 
column 16.
Was expecting one of:
    ")" ...
    "," ...
{code}
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! 

  was:
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! 


> 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 following:
> {code:java}
> org.apache.calcite.sql.parser.SqlParseException: Encountered "[" at line 1, 
> column 16.
> Was expecting one of:
>     ")" ...
>     "," ...
> {code}
> 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)

Reply via email to