Details

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

    Description

      MariaDB uses BEGIN NOT ATOMIC to start anonymous blocks that can be used directly, outside of an SP context:
      MariaDB:

      delimiter ;;
      BEGIN NOT ATOMIC
       ...
      END;;
      

      When running with sql_mode=ORACLE, MariaDB will understand this syntax for anonymous blocks.

      DECLARE
        ...
      BEGIN
        ...
      END;;
      

      In ORACLE mode, BEGIN is same as BEGIN NOT ATOMIC

      BEGIN
       ...
      END;;
      

      This change will disallow BEGIN and BEGIN WORK as a transaction start for sql_mode=ORACLE. But one can still use START TRANSACTION if needed.

      Attachments

        Activity

          Hi Alvin,
          I'm almost done with it. Sending for Monty's review today.

          bar Alexander Barkov added a comment - Hi Alvin, I'm almost done with it. Sending for Monty's review today.

          Reviewed. Ok to push

          monty Michael Widenius added a comment - Reviewed. Ok to push

          Pushed to bb-10.2-compatibility

          bar Alexander Barkov added a comment - Pushed to bb-10.2-compatibility

          People

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