Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-778

Meta doesn't support executing parameterized statement with update count

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • 1.5.0
    • avatica
    • None

    Description

      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).

      Attachments

        Issue Links

          Activity

            People

              julianhyde Julian Hyde
              lukaslalinsky Lukas Lalinsky
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: