Debian Codegraph @

mysql-test/suite/innodb_gis/t/kill_server.test

raw
1 # WL#6745 InnoDB R-tree support
2 # This test case will test R-tree multi level split.
3
4 --source include/big_test.inc
5
6 # Create table with R-tree index.
7 create table t1 (c1 int, c2 geometry not null SRID 0, spatial index (c2))engine=innodb;
8
9 # Insert enough values to let R-tree split.
10 delimiter |;
11 create procedure insert_t1(IN total int)
12 begin
13 declare i int default 1;
14 while (i <= total) DO
15 insert into t1 values (i, Point(i, i));
16 set i = i + 1;
17 end while;
18 end|
19 delimiter ;|
20
21 # Test level 1 rtree.
22 CALL insert_t1(5000);
23 select count(*) from t1;
24
25 # Check table.
26 check table t1;
27
28 # Test level 2 rtree.
29 truncate table t1;
30 CALL insert_t1(10000);
31 select count(*) from t1;
32
33 drop index c2 on t1;
34
35 create spatial index idx on t1(c2);
36
37 show create table t1;
38
39 # Check table.
40 check table t1;
41
42 # Test level 3 rtree.
43 truncate table t1;
44
45 # Test crash recovery.
46 #
47 #
48 call mtr.add_suppression("page [0-9]+ in the doublewrite buffer is not within space bounds.*");
49
50 # Test rtree enlarge recovery.
51 START TRANSACTION;
52 CALL insert_t1(5000);
53
54 COMMIT;
55
56 --source include/kill_and_restart_mysqld.inc
57
58 # Clean up.
59 drop procedure insert_t1;
60 drop table t1;