[MDEV-16278] Missing DELETE operation in COM_STMT_BULK_STMT Created: 2018-05-23  Updated: 2018-12-14  Resolved: 2018-12-14

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.2.14, 10.3.6
Fix Version/s: 10.2.20

Type: Bug Priority: Critical
Reporter: Diego Dupin Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None

Attachments: Text File Permit_DELETE_commands_for_COM_STMT_BULK_EXECUTE.patch    
Issue Links:
Blocks
blocks CONPY-20 executemany() error Closed
Relates
relates to MDEV-12471 BULK Command Closed

 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"

 Comments   
Comment by Oleksandr Byelkin [ 2018-12-13 ]

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.

—

Comment by Georg Richter [ 2018-12-13 ]

Ok to push

Generated at Thu Feb 08 08:27:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.