Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1957

Cannot read HSQLDB CLOBs from avatica

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: avatica
    • Labels:
      None

      Description

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

      I created a table like so:

      CREATE TABLE some_table (
      	int INTEGER PRIMARY KEY,
      	clob CLOB,
      )
      

      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:

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

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              francischuang Francis Chuang
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: