Julian Hyde created CALCITE-1563:
------------------------------------

             Summary: In case-insensitive connection, non-existent tables use 
alphabetically preceding table
                 Key: CALCITE-1563
                 URL: https://issues.apache.org/jira/browse/CALCITE-1563
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


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

{code}
  @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");
  }
{code}

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to