[CALCITE-5243] SELECT NULL AS C causes NoSuchMethodException: java.sql.ResultSet.getVoid(int)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.32.0
• Labels: pull-request-available

Environment

Calcite 1.31.0

• Assignee: Mou Wu
• Reporter: Ulrich Kramer
• Created: 25/Aug/22 11:01
• Updated: 10/Sep/22 08:40
• Resolved: 30/Aug/22 00:59

Description

Adding the following unit test to JdbcAdapterTest will reproduce the bug

 

  @Test void testNullSelect() {
    final String sql = "select NULL AS C from  \"days\"";
    CalciteAssert.model(FoodmartSchema.FOODMART_MODEL)
        .query(sql)
        .runs()
        .returnsCount(14);
  }

 

Issue Links

• links to: GitHub Pull Request #2886