Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
Description
The page "Permitted statements" lists the commands that are allowed to be prepared.
Unfortunately, there is no list which lists the commands that are currently not allowed in prepare and should be supported in future versions.
The following list is not complete and should be expanded.
- CREATE/ALTER/DROP PROCEDURE
- CREATE/ALTER/DROP EVENT
- CREATE/ALTER/DROP FUNCTION
DELETE FROM (bulk insert not supported)- LOAD DATA
- ALTER DATABASE
- USE
- XA BEGIN
- XA END
- XA RECOVER
- XA PREPARE
- XA COMMIT
- XA ROLLBACK
- HELP
Attachments
Issue Links
- blocks
-
CONJ-844 Performance improvement for 10.6 server
-
- Closed
-
-
CONPY-90 XA test fail (SQL Alchemy)
-
- Confirmed
-
- causes
-
MDEV-29329 Some MTR tests fail with PS protocol (missing warnings)
-
- Open
-
-
MDEV-30772 Inconsistency in handling empty comments in direct vs prepared execution
-
- Open
-
- is blocked by
-
MDEV-24860 Incorrect behaviour of SET STATEMENT in case it is executed as a prepared statement
-
- Closed
-
-
MDEV-25006 Failed assertion on executing EXPLAIN DELETE statement as a prepared statement
-
- Closed
-
-
MDEV-25108 Running of the EXPLAIN EXTENDED statement produces extra warning in case it is executed in PS (prepared statement) mode
-
- Closed
-
-
MDEV-25197 The statement set password=password('') executed in PS mode fails in case it is run by a user with expired password
-
- Closed
-
- is duplicated by
-
MDEV-28997 Drop TRIGGERs, FUNCTIONs and ROUTINEs from prepared statement
-
- Closed
-
- relates to
-
MDEV-10865 COLLATE keyword doesn't work in PREPARE query
-
- Closed
-
-
MDEV-24392 execute immediate '/*M!100601 select 10_6_only_sql */' returns error incorrectly
-
- Open
-
-
MDEV-25302 Attempt to set some system variables in PS mode results in issuing the error "ERROR 1615 (HY000): Prepared statement needs to be re-prepared"
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE PROCEDURE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE PROCEDURE * DROP PROCEDURE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE PROCEDURE * DROP PROCEDURE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
Link |
This issue relates to |
Summary | Not supported statements in binary protocol. | Unsupported statements in binary protocol. |
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * DELETE FROM (bulk insert not supported) * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
Assignee | Sergei Golubchik [ serg ] |
Assignee | Sergei Golubchik [ serg ] |
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * DELETE FROM (bulk insert not supported) * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
Component/s | Binary Protocol [ 16120 ] |
Fix Version/s | 10.6 [ 24028 ] |
Assignee | Oleksandr Byelkin [ sanja ] |
Rank | Ranked higher |
Summary | Unsupported statements in binary protocol. | Unsupported commands in for prepared statements |
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in the binary protocol and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in prepare and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed in the binary protocol.
Unfortunately, there is no list which lists the commands that are currently not allowed in prepare and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed to be prepared.
Unfortunately, there is no list which lists the commands that are currently not allowed in prepare and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
Summary | Unsupported commands in for prepared statements | Unsupported commands for prepared statements |
Assignee | Oleksandr Byelkin [ sanja ] | Dmitry Shulga [ JIRAUSER47315 ] |
Priority | Major [ 3 ] | Critical [ 2 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Labels | CONNECTOR_RELATED |
Summary | Unsupported commands for prepared statements | Unsupported commands for prepared statements |
Link |
This issue is blocked by |
Link |
This issue is blocked by |
Link |
This issue is blocked by |
Link |
This issue is blocked by |
Assignee | Dmitry Shulga [ JIRAUSER47315 ] | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] |
Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Dmitry Shulga [ JIRAUSER47315 ] |
Link |
This issue is blocked by |
Priority | Critical [ 2 ] | Blocker [ 1 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue is blocked by |
Fix Version/s | 10.6.2 [ 25800 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Fix Version/s | 10.6.3 [ 25904 ] | |
Fix Version/s | 10.6.2 [ 25800 ] |
Fix Version/s | 10.6.2 [ 25800 ] | |
Fix Version/s | 10.6.3 [ 25904 ] |
Workflow | MariaDB v3 [ 88301 ] | MariaDB v4 [ 133625 ] |
Link |
This issue is duplicated by |
Link | This issue causes MDEV-29329 [ MDEV-29329 ] |
Link | This issue relates to MDEV-24392 [ MDEV-24392 ] |
Link | This issue causes MDEV-30772 [ MDEV-30772 ] |
Description |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed to be prepared.
Unfortunately, there is no list which lists the commands that are currently not allowed in prepare and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK |
The page ["Permitted statements"|https://mariadb.com/kb/en/library/prepare-statement/#permitted-statements] lists the commands that are allowed to be prepared.
Unfortunately, there is no list which lists the commands that are currently not allowed in prepare and should be supported in future versions. The following list is not complete and should be expanded. * CREATE/ALTER/DROP PROCEDURE * CREATE/ALTER/DROP EVENT * CREATE/ALTER/DROP FUNCTION * -DELETE FROM (bulk insert not supported)- * LOAD DATA * ALTER DATABASE * USE * XA BEGIN * XA END * XA RECOVER * XA PREPARE * XA COMMIT * XA ROLLBACK * HELP |
Zendesk Related Tickets | 127210 |
Another command that failed using binary protocol using COLLATE.
example :