Debian Codegraph @

mysql-test/suite/innodb/r/index_vcol_purge_startup.result

raw
1 call mtr.add_suppression('SQL_ERROR_LOG');
2 call mtr.add_suppression('Failed to initialize plugins');
3 call mtr.add_suppression('Aborting');
4 create table t1(a int primary key, b int as (100-a*a), index(b)) engine=innodb;
5 insert t1 (a) values(1),(2),(3);
6 start transaction;
7 select * from t1 order by a;
8 a b
9 1 99
10 2 96
11 3 91
12 connect con1, localhost, root;
13 delete from t1 where a=2;
14 flush tables;
15 connection default;
16 # Kill the server
17 # Failed restart
18 # Start the server
19 # restart
20 select * from t1 order by a;
21 a b
22 1 99
23 3 91
24 drop table t1;