[ https://issues.apache.org/jira/browse/CALCITE-6178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17804429#comment-17804429 ]
Hanumath Rao Maduri edited comment on CALCITE-6178 at 1/8/24 7:06 PM: ---------------------------------------------------------------------- [~julianhyde] This [PR|https://github.com/apache/calcite/commit/22b424e5f2084dd1c352ddeb752a8fd8bfa288b0] was already merged. I can take care of the suggestion in an other commit. [~mbudiu] -Can you please close the Jira as FIXED.- was (Author: hanu.ncr): [~julianhyde] This [PR|https://github.com/apache/calcite/commit/22b424e5f2084dd1c352ddeb752a8fd8bfa288b0] was already merged. I can take care of the suggestion in an other commit. [~mbudiu] Can you please close the Jira as FIXED. > WITH RECURSIVE query when cloned using SqlShuttle loses RECURSIVE property > -------------------------------------------------------------------------- > > Key: CALCITE-6178 > URL: https://issues.apache.org/jira/browse/CALCITE-6178 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.36.0 > Reporter: Hanumath Rao Maduri > Assignee: Hanumath Rao Maduri > Priority: Major > Labels: pull-request-available > Fix For: 1.37.0 > > > Here is a test case which shows that a recursive query becomes a non > recursive query when cloned using SqlShuttle. > Copy paste the below test case in SqlParserTest > {code:java} > @Test void testRecursiveQueryCloned() throws Exception { > SqlNode sqlNode = sql("with RECURSIVE emp2 as " > + "(select * from emp union select * from emp2) select * from > emp2").parser().parseStmt(); > SqlNode sqlNode1 = sqlNode.accept(new SqlShuttle() { > @Override public SqlNode visit(SqlIdentifier identifier) { > return new SqlIdentifier(identifier.names, > identifier.getParserPosition()); > } > }); > System.out.println(sqlNode1.toSqlString(c -> > c.withAlwaysUseParentheses(false)).getSql()); > }{code} > The above test case generates following output. > {code:java} > WITH "EMP2" AS (SELECT * > FROM "EMP" > UNION > SELECT * > FROM "EMP2") SELECT * > FROM "EMP2"{code} > -- This message was sent by Atlassian Jira (v8.20.10#820010)