Edit File: innodb-autoinc-56228.test
-- source include/have_innodb.inc ## # Bug #56228: dropping tables from within an active statement crashes server # DROP TABLE IF EXISTS t1_56228; DROP TABLE IF EXISTS t2_56228; DROP FUNCTION IF EXISTS bug56228; CREATE TEMPORARY TABLE t1_56228( c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB; CREATE TEMPORARY TABLE t2_56228( c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB; DELIMITER //; CREATE FUNCTION bug56228() RETURNS INT DETERMINISTIC BEGIN INSERT INTO t1_56228 VALUES(NULL); INSERT INTO t2_56228 VALUES(NULL); INSERT INTO t1_56228 VALUES(NULL); INSERT INTO t2_56228 VALUES(NULL); DROP TEMPORARY TABLE t1_56228; RETURN 42; END // DELIMITER ;// SELECT bug56228(); DROP FUNCTION bug56228; DROP TEMPORARY TABLE t2_56228; DROP TEMPORARY TABLE IF EXISTS t1_56228;
Back to File Manager