EVOLUTION-MANAGER

Edit File: rtree_compress2.result

SET GLOBAL innodb_file_per_table=1; create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb ROW_FORMAT=COMPRESSED; create procedure insert_t1(IN total int) begin declare i int default 1; while (i <= total) DO insert into t1 values (i, Point(i, i)); set i = i + 1; end while; end| CALL insert_t1(70000); check table t1; Table Op Msg_type Msg_text test.t1 check status OK select count(*) from t1; count(*) 70000 delete from t1; drop procedure insert_t1; drop table t1;