Debian Codegraph @

mysql-test/suite/innodb/r/innodb-autoinc-56228.result

raw
1 CREATE TABLE t1_56228(
2 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
3 CREATE TABLE t2_56228(
4 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
5 CREATE FUNCTION bug56228() RETURNS INT DETERMINISTIC
6 BEGIN
7 INSERT INTO t1_56228 VALUES(NULL);
8 INSERT INTO t2_56228 VALUES(NULL);
9 INSERT INTO t1_56228 VALUES(NULL);
10 INSERT INTO t2_56228 VALUES(NULL);
11 DROP TABLE t1_56228;
12 RETURN 42;
13 END //
14 ERROR HY000: Explicit or implicit commit is not allowed in stored function or trigger
15 CREATE PROCEDURE bug56228()
16 BEGIN
17 INSERT INTO t1_56228 VALUES(NULL);
18 INSERT INTO t2_56228 VALUES(NULL);
19 INSERT INTO t1_56228 VALUES(NULL);
20 INSERT INTO t2_56228 VALUES(NULL);
21 DROP TABLE t1_56228;
22 END //
23 CALL bug56228();
24 DROP PROCEDURE bug56228;
25 DROP TABLE t2_56228;