Debian Codegraph @

mysql-test/suite/innodb_gis/r/rtree_debug.result

raw
1 create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb;
2 create procedure insert_t1(IN total int)
3 begin
4 declare i int default 1;
5 while (i <= total) DO
6 insert into t1 values
7 (i, Point(i, i)),
8 (i + 1, Point(i + 1, i + 1)),
9 (i + 2, Point(i + 2, i + 2)),
10 (i + 3, Point(i + 3, i + 3)),
11 (i + 4, Point(i + 4, i + 4)),
12 (i + 5, Point(i + 5, i + 5)),
13 (i + 6, Point(i + 6, i + 6)),
14 (i + 7, Point(i + 7, i + 7)),
15 (i + 8, Point(i + 8, i + 8)),
16 (i + 9, Point(i + 9, i + 9));
17 set i = i + 10;
18 end while;
19 end|
20 CALL insert_t1(5000);
21 select count(*) from t1;
22 count(*)
23 5000
24 check table t1;
25 Table Op Msg_type Msg_text
26 test.t1 check status OK
27 truncate table t1;
28 CALL insert_t1(10000);
29 select count(*) from t1;
30 count(*)
31 10000
32 drop index c2 on t1;
33 create spatial index idx on t1(c2);
34 show create table t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `c1` int(11) DEFAULT NULL,
38 `c2` geometry NOT NULL,
39 SPATIAL KEY `idx` (`c2`)
40 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
41 SET @save_dbug = @@SESSION.debug_dbug;
42 SET debug_dbug='+d,row_merge_ins_spatial_fail';
43 create spatial index idx2 on t1(c2);
44 ERROR HY000: Got error 1000 "Unknown error 1000" from storage engine InnoDB
45 SET @@SESSION.debug_dbug = @save_dbug;
46 show create table t1;
47 Table Create Table
48 t1 CREATE TABLE `t1` (
49 `c1` int(11) DEFAULT NULL,
50 `c2` geometry NOT NULL,
51 SPATIAL KEY `idx` (`c2`)
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
53 check table t1;
54 Table Op Msg_type Msg_text
55 test.t1 check status OK
56 truncate table t1;
57 CALL insert_t1(100000);
58 select count(*) from t1;
59 count(*)
60 100000
61 check table t1;
62 Table Op Msg_type Msg_text
63 test.t1 check status OK
64 truncate table t1;
65 drop procedure insert_t1;
66 drop table t1;