[
https://issues.apache.org/jira/browse/CALCITE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14483853#comment-14483853
]
Julian Hyde commented on CALCITE-667:
-------------------------------------
I don't know whether DELETE has ever worked in Calcite. Maybe it's easy to get
it working, I don't know. But if not, should at least be able to run DELETE
against hsqldb in Avatica's RemoteDriverTest.
> AvaticaResultSet.execute expecting Array Iterable from Delete Statement
> -----------------------------------------------------------------------
>
> Key: CALCITE-667
> URL: https://issues.apache.org/jira/browse/CALCITE-667
> Project: Calcite
> Issue Type: Bug
> Reporter: Ng Jiunn Jye
> Assignee: Julian Hyde
> Labels: avatica
> Attachments:
> [CALCITE-667]AvaticaResultSet.executeExpectingArrayIterableFromDeleteStatement.patch
>
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
