[
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 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}
was:
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!
> 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)
