[
https://issues.apache.org/jira/browse/CALCITE-1955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16133896#comment-16133896
]
Josh Elser commented on CALCITE-1955:
-------------------------------------
Nope, not onerous! After initial configuration (via request to INFRA) it just
happens automatically. My only concern would be whether or not it's necessary
to have two, e.g. is it somehow possible to load the scott dataset in a r/w
manner instead of as a catalog? I just don't know enough about hysqldb to say
one way or the other.
> 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
>
> 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)
