Debian Codegraph @

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

raw
1 # WL#6745 InnoDB R-tree support
2 # This test case will test R-tree split.
3
4
5 --source include/big_test.inc
6 --source include/not_valgrind.inc
7
8 # Create table with R-tree index.
9 create table t1 (c1 int, c2 geometry not null SRID 0, spatial index (c2))engine=innodb;
10
11 # Insert enough values to let R-tree split.
12 delimiter |;
13 create procedure insert_t1(IN total int)
14 begin
15 declare i int default 1;
16 while (i <= total) DO
17 insert into t1 values (i, Point(i, i));
18 set i = i + 1;
19 end while;
20 end|
21 delimiter ;|
22
23 start transaction;
24 CALL insert_t1(70000);
25 rollback;
26 check table t1;
27
28 # Clean up.
29 drop procedure insert_t1;
30 drop table t1;
31