diff options
| author | Nikita Malyavin <nikitamalyavin@gmail.com> | 2020-05-04 19:43:36 +1000 |
|---|---|---|
| committer | Nikita Malyavin <nikitamalyavin@gmail.com> | 2020-05-04 19:43:36 +1000 |
| commit | 60ebe590f918e3b76b6ce00e29cc99faffc08280 (patch) | |
| tree | fed32ff537d88faec367d6843eba6ef21feab94c | |
| parent | a333bfac3522a46933655fbc86a4c31edf4736ad (diff) | |
| download | mariadb-git-bb-10.5-MDEV-17395-replace.tar.gz | |
temp commit????bb-10.5-MDEV-17395-replace
| -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 |