Debian Codegraph @

mysql-test/suite/innodb_gis/r/rtree_purge.result

raw
1 create table t (
2 a point not null,b point not null SRID 0,c point,
3 d point not null SRID 0,e point,f point,
4 spatial key (d),spatial key (b)
5 ) engine=innodb;
6 create procedure p(i int)
7 begin
8 declare n int default 0;
9 declare continue handler for sqlexception begin end;
10 delete from t;
11 repeat
12 set @p=point(1,1);
13 insert into t values(@p,@p,@p,@p,@p,@p);
14 insert into t values(@p,@p,@p,@p,@p,@p);
15 insert into t select @p,@p,@p,@p,@p,@p
16 from t a,t b,t c,t d,t e,t f,t g,t h,t i,t j;
17 delete from t;
18 set n:=n+1;
19 until n >= i end repeat;
20 end|
21 call p(200);
22 drop procedure p;
23 drop table t;