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)
