[CALCITE-1563] In case-insensitive connection, non-existent tables use alphabetically preceding table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 04/Jan/17 22:59
• Updated: 24/Mar/17 03:20
• Resolved: 06/Jan/17 20:53

Description

In case-insensitive connection, non-existent tables use alphabetically preceding table. For example, in JdbcTest, the following test passes

  @Test public void testLexCaseInsensitiveFindsNonExistentTable() {
    final CalciteAssert.AssertThat with =
        CalciteAssert.that().with(Lex.MYSQL);
    with.query("select COUNT(*) as c from `metaData`.`zoo`")
        .returns("c=2\n");
  }

even though there is no table called "zoo", because it finds the "tables" table instead.