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

sql_mode=ORACLE: FOR loop statement

Details

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

    Description

      Add support for the Oracle-style FOR loop when running in sql_mode=ORACLE

      FOR index IN [ REVERSE ] lower_bound .. upper_bound
      		 
      LOOP statements
      		 
      END LOOP [ label ] ;

      There must be at least one statement.

      The two dots must have no spaces between, otherwise an error is returned:

      BEGIN
      		 
        FOR i IN 1 .  . 10 LOOP
      		 
          NULL;
      		 
        END LOOP;
      		 
      END;
      		 
      /


      ORA-06550: line 2, column 14:
      		 
      PLS-00103: Encountered the symbol "." when expecting one of the following:
      		 
      * & - + / at mod remainder rem .. <an exponent (**)> ||
      		 
      multiset

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32275 getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO

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

          Task - A task that needs to be done. MDEV-16674 Document FOR loop

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Parent MDEV-10142 [ 56873 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            bar Alexander Barkov made changes -
            Description Add support for the Oracle-style {{FOR}} loop when running in {{sql_mode=ORACLE}}
            {code:sql}
            FOR index IN [ REVERSE ] lower_bound .. upper_bound
            LOOP statements
            END LOOP [ label ] ;
            {code}
            		Add support for the Oracle-style {{FOR}} loop when running in {{sql_mode=ORACLE}}
            {code:sql}
            FOR index IN [ REVERSE ] lower_bound .. upper_bound
            LOOP statements
            END LOOP [ label ] ;
            {code}

            There must be at least one statement.

            The two dots must have no spaces between, otherwise an error is returned:
            {code:sql}
            BEGIN
              FOR i IN 1 . . 10 LOOP
                NULL;
              END LOOP;
            END;
            /
            {code}
            {noformat}
            ORA-06550: line 2, column 14:
            PLS-00103: Encountered the symbol "." when expecting one of the following:
            * & - + / at mod remainder rem .. <an exponent (**)> ||
            multiset
            {noformat}
            bar Alexander Barkov made changes -
            Fix Version/s 10.2.2 [ 22013 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ]
            bar Alexander Barkov made changes -
            Fix Version/s 10.3.0 [ 22127 ]
            Fix Version/s 10.2.2 [ 22013 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility Compatibility NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            NRE Projects NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility NRE-307517 Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            bar Alexander Barkov made changes -
            Labels Compatibility Compatibility need_review
            bar Alexander Barkov made changes -
            Component/s Parser [ 10201 ]
            Component/s Stored routines [ 13905 ]
            Component/s OTHER [ 10125 ]
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Labels Compatibility need_review Compatibility
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76685 ] MariaDB v4 [ 150771 ]
            bar Alexander Barkov made changes -

            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.