Edit File: innodb-autoinc-56228.result
DROP TABLE IF EXISTS t1_56228; Warnings: Note 1051 Unknown table 't1_56228' DROP TABLE IF EXISTS t2_56228; Warnings: Note 1051 Unknown table 't2_56228' DROP FUNCTION IF EXISTS bug56228; Warnings: Note 1305 FUNCTION test.bug56228 does not exist 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; 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 // SELECT bug56228(); bug56228() 42 DROP FUNCTION bug56228; DROP TEMPORARY TABLE t2_56228; DROP TEMPORARY TABLE IF EXISTS t1_56228; Warnings: Note 1051 Unknown table 't1_56228'
Back to File Manager