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

Warning of full history partition is one command late

    XMLWordPrintable

    Details

      Description

      Reproduce

      # Truncate partitioned
      create or replace table t (a int) with system versioning
      partition by system_time limit 1 partitions 3;
      insert into t values (1);
      update t set a= 2;
      update t set a= 3;
      delete history from t;
      Warnings:
      Warning	4114	Versioned table `test`.`t`: last HISTORY partition (`p1`) is out of LIMIT, need more HISTORY partitions
      # The above warning is one command late (MDEV-20345) ^^^
      

      Optimize calling vers_set_hist_part()

      1. Look for TODO in `ha_partition::external_lock()` and `ha_partition::start_stmt()` and add more excluding conditions.

      2. Add test cases for INSERT SELECT, REPLACE SELECT, etc.

      3. Test INSERT and history modification setting. Should limits be followed when inserting into history partition?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: