Debian Codegraph @

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

raw
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.
9 create table t1 (i int, g geometry not null, spatial index (g))engine=innodb;
10
11 # Turn on the geometry data print.
12 SET SESSION debug_dbug="+d,rtree_test_check_count";
13
14 # Insert values.
15 insert into t1 values (1, POINT(1,1));
16 insert into t1 values (1, POINT(1.5,1.5));
17 insert into t1 values (1, POINT(3,3));
18 insert into t1 values (1, POINT(3.1,3.1));
19 insert into t1 values (1, POINT(5,5));
20
21 CALL mtr.add_suppression("InnoDB: Flagged corruption of `g` in table `test`.`t1` in CHECK TABLE; Wrong count");
22
23 # Select by R-tree index.
24 check table t1;
25
26 # Cleanup.
27 drop table t1;