Debian Codegraph @

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

raw
1 # This test case will test R-tree purge.
2
3
4 --source include/have_innodb_max_16k.inc
5 --source include/have_debug.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 # Temporarily disable it for 4k page size. Since it'll take too long
11 # time.
12 --source include/not_have_innodb_4k.inc
13
14 create table t (
15 a point not null,b point not null SRID 0,c point,
16 d point not null SRID 0,e point,f point,
17 spatial key (d),spatial key (b)
18 ) engine=innodb;
19
20 delimiter |;
21 create procedure p(i int)
22 begin
23 declare n int default 0;
24 declare continue handler for sqlexception begin end;
25 delete from t;
26 repeat
27 set @p=point(1,1);
28 insert into t values(@p,@p,@p,@p,@p,@p);
29 insert into t values(@p,@p,@p,@p,@p,@p);
30 insert into t select @p,@p,@p,@p,@p,@p
31 from t a,t b,t c,t d,t e,t f,t g,t h,t i,t j;
32 delete from t;
33 set n:=n+1;
34 until n >= i end repeat;
35 end|
36 delimiter ;|
37
38 call p(200);
39
40 --source include/wait_innodb_all_purged.inc
41
42 # Clean up.
43 drop procedure p;
44 drop table t;