| 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; |