Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug19164038.test

raw
1 # BUG#19164038 - INNODB: CLUSTER INDEX BUILD BY BULK LOAD WHEN SKIP SORT SHOULD RELEASE LATCHES
2
3 --source include/have_debug.inc
4
5 # Create table with geometry column
6 CREATE TABLE t1 (
7 c1 INT AUTO_INCREMENT,
8 c2 GEOMETRY NOT NULL SRID 0,
9 PRIMARY KEY(c1),
10 SPATIAL INDEX(c2)
11 ) ENGINE=INNODB;
12
13 # Insert enough values
14 INSERT INTO t1(c2) VALUES(Point(1,1));
15 INSERT INTO t1(c2) VALUES(Point(2,2));
16 INSERT INTO t1(c2) VALUES(Point(3,3));
17 INSERT INTO t1(c2) VALUES(Point(4,4));
18 INSERT INTO t1(c2) VALUES(Point(5,5));
19 INSERT INTO t1(c2) VALUES(Point(6,6));
20 INSERT INTO t1(c2) VALUES(Point(7,7));
21 INSERT INTO t1(c2) VALUES(Point(8,8));
22 INSERT INTO t1(c2) VALUES(Point(9,9));
23
24 INSERT INTO t1(c2) SELECT c2 FROM t1;
25 INSERT INTO t1(c2) SELECT c2 FROM t1;
26 INSERT INTO t1(c2) SELECT c2 FROM t1;
27 INSERT INTO t1(c2) SELECT c2 FROM t1;
28 INSERT INTO t1(c2) SELECT c2 FROM t1;
29 INSERT INTO t1(c2) SELECT c2 FROM t1;
30 INSERT INTO t1(c2) SELECT c2 FROM t1;
31 INSERT INTO t1(c2) SELECT c2 FROM t1;
32 INSERT INTO t1(c2) SELECT c2 FROM t1;
33
34 SELECT COUNT(*) FROM t1;
35
36 # Use small sort buffer pool so that we won't have all rows in the buffer.
37 SELECT @@innodb_sort_buffer_size;
38
39 SET SESSION debug="+d,ddl_instrument_log_check_flush";
40 ALTER TABLE t1 ADD COLUMN c3 INT;
41 SET SESSION debug="-d,ddl_instrument_log_check_flush";
42
43 # Clean up.
44 DROP TABLE t1;