Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10142 PL/SQL parser
  3. MDEV-10709

Expressions as parameters to Dynamic SQL

Details

    • 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

    Description

      MariaDB allows to use only user variables in EXECUTE..USING:

      EXECUTE stmt USING @a;

      Under terms of this task, we'll allow passing expressions as parameters to Dynamic SQL:

      PREPARE stmt FROM 'SELECT ? FROM t1';
      		 
      EXECUTE stmt USING 1+2;

      Note, these expression types should work as output parameters (in addition to user variables):

      • SP variables
      • Trigger NEW and OLD fields

      Note, stored functions and subselects as parameters will not be supported under terms of this task. Using stored functions and subselects would require some additional changes in table locking, SP cache and transaction handling (for the same reason, SET STATEMENT disallows stored functions and subselects as variable values). So the following scripts will return errors:

      PREPARE stmt FROM 'SELECT ? FROM DUAL';
      		 
      EXECUTE stmt USING (SELECT 1);


      CREATE FUNCTION f1() RETURNS VARCHAR(10) RETURN 'test';
      		 
      PREPARE stmt FROM 'SELECT ? FROM DUAL';
      		 
      EXECUTE stmt USING f1();

      Support for stored functions and subselects as parameters (as well as in SET STATEMENT variable values) will be added under terms of a separate task.

      Attachments

        Issue Links

          blocks

          Technical task - A technical task. MDEV-10585 EXECUTE IMMEDIATE statement

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10702 Crash in SET STATEMENT FOR EXECUTE

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-10772 Introduce Item_param::CONVERSION_INFO

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-11360 Dynamic SQL: DEFAULT as a bind parameter

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-10801 sql_mode=ORACLE: Dynamic SQL placeholders

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-11781 sql_mode=ORACLE: IN, OUT, IN OUT modes for dynamic SQL bind arguments

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14270 Dynamic CREATE TABLE does not preserve the data type of SP variables with NULL value

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14271 Dynamic SQL: TIMESTAMP parameter value is not preserved on timezone change

          • Major - Major loss of function.
          • Open

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.