[jira] [Created] (CALCITE-1958) Cannot create Schema objects when using Avatica with HSQLDB

[Francis Chuang (JIRA)]

Francis Chuang created CALCITE-1958:
---------------------------------------

             Summary: Cannot create Schema objects when using Avatica with 
HSQLDB
                 Key: CALCITE-1958
                 URL: https://issues.apache.org/jira/browse/CALCITE-1958
             Project: Calcite
          Issue Type: Bug
          Components: avatica
            Reporter: Francis Chuang


Encountered this one while porting a test from Phoenix to Avatica with HSQLDB 
for the Go client.

This happens whether I open the connection with or without a default schema to 
Avatica.

I then create a schema: `CREATE SCHEMA IF NOT EXISTS avaticatest`.

I then attempt to create a table:
{code}
CREATE TABLE avaticatest.some_table (
  int INTEGER PRIMARY KEY
)
{code}

Avatica fails with this message: 
{code}
An error was encountered while processing your request: RuntimeException: 
java.sql.SQLException: invalid schema name: avaticatest in statement [CREATE 
TABLE avaticatest.test1db9ecfa5b614c57bbfcae3822c6d30c (
                                                int INTEGER PRIMARY KEY
                                            )] -> SQLException: invalid schema 
name: avaticatest in statement [CREATE TABLE 
avaticatest.test1db9ecfa5b614c57bbfcae3822c6d30c (
                                                int INTEGER PRIMARY KEY
                                            )] -> HsqlException: invalid schema 
name: avaticatest
{code}

I have tried a few things that did not work:
- Making the schema name uppercase `AVATICATEST` everywhere
- Making the table name also uppercase everywhere: `SOME_TABLE`.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)