mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
6684989801
Preparation for MDEV-16210: replace.test: key_type combinations: PK and UNIQUE. foreign.test: Preparation for key_type combinations. Other fixes: * Merged versioning.update2 into versioning.update; * Removed test2 database and done individual drop instead.
34 lines
964 B
Text
34 lines
964 B
Text
source include/big_test.inc;
|
|
source suite/versioning/engines.inc;
|
|
source suite/versioning/common.inc;
|
|
|
|
--echo #
|
|
--echo # MDEV-15458 Segfault in heap_scan() upon UPDATE after ADD SYSTEM VERSIONING
|
|
--echo #
|
|
create or replace table t1 (a int);
|
|
insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8);
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
insert into t1 select * from t1;
|
|
|
|
--connect (con1,localhost,root,,test)
|
|
alter table t1 add system versioning;
|
|
|
|
--connection default
|
|
update t1 set a= 7 where a = 3;
|
|
update t1 set a= 2 where a = 7;
|
|
update t1 set a= 5 where a = 2;
|
|
update t1 set a= 1 where a = 5;
|
|
update t1 set a= 8 where a = 1;
|
|
update t1 set a= 4 where a = 8;
|
|
update t1 set a= 6;
|
|
|
|
drop table t1;
|
|
|
|
source suite/versioning/common_finish.inc;
|