Debian Codegraph @

mysql-test/suite/innodb_gis/r/update_root.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 (i, Point(i, i));
7 set i = i + 1;
8 end while;
9 end|
10 BEGIN;
11 CALL insert_t1(70000);
12 COMMIT;
13 BEGIN;
14 CALL insert_t1(90);
15 CALL insert_t1(90);
16 CALL insert_t1(83);
17 COMMIT;
18 insert into t1 values (0, Point(0.9, 0.9));
19 check table t1;
20 Table Op Msg_type Msg_text
21 test.t1 check status OK
22 drop procedure insert_t1;
23 drop table t1;