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

2nd execution of SP does not detect ER_VERS_NOT_VERSIONED

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t1 (a INT);
      CREATE PROCEDURE sp() SELECT * FROM t1 FOR SYSTEM_TIME ALL;
      --error ER_VERS_NOT_VERSIONED
      CALL sp;
      --error ER_VERS_NOT_VERSIONED
      CALL sp;
       
      # Cleanup
      DROP TABLE t1;
      DROP PROCEDURE sp;
      

      10.3 69b33fca

      mysqltest: At line 6: query 'CALL sp' succeeded - should have failed with errno 4124...
      

      Same with DELETE HISTORY. As a side-effect, the 2nd execution is written into the binary log and breaks replication.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: