calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francis Chuang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1957) Cannot read HSQLDB CLOBs from avatica
Date Fri, 18 Aug 2017 05:29:00 GMT
Francis Chuang created CALCITE-1957:
---------------------------------------

             Summary: Cannot read HSQLDB CLOBs from avatica
                 Key: CALCITE-1957
                 URL: https://issues.apache.org/jira/browse/CALCITE-1957
             Project: Calcite
          Issue Type: Bug
          Components: avatica
            Reporter: Francis Chuang


HSQLDB has a CLOB type for storing character LOBs or really long strings.

I created a table like so:
{code}
CREATE TABLE some_table (
	int INTEGER PRIMARY KEY,
	clob CLOB,
)
{code}

I inserted the CLOB using the STRING rep type. The insert works correctly.

However, if I execute `SELECT * FROM some_table`, I get this error from avatica:

{code}
RuntimeException: Unhandled type in Frame: class org.hsqldb.jdbc.JDBCClobClient
{code}

It seems to be thrown here because Avatica is not able to handle the CLOB type: https://github.com/apache/calcite-avatica/blob/4db1fb9c66db8ccebc9e96ce678154ec69c557f0/core/src/main/java/org/apache/calcite/avatica/remote/TypedValue.java#L865



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

Mime
View raw message