[CALCITE-667] AvaticaResultSet.execute expecting Array Iterable from Delete Statement

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: avatica
• Labels: avatica
• Assignee: Unassigned
• Reporter: Ng Jiunn Jye
• Created: 06/Apr/15 15:53
• Updated: 22/Feb/19 01:22

Description

Delete execution should return the number of rows impacted. However
AvaticaResultStatement.execute was expecting an array. See error stack trace below.

This is caused by the CalcitePrepareImpl.prepare_2 RelDataType createDmlRowType is not defined properly for SqlKind DELETE. Same problem for UPDATE

Error Stack:
Caused by: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0
at java.util.Arrays$ArrayList.get(Arrays.java:2877)
at org.apache.calcite.avatica.util.RecordIteratorCursor.createGetter(RecordIteratorCursor.java:59)
at org.apache.calcite.avatica.util.AbstractCursor.createAccessor(AbstractCursor.java:80)
at org.apache.calcite.avatica.util.AbstractCursor.createAccessors(AbstractCursor.java:70)
at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187)