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

Warning on full history partition is delayed until next DML statement

    Details

      Description

      Reproduce

      create or replace table t1 (x int) with system versioning partition by system_time limit 1;
      insert into t1 values (0), (1), (2), (3);
      delete from t1;
      

      Result

      No warning printed.

      Expected

      +---------+------+----------------------------------------------------------------------------------------------------------+
      | Level   | Code | Message                                                                                                  |
      +---------+------+----------------------------------------------------------------------------------------------------------+
      | Warning | 4114 | Versioned table `test`.`t1`: last HISTORY partition (`p0`) is out of LIMIT, need more HISTORY partitions |
      +---------+------+----------------------------------------------------------------------------------------------------------+
      

      Variation

      This variation displays warning on second DELETE:

      create or replace table t1 (x int) with system versioning partition by system_time limit 1;
      insert into t1 values (0), (1), (2), (3);
      delete from t1 where x < 3;
      delete from t1;
      

        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: