summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_gis/r/rtree_purge.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb_gis/r/rtree_purge.result')
-rw-r--r--mysql-test/suite/innodb_gis/r/rtree_purge.result24
1 files changed, 4 insertions, 20 deletions
diff --git a/mysql-test/suite/innodb_gis/r/rtree_purge.result b/mysql-test/suite/innodb_gis/r/rtree_purge.result
index c3e879674dd..38c4f484504 100644
--- a/mysql-test/suite/innodb_gis/r/rtree_purge.result
+++ b/mysql-test/suite/innodb_gis/r/rtree_purge.result
@@ -1,24 +1,8 @@
+SET @saved_frequency = @@GLOBAL.innodb_purge_rseg_truncate_frequency;
+SET GLOBAL innodb_purge_rseg_truncate_frequency = 1;
create table t (
-a point not null,b point not null,c point,
-d point not null,e point,f point,
-spatial key (d),spatial key (b)
+b point not null,d point not null, spatial key (d),spatial key (b)
) engine=innodb;
-create procedure p(i int)
-begin
-declare n int default 0;
-declare continue handler for sqlexception begin end;
-delete from t;
-repeat
-set @p=point(1,1);
-insert into t values(@p,@p,@p,@p,@p,@p);
-insert into t values(@p,@p,@p,@p,@p,@p);
-insert into t select @p,@p,@p,@p,@p,@p
-from t a,t b,t c,t d,t e,t f,t g,t h,t i,t j;
-delete from t;
-set n:=n+1;
-until n >= i end repeat;
-end|
-call p(200);
InnoDB 0 transactions not purged
-drop procedure p;
drop table t;
+SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;