Debian Codegraph @

mysql-test/suite/innodb_gis/t/check_rtree.test

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