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)