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