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