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

Unsupported commands for prepared statements

Details

    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

          Task - A task that needs to be done. CONJ-844 Performance improvement for 10.6 server

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONPY-90 XA test fail (SQL Alchemy)

          • Major - Major loss of function.
          • Confirmed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29329 Some MTR tests fail with PS protocol (missing warnings)

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30772 Inconsistency in handling empty comments in direct vs prepared execution

          • Major - Major loss of function.
          • Open
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24860 Incorrect behaviour of SET STATEMENT in case it is executed as a prepared statement

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25006 Failed assertion on executing EXPLAIN DELETE statement as a prepared statement

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25108 Running of the EXPLAIN EXTENDED statement produces extra warning in case it is executed in PS (prepared statement) mode

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25197 The statement set password=password('') executed in PS mode fails in case it is run by a user with expired password

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Task - A task that needs to be done. MDEV-28997 Drop TRIGGERs, FUNCTIONs and ROUTINEs from prepared statement

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10865 COLLATE keyword doesn't work in PREPARE query

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-24392 execute immediate '/*M!100601 select 10_6_only_sql */' returns error incorrectly

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. 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"

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            georg Georg Richter created issue -
            georg Georg Richter made changes -
            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
            georg Georg Richter made changes -
            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
            diego dupin Diego Dupin made changes -
            georg Georg Richter made changes -
            Summary Not supported statements in binary protocol. Unsupported statements in binary protocol.
            georg Georg Richter made changes -
            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
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            georg Georg Richter made changes -
            georg Georg Richter made changes -
            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
            ralf.gebhardt Ralf Gebhardt made changes -
            Component/s Binary Protocol [ 16120 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6 [ 24028 ]
            serg Sergei Golubchik made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            wlad Vladislav Vaintroub made changes -
            Summary Unsupported statements in binary protocol. Unsupported commands in for prepared statements
            wlad Vladislav Vaintroub made changes -
            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
            wlad Vladislav Vaintroub made changes -
            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
            wlad Vladislav Vaintroub made changes -
            Summary Unsupported commands in for prepared statements Unsupported commands for prepared statements
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Dmitry Shulga [ JIRAUSER47315 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            shulga Dmitry Shulga made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            diego dupin Diego Dupin made changes -
            Labels CONNECTOR_RELATED
            serg Sergei Golubchik made changes -
            Summary Unsupported commands for prepared statements Unsupported commands for prepared statements
            shulga Dmitry Shulga made changes -
            shulga Dmitry Shulga made changes -
            shulga Dmitry Shulga made changes -
            shulga Dmitry Shulga made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Dmitry Shulga [ JIRAUSER47315 ] Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Dmitry Shulga [ JIRAUSER47315 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            shulga Dmitry Shulga made changes -
            serg Sergei Golubchik made changes -
            Priority Critical [ 2 ] Blocker [ 1 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6.2 [ 25800 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            dbart Daniel Bartholomew made changes -
            Fix Version/s 10.6.3 [ 25904 ]
            Fix Version/s 10.6.2 [ 25800 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6.2 [ 25800 ]
            Fix Version/s 10.6.3 [ 25904 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 88301 ] MariaDB v4 [ 133625 ]
            serg Sergei Golubchik made changes -
            elenst Elena Stepanova made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            georg Georg Richter made changes -
            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
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 127210

            People

              shulga Dmitry Shulga
              georg Georg Richter
              Votes:
              1 Vote for this issue
              Watchers:
              11 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.