Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.14, 10.3.6
-
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
-
-
- Closed
-
- relates to
-
MDEV-12471 BULK Command
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| 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 query will have a resultset or not. I don't see any reason for not permitting it, even if not optimized for now. |
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 query will have a resultset or not. I don't see any reason for not permitting it, even if not optimized for now. Change is just setting a flag to permit this kind of operation. Current result is an error "This command is not supported in the prepared statement protocol yet" |
| 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 query will have a resultset or not. I don't see any reason for not permitting it, even if not optimized for now. Change is just setting a flag to permit this kind of operation. Current result is an error "This command is not supported in the prepared statement protocol yet" |
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, even if not optimized for now. 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" |
| Affects Version/s | 10.2.14 [ 22911 ] | |
| Affects Version/s | 10.2.15 [ 23006 ] |
| 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, even if not optimized for now. 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" |
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" |
| Key |
|
|
| Affects Version/s | 10.2.14 [ 22911 ] | |
| Affects Version/s | 10.3.6 [ 23003 ] | |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Project | MariaDB Server [ 10000 ] | MariaDB Connector/J [ 10301 ] |
| Fix Version/s | 2.3.0 [ 22641 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | diego dupin [ diego dupin ] |
| Assignee | diego dupin [ diego dupin ] | Oleksandr Byelkin [ sanja ] |
| Fix Version/s | 2.3.0 [ 22641 ] | |
| Key |
|
|
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Project | MariaDB Connector/J [ 10301 ] | MariaDB Server [ 10000 ] |
| Affects Version/s | 10.3.6 [ 23003 ] | |
| Affects Version/s | 10.2.14 [ 22911 ] |
| Fix Version/s | 10.2 [ 14601 ] |
| Priority | Minor [ 4 ] | Critical [ 2 ] |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Georg Richter [ georg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Georg Richter [ georg ] | Oleksandr Byelkin [ sanja ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Component/s | OTHER [ 10125 ] | |
| Fix Version/s | 10.2.20 [ 23212 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 87424 ] | MariaDB v4 [ 154419 ] |
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_STMTAllow array binding for DELETE, test it.
—