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

Document FOR loop

Details

    Description

      We need a page explaining how to use the FOR loop, similar to what we have for WHILE:
      https://mariadb.com/kb/en/library/while/

      The new article should cover all FOR loop types:

      • Integer range FOR loop
      • Explicit cursor FOR loop
      • Implicit cursor FOR loop

      and both syntax flavor:

      • SQL/PSM
      • Oracle's PL/SQL

      Attachments

        Issue Links

          relates to

          Technical task - A technical task. MDEV-10580 sql_mode=ORACLE: FOR loop statement

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-10581 sql_mode=ORACLE: Explicit cursor FOR LOOP

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-12098 sql_mode=ORACLE: Implicit cursor FOR loop

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-12314 sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-14415 Add Oracle-style FOR loop to sql_mode=DEFAULT

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            greenman Ian Gilfillan added a comment -

            To be added still:

            • Integer range FOR loop (Oracle mode)
            • Implicit cursor FOR loop (Oracle mode)
            greenman Ian Gilfillan added a comment - To be added still: Integer range FOR loop (Oracle mode) Implicit cursor FOR loop (Oracle mode)
            julien.fritsch Julien Fritsch added a comment -

            jacob.moorman from our discussion, I decided to reassign Kenneth's ticket to you?

            julien.fritsch Julien Fritsch added a comment - jacob.moorman from our discussion, I decided to reassign Kenneth's ticket to you?

            People

              dbart Daniel Bartholomew
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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