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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20497 Server crashes in Item_field::used_tables upon 2nd execution of SP with UPDATE on app-versioned table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21144 Wrong result or server crash in Item_field::used_tables upon 2nd execution of SP with non-existent period

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20691 Server crashes in TABLE::insert_portion_of_time upon DELETE FOR PORTION via trigger

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19014 pure virtual method called, SIGSEGV, ASAN heap-use-after-free in Item_direct_view_ref::fix_fields

          • Major - Major loss of function.
          • Closed

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.