diff options
| -rw-r--r-- | mysql-test/suite/period/r/overlaps.result | 44 | ||||
| -rw-r--r-- | mysql-test/suite/period/t/overlaps.test | 2 |
2 files changed, 29 insertions, 17 deletions
diff --git a/mysql-test/suite/period/r/overlaps.result b/mysql-test/suite/period/r/overlaps.result index 51c4007a4af..096ad0497b7 100644 --- a/mysql-test/suite/period/r/overlaps.result +++ b/mysql-test/suite/period/r/overlaps.result @@ -163,7 +163,7 @@ t1 CREATE TABLE `t1` ( `e` date NOT NULL, PERIOD FOR `p` (`s`, `e`), PRIMARY KEY (`id`,`p` WITHOUT OVERLAPS) -) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING +) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1 create or replace table t1 (x int, s date, e date, period for p(s,e), primary key(x, p without overlaps)); @@ -376,29 +376,39 @@ id s e val deallocate prepare stmt; # auto_increment alter table t add pk int primary key auto_increment; +select * from t; +id s e val pk +1 2003-01-05 2003-02-01 8 2 +1 2003-02-01 2003-05-05 11 4 +1 2003-05-05 2003-06-01 8 3 +1 2003-07-01 2003-08-01 9 1 +2 2003-01-05 2003-01-10 23 5 +2 2003-01-10 2003-05-01 21 6 +2 2003-05-01 2003-07-10 22 8 +2 2003-08-01 2003-09-01 19 7 replace t(id, s, e, val) values (2, '2003-06-01', '2003-08-15', 23); select * from t; id s e val pk -1 2003-01-05 2003-02-01 8 1 -1 2003-02-01 2003-05-05 11 5 -1 2003-05-05 2003-06-01 8 2 -1 2003-07-01 2003-08-01 9 4 -2 2003-01-05 2003-01-10 23 7 +1 2003-01-05 2003-02-01 8 2 +1 2003-02-01 2003-05-05 11 4 +1 2003-05-05 2003-06-01 8 3 +1 2003-07-01 2003-08-01 9 1 +2 2003-01-05 2003-01-10 23 5 2 2003-01-10 2003-05-01 21 6 -2 2003-05-01 2003-06-01 22 9 -2 2003-06-01 2003-08-15 23 11 -2 2003-08-15 2003-09-01 19 10 +2 2003-05-01 2003-06-01 22 10 +2 2003-06-01 2003-08-15 23 12 +2 2003-08-15 2003-09-01 19 11 insert t(id, s, e, val) values (2, '2003-05-15', '2003-08-20', 24) on duplicate key update val = 25; select * from t; id s e val pk -1 2003-01-05 2003-02-01 8 1 -1 2003-02-01 2003-05-05 11 5 -1 2003-05-05 2003-06-01 8 2 -1 2003-07-01 2003-08-01 9 4 -2 2003-01-05 2003-01-10 23 7 +1 2003-01-05 2003-02-01 8 2 +1 2003-02-01 2003-05-05 11 4 +1 2003-05-05 2003-06-01 8 3 +1 2003-07-01 2003-08-01 9 1 +2 2003-01-05 2003-01-10 23 5 2 2003-01-10 2003-05-01 21 6 -2 2003-05-15 2003-06-01 25 9 -2 2003-06-01 2003-08-15 25 11 -2 2003-08-15 2003-08-20 25 10 +2 2003-05-15 2003-06-01 25 10 +2 2003-06-01 2003-08-15 25 12 +2 2003-08-15 2003-08-20 25 11 create or replace database test; diff --git a/mysql-test/suite/period/t/overlaps.test b/mysql-test/suite/period/t/overlaps.test index ea2603ca7ff..058e9ccd027 100644 --- a/mysql-test/suite/period/t/overlaps.test +++ b/mysql-test/suite/period/t/overlaps.test @@ -294,6 +294,8 @@ deallocate prepare stmt; --echo # auto_increment alter table t add pk int primary key auto_increment; +--sorted_result +select * from t; replace t(id, s, e, val) values (2, '2003-06-01', '2003-08-15', 23); --sorted_result |