Debian Codegraph @

mysql-test/suite/innodb/t/innodb-autoinc-56228.test

raw
1
2 ##
3 # Bug #56228: dropping tables from within an active statement crashes server
4 #
5 DROP TABLE IF EXISTS t1_56228;
6 DROP TABLE IF EXISTS t2_56228;
7 DROP FUNCTION IF EXISTS bug56228;
8
9 CREATE TEMPORARY TABLE t1_56228(
10 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
11 CREATE TEMPORARY TABLE t2_56228(
12 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
13
14 DELIMITER //;
15
16 CREATE FUNCTION bug56228() RETURNS INT DETERMINISTIC
17 BEGIN
18 INSERT INTO t1_56228 VALUES(NULL);
19 INSERT INTO t2_56228 VALUES(NULL);
20 INSERT INTO t1_56228 VALUES(NULL);
21 INSERT INTO t2_56228 VALUES(NULL);
22 DROP TEMPORARY TABLE t1_56228;
23 RETURN 42;
24 END //
25
26 DELIMITER ;//
27
28 SELECT bug56228();
29
30 DROP FUNCTION bug56228;
31 DROP TEMPORARY TABLE t2_56228;
32 DROP TEMPORARY TABLE IF EXISTS t1_56228;