Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug19164038.result

raw
1 CREATE TABLE t1 (
2 c1 INT AUTO_INCREMENT,
3 c2 GEOMETRY NOT NULL SRID 0,
4 PRIMARY KEY(c1),
5 SPATIAL INDEX(c2)
6 ) ENGINE=INNODB;
7 INSERT INTO t1(c2) VALUES(Point(1,1));
8 INSERT INTO t1(c2) VALUES(Point(2,2));
9 INSERT INTO t1(c2) VALUES(Point(3,3));
10 INSERT INTO t1(c2) VALUES(Point(4,4));
11 INSERT INTO t1(c2) VALUES(Point(5,5));
12 INSERT INTO t1(c2) VALUES(Point(6,6));
13 INSERT INTO t1(c2) VALUES(Point(7,7));
14 INSERT INTO t1(c2) VALUES(Point(8,8));
15 INSERT INTO t1(c2) VALUES(Point(9,9));
16 INSERT INTO t1(c2) SELECT c2 FROM t1;
17 INSERT INTO t1(c2) SELECT c2 FROM t1;
18 INSERT INTO t1(c2) SELECT c2 FROM t1;
19 INSERT INTO t1(c2) SELECT c2 FROM t1;
20 INSERT INTO t1(c2) SELECT c2 FROM t1;
21 INSERT INTO t1(c2) SELECT c2 FROM t1;
22 INSERT INTO t1(c2) SELECT c2 FROM t1;
23 INSERT INTO t1(c2) SELECT c2 FROM t1;
24 INSERT INTO t1(c2) SELECT c2 FROM t1;
25 SELECT COUNT(*) FROM t1;
26 COUNT(*)
27 4608
28 SELECT @@innodb_sort_buffer_size;
29 @@innodb_sort_buffer_size
30 65536
31 SET SESSION debug="+d,ddl_instrument_log_check_flush";
32 ALTER TABLE t1 ADD COLUMN c3 INT;
33 SET SESSION debug="-d,ddl_instrument_log_check_flush";
34 DROP TABLE t1;