Details

    • Sprint:
      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

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: