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

["Lukas Lalinsky (JIRA)" <ji...@apache.org>]

Lukas Lalinsky created CALCITE-778:
--------------------------------------

             Summary: Meta doesn't support executing parametrized statement with update count
                 Key: CALCITE-778
                 URL: https://issues.apache.org/jira/browse/CALCITE-778
             Project: Calcite
          Issue Type: Improvement
            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)