Debian Codegraph @

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

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