From e36c5ec0a50332840c7dcb8e6b08a369ec2a829c Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Wed, 21 Feb 2018 15:16:19 +0100 Subject: PARTITION BY SYSTEM_TIME INTERVAL ... Lots of changes: * calculate the current history partition in ::external_lock(), not in ::write_row() or ::update_row() * remove dynamically collected per-partition row_end stats * no full table scan in open_table_from_share to calculate these stats, no manual MDL/thr_locks in open_table_from_share * no shared stats in TABLE_SHARE = no mutexes or condition waits when calculating current history partition * always compare timestamps, don't convert them to MYSQL_TIME (avoid DST ambiguity, and it's faster too) * correct interval handling, 1 month = 1 month, not 30 * 24 * 3600 seconds * save/restore first partition start time, and count intervals from there * only allow to drop first partitions if INTERVAL * when adding new history partitions, split the data in the last history parition, if it was overflowed * show partition boundaries in INFORMATION_SCHEMA.PARTITIONS --- mysql-test/suite/versioning/r/truncate.result | 2 -- 1 file changed, 2 deletions(-) (limited to 'mysql-test/suite/versioning/r/truncate.result') diff --git a/mysql-test/suite/versioning/r/truncate.result b/mysql-test/suite/versioning/r/truncate.result index 68f37aaf4ef..33f21d6245b 100644 --- a/mysql-test/suite/versioning/r/truncate.result +++ b/mysql-test/suite/versioning/r/truncate.result @@ -56,8 +56,6 @@ partition pn current); insert into t values (1); update t set a= 2; update t set a= 3; -Warnings: -Note 4114 Versioned table `test`.`t`: switching from partition `p0` to `p1` delete history from t; select * from t for system_time all; a -- cgit v1.2.1