[CALCITE-1958] Cannot create Schema objects when using Avatica with HSQLDB

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.17.0
• Component/s: avatica
• Assignee: Unassigned
• Reporter: Francis Chuang
• Created: 18/Aug/17 11:31
• Updated: 29/Apr/19 17:14
• Resolved: 17/Oct/17 04:45

Description

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:

CREATE TABLE avaticatest.some_table (
  int INTEGER PRIMARY KEY
)

Avatica fails with this message:

An error was encountered while processing your request: RuntimeException: java.sql.SQLException: invalid schema name: avaticatest in statement [CREATE TABLE avaticatest.some_table (
                                                int INTEGER PRIMARY KEY
                                            )] -> SQLException: invalid schema name: avaticatest in statement [CREATE TABLE avaticatest.some_table (
                                                int INTEGER PRIMARY KEY
                                            )] -> HsqlException: invalid schema name: avaticatest

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`.

Issue Links

• Blocked: CALCITE-2013 Bump HSQLDB version in avatica