diff options
Diffstat (limited to 'mysql-test/suite/innodb_gis/r/rtree_purge.result')
-rw-r--r-- | mysql-test/suite/innodb_gis/r/rtree_purge.result | 24 |
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; |