[jira] [Commented] (CALCITE-778) Meta doesn't support executing parameterized statement with update count

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14634100#comment-14634100 ] 

Julian Hyde commented on CALCITE-778:
-------------------------------------

Is this a duplicate of CALCITE-705?

> Meta doesn't support executing parameterized statement with update count
> ------------------------------------------------------------------------
>
>                 Key: CALCITE-778
>                 URL: https://issues.apache.org/jira/browse/CALCITE-778
>             Project: Calcite
>          Issue Type: Improvement
>          Components: avatica
>            Reporter: Lukas Lalinsky
>            Assignee: Julian Hyde
>
> The Meta interface only supports operations prepareAndExecute, prepare and fetch. From these, prepareAndExecute is the only one that returns a ResultSet with update count, but prepareAndExecute doesn't supports parameters. If you want to use parameters, you need to use prepare and fetch, but then you don't get the ResultSet object back, because fetch only returns the frame with data. I think the best option would be to split the current fetch method into execute (which return the same result as prepareAndExecute) and fetch (which would be only used for iterating over the result set).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)