Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table=1;
2 create table t1 (c1 int, c2 geometry not null SRID 0, spatial index (c2))engine=innodb ROW_FORMAT=COMPRESSED;
3 create procedure insert_t1(IN total int)
4 begin
5 declare i int default 1;
6 while (i <= total) DO
7 insert into t1 values (i, Point(i, i));
8 set i = i + 1;
9 end while;
10 end|
11 CALL insert_t1(70000);
12 select count(*) from t1;
13 count(*)
14 70000
15 check table t1;
16 Table Op Msg_type Msg_text
17 test.t1 check status OK
18 truncate table t1;
19 call mtr.add_suppression("page [0-9]+ in the doublewrite buffer is not within space bounds.*");
20 START TRANSACTION;
21 CALL insert_t1(5000);
22 COMMIT;
23 # Kill and restart
24 drop procedure insert_t1;
25 drop table t1;