Debian Codegraph @

mysql-test/suite/innodb_gis/r/rtree_rollback2.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 start transaction;
11 CALL insert_t1(70000);
12 rollback;
13 check table t1;
14 Table Op Msg_type Msg_text
15 test.t1 check status OK
16 drop procedure insert_t1;
17 drop table t1;