[jira] [Resolved] (CALCITE-5257) NVARCHAR is treated as "UNKNOWN TYPE" when searching Oracle

["Ruben Q L (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-5257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ruben Q L resolved CALCITE-5257.
--------------------------------
    Fix Version/s: avatica-1.23.0
       Resolution: Fixed

Fixed via https://github.com/apache/calcite-avatica/commit/af0e9e44ccff4580c1560835da62e8d593181c86

Thanks [~VAE]!

> NVARCHAR is treated as "UNKNOWN TYPE" when searching Oracle
> -----------------------------------------------------------
>
>                 Key: CALCITE-5257
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5257
>             Project: Calcite
>          Issue Type: Bug
>          Components: avatica
>    Affects Versions: avatica-1.22.0
>            Reporter: ZheHu
>            Assignee: ZheHu
>            Priority: Major
>             Fix For: avatica-1.23.0
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> When I run the following SQL to query Oracle through Calcite:
> {code:java}
> select NVARCHAR_COL from oracleSchema.t1
> {code}
> A RuntimeException is thrown by Avatica(in Method AbstractCursor.createAccessor()):
> {code:java}
> unknown type -9(which represents NVARCHAR)
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)