1# WL#6745 InnoDB R-tree support 2# This test case will test R-tree split. 3 4--source include/have_innodb.inc 5--source include/big_test.inc 6--source include/not_valgrind.inc 7 8# Create table with R-tree index. 9create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb; 10 11# Insert enough values to let R-tree split. 12delimiter |; 13create procedure insert_t1(IN total int) 14begin 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; 20end| 21delimiter ;| 22 23start transaction; 24CALL insert_t1(70000); 25rollback; 26check table t1; 27 28# Clean up. 29drop procedure insert_t1; 30drop table t1; 31 32