1DROP TABLE IF EXISTS t1; 2DROP PROCEDURE IF EXISTS proc_insert_many; 3CREATE TABLE t1 ( 4field1 INTEGER NOT NULL, 5field2 INTEGER NOT NULL, 6field3 INTEGER NOT NULL, 7KEY i_1 (field1), 8KEY i_2 (field2), 9KEY i_3 (field3), 10KEY i_12 (field1, field2), 11KEY i_13 (field1, field3), 12KEY i_21 (field2, field1), 13KEY i_23 (field2, field3), 14KEY i_31 (field3, field1), 15KEY i_32 (field3, field2), 16KEY i_123 (field1, field2, field3), 17KEY i_132 (field1, field3, field2), 18KEY i_213 (field2, field1, field3), 19KEY i_231 (field2, field3, field1), 20KEY i_312 (field3, field1, field2), 21KEY i_321 (field3, field2, field1) 22) ENGINE=Aria; 23CREATE PROCEDURE proc_insert_many() 24BEGIN 25DECLARE iRow INT DEFAULT 0; 26insertRows: LOOP 27IF (iRow = 70000) THEN 28LEAVE insertRows; 29END IF; 30INSERT INTO t1 VALUES (1000000+iRow,2000000+iRow,3000000+iRow); 31SET iRow = iRow + 1; 32END LOOP insertRows; 33END| 34LOCK TABLES t1 WRITE; 35CALL proc_insert_many(); 36UNLOCK TABLES; 37SET debug_dbug="d,crash_shutdown"; 38shutdown; 39ERROR HY000: Lost connection to MySQL server during query 40SELECT * FROM t1 ORDER BY 1 DESC LIMIT 10; 41field1 field2 field3 421069999 2069999 3069999 431069998 2069998 3069998 441069997 2069997 3069997 451069996 2069996 3069996 461069995 2069995 3069995 471069994 2069994 3069994 481069993 2069993 3069993 491069992 2069992 3069992 501069991 2069991 3069991 511069990 2069990 3069990 52DROP TABLE IF EXISTS t1; 53DROP PROCEDURE IF EXISTS proc_insert_many; 54