[jira] [Created] (CALCITE-1955) Cannot insert blob into Avatica-HSQLDB table because table is read only

["Francis Chuang (JIRA)" <ji...@apache.org>]

Francis Chuang created CALCITE-1955:
---------------------------------------

             Summary: Cannot insert blob into Avatica-HSQLDB table because table is read only
                 Key: CALCITE-1955
                 URL: https://issues.apache.org/jira/browse/CALCITE-1955
             Project: Calcite
          Issue Type: Bug
          Components: avatica
            Reporter: Francis Chuang
            Assignee: Josh Elser


This might be more of a question as I am not able to find official information in the HSQLDB docs.

I am porting a test to test the insertion of binary data into a table from Phoenix to HSQLDB. The test passes when using Phoenix with avatica.

1. I created this table:
{code}
CREATE TABLE some_table (
	int INTEGER PRIMARY KEY,
	bin BLOB
)
{code}

2. I attempt to insert the data using `INSERT INTO some_table (int, bin) VALUES (?, ?)`

The binary is being sent as a `Rep_BYTE_STRING` and the data is placed in byte_values.

This is the error I receive from HSQLDB:

{code}
RuntimeException: java.sql.SQLException: org.hsqldb.HsqlException: The table data is read only -> SQLException: org.hsqldb.HsqlException: The table data is read only -> HsqlException: org.hsqldb.HsqlException: The table data is read only -> HsqlException: The table data is read only
{code}



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