Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1_56228;
2 Warnings:
3 Note 1051 Unknown table 'test.t1_56228'
4 DROP TABLE IF EXISTS t2_56228;
5 Warnings:
6 Note 1051 Unknown table 'test.t2_56228'
7 DROP FUNCTION IF EXISTS bug56228;
8 Warnings:
9 Note 1305 FUNCTION test.bug56228 does not exist
10 CREATE TEMPORARY TABLE t1_56228(
11 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
12 CREATE TEMPORARY TABLE t2_56228(
13 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
14 CREATE FUNCTION bug56228() RETURNS INT DETERMINISTIC
15 BEGIN
16 INSERT INTO t1_56228 VALUES(NULL);
17 INSERT INTO t2_56228 VALUES(NULL);
18 INSERT INTO t1_56228 VALUES(NULL);
19 INSERT INTO t2_56228 VALUES(NULL);
20 DROP TEMPORARY TABLE t1_56228;
21 RETURN 42;
22 END //
23 SELECT bug56228();
24 bug56228()
25 42
26 DROP FUNCTION bug56228;
27 DROP TEMPORARY TABLE t2_56228;
28 DROP TEMPORARY TABLE IF EXISTS t1_56228;
29 Warnings:
30 Note 1051 Unknown table 'test.t1_56228'