Debian Codegraph @

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

raw
1 create table t1 (c1 int, c2 geometry not null SRID 0, 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 (i, Point(i, i));
7 set i = i + 1;
8 end while;
9 end|
10 CALL insert_t1(70000);
11 CALL insert_t1(90);
12 CALL insert_t1(90);
13 CALL insert_t1(83);
14 insert into t1 values (0, Point(0.9, 0.9));
15 check table t1;
16 Table Op Msg_type Msg_text
17 test.t1 check status OK
18 drop procedure insert_t1;
19 drop table t1;