Anton Kovalevsky created CALCITE-6344: -----------------------------------------
Summary: RelToSqlConverter invalid quotation for arrays and item operator(ansi dialect) Key: CALCITE-6344 URL: https://issues.apache.org/jira/browse/CALCITE-6344 Project: Calcite Issue Type: Bug Reporter: Anton Kovalevsky The context: * Ansi Dialect * having array of objects * get an object by id and get property "books"[0]."title" turns into ```books``[0]`.`title` I added test case to RelToSqlConverterTest to show what I met: {code:java} @Test void testSqlItemOperator2() { new Sql(CalciteAssert.SchemaSpec.BOOKSTORE, "SELECT MAP['title', \"books\"[0].\"title\"] from \"bookstore\".\"authors\"", AnsiSqlDialect.DEFAULT, SqlParser.Config.DEFAULT, ImmutableSet.of(), UnaryOperator.identity(), null, ImmutableList.of()) .withSql("SELECT \"books\"[0].\"title\" from \"bookstore\".\"authors\"") .schema(CalciteAssert.SchemaSpec.BOOKSTORE) .ok("SELECT `books`[0].`title` FROM `bookstore`.`authors`"); } {code} {noformat} java.lang.AssertionError: Expected: is "SELECT `books`[0].`title` FROM `bookstore`.`authors`" but: was "SELECT ```books``[0]`.`title`\nFROM `bookstore`.`authors`"{noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)