mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
4c16ec3e77
In any test that uses wait_all_purged.inc, ensure that InnoDB tables
will be created without persistent statistics.
This is a follow-up to commit cd04673a17
after a similar failure was observed in the innodb_zip.blob test.
67 lines
1.7 KiB
Text
67 lines
1.7 KiB
Text
--source include/have_innodb.inc
|
|
|
|
SET @save_stats_persistent = @@GLOBAL.innodb_stats_persistent;
|
|
SET GLOBAL innodb_stats_persistent = 0;
|
|
|
|
connect (purge_control,localhost,root);
|
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
|
|
connection default;
|
|
|
|
# Index on virtual column
|
|
|
|
create table t1(f1 int not null, f2 blob not null, f3 blob not null,
|
|
vchar char(2) as (substr(f3,2,2)) virtual,
|
|
primary key(f1, f3(5)), index(vchar))engine=innodb;
|
|
|
|
insert into t1(f1,f2,f3) values(1, repeat('a',8000), repeat('b', 9000));
|
|
|
|
update t1 set f1=5 where f1=1;
|
|
delete from t1 where f1=5;
|
|
|
|
connection purge_control;
|
|
COMMIT;
|
|
--source ../../innodb/include/wait_all_purged.inc
|
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
connection default;
|
|
|
|
drop table t1;
|
|
|
|
# Index on virtual column and blob
|
|
|
|
create table t1(f1 int not null, f2 blob not null, f3 blob not null,
|
|
vchar char(2) as (substr(f3,2,2)) virtual,
|
|
primary key(f1, f3(5)), index(vchar, f3(2)))engine=innodb;
|
|
|
|
insert into t1(f1,f2,f3) values(1, repeat('a',8000), repeat('b', 9000));
|
|
|
|
update t1 set f1=5 where f1=1;
|
|
delete from t1 where f1=5;
|
|
|
|
connection purge_control;
|
|
COMMIT;
|
|
--source ../../innodb/include/wait_all_purged.inc
|
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
connection default;
|
|
drop table t1;
|
|
|
|
# Index on virtual column of blob type
|
|
|
|
create table t1(f1 int not null, f2 blob not null, f3 blob not null,
|
|
vchar blob as (f3) virtual,
|
|
primary key(f1, f3(5)), index(vchar(3)))engine=innodb;
|
|
|
|
insert into t1(f1,f2,f3) values(1, repeat('a',8000), repeat('b', 9000));
|
|
|
|
update t1 set f1=5 where f1=1;
|
|
delete from t1 where f1=5;
|
|
|
|
connection purge_control;
|
|
COMMIT;
|
|
--source ../../innodb/include/wait_all_purged.inc
|
|
disconnect purge_control;
|
|
|
|
connection default;
|
|
drop table t1;
|
|
|
|
SET GLOBAL innodb_stats_persistent = @save_stats_persistent;
|