Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16278

Missing DELETE operation in COM_STMT_BULK_STMT

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.14, 10.3.6
    • 10.2.20
    • OTHER
    • None

    Description

      Current Bulk command (COM_STMT_BULK_STMT) permit insert, update, but not DELETE operations.

      That is a pain because for JDBC, API permit to indicate if the query will have a resultset or not.
      I don't see any reason for not permitting it.
      One advantage is having only one OK_Packet as a results compared to sending lots of queries with each one having an OK_Packet

      Change is just setting a flag to permit this kind of operation.
      The current result is an error "This command is not supported in the prepared statement protocol yet"

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. CONPY-20 executemany() error

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-12471 BULK Command

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sanja Oleksandr Byelkin added a comment -

            revision-id: a80a08e8e7523203170a26bdef8c4824a3dc9afc (mariadb-10.2.19-51-ga80a08e8e75)
            parent(s): ad3346dddf419aed3e5d16066471fd5022af1795
            author: Oleksandr Byelkin
            committer: Oleksandr Byelkin
            timestamp: 2018-12-13 17:06:26 +0100
            message:

            MDEV-16278: Missing DELETE operation in COM_STMT_BULK_STMT

            Allow array binding for DELETE, test it.

            —

            sanja Oleksandr Byelkin added a comment - revision-id: a80a08e8e7523203170a26bdef8c4824a3dc9afc (mariadb-10.2.19-51-ga80a08e8e75) parent(s): ad3346dddf419aed3e5d16066471fd5022af1795 author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2018-12-13 17:06:26 +0100 message: MDEV-16278 : Missing DELETE operation in COM_STMT_BULK_STMT Allow array binding for DELETE, test it. —
            georg Georg Richter added a comment -

            Ok to push

            georg Georg Richter added a comment - Ok to push

            People

              sanja Oleksandr Byelkin
              diego dupin Diego Dupin
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.