[CALCITE-4892] Conversion from String in cursor accessors

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: avatica
• Assignee: Unassigned
• Reporter: Gregory Hart
• Created: 17/Nov/21 23:49
• Updated: 18/Nov/21 11:06

Description

Numeric accessors (such as LongAccessor) of the AbstractCursor class could automatically convert strings to the appropriate numeric type.

Also, I looked to see if I could instead easily provide my own accessor implementations in Calcite, but the cursor implementation is hardcoded in CalciteResultSet and is not easy to override.

An example where this would be useful is when using the JDBC adapter with PostgreSQL and Hibernate. Hibernate is expecting this conversion to happen in the driver and fails when Calcite throws an exception: cannot convert to long.