[CALCITE-5299] JDBC adapter sometimes adds unnecessary parentheses around SELECT in WITH body

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Mou Wu
• Reporter: Mou Wu
• Created: 27/Sep/22 06:04
• Updated: 07/Feb/23 22:33
• Resolved: 25/Oct/22 11:23

Description

Note: This issue is related to https://issues.apache.org/jira/browse/CALCITE-5265

You should view comments in CALCITE-5265 before you view this issue.

Add a case in SqlParserTest:

 

// code placeholder
@Test void testWithSelect() {
  final String sql = "with emp2 as (select * from emp)\n"
      + "select * from emp2\n";
  final String expected = "WITH `EMP2` AS (SELECT *\n" +
      "FROM `EMP`) SELECT *\n" +
      "FROM `EMP2`";
  sql(sql).ok(expected);
} 

will fail, because actual sql is with parentheses.

 

Issue Links

• blocks: CALCITE-5252 JDBC adapter sometimes miss parentheses around SELECT in WITH_ITEM body
• links to: GitHub Pull Request #2938