1# This test case will test checking R-tree features. 2 3# Not supported in embedded 4--source include/not_embedded.inc 5--source include/have_debug.inc 6--source include/have_innodb.inc 7 8# Create table with R-tree index. 9create table t1 (i int, g geometry not null, spatial index (g))engine=innodb; 10 11# Turn on the geometry data print. 12SET SESSION debug="+d,rtree_test_check_count"; 13 14# Insert values. 15insert into t1 values (1, POINT(1,1)); 16insert into t1 values (1, POINT(1.5,1.5)); 17insert into t1 values (1, POINT(3,3)); 18insert into t1 values (1, POINT(3.1,3.1)); 19insert into t1 values (1, POINT(5,5)); 20 21CALL mtr.add_suppression("InnoDB: Flagged corruption of `g` in table `test`.`t1` in CHECK TABLE; Wrong count"); 22 23# Select by R-tree index. 24check table t1; 25 26# Cleanup. 27drop table t1; 28