[CALCITE-5257] NVARCHAR is treated as "UNKNOWN TYPE" when searching Oracle

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: avatica-1.22.0
• Fix Version/s: avatica-1.23.0
• Component/s: avatica
• Assignee: ZheHu
• Reporter: ZheHu
• Created: 31/Aug/22 08:26
• Updated: 19/Jan/23 21:52
• Resolved: 21/Oct/22 13:18

Description

When I run the following SQL to query Oracle through Calcite:

select NVARCHAR_COL from oracleSchema.t1

A RuntimeException is thrown by Avatica(in Method AbstractCursor.createAccessor()):

unknown type -9(which represents NVARCHAR)