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

Unsupported commands for prepared statements

    XMLWordPrintable

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

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          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.
          • Closed

          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

            People

              shulga Dmitry Shulga
              georg Georg Richter
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 5d Original Estimate - 5d
                  5d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 74d 2.25h
                  74d 2.25h

                  Git Integration

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