EVOLUTION-MANAGER

Edit File: sp-bugs2.result

CREATE TABLE t1 (i INT); SET @a = 2; CREATE TABLE IF NOT EXISTS t2 (i INT) ENGINE = MyISAM AS SELECT * FROM t1; CREATE TABLE IF NOT EXISTS t2 (i INT) ENGINE = MyISAM AS SELECT * FROM t1; Warnings: Note 1050 Table 't2' already exists DROP TABLE t2; CREATE PROCEDURE sp() BEGIN REPEAT CREATE TABLE IF NOT EXISTS t2 (i INT) ENGINE = MyISAM AS SELECT * FROM t1; SET @a = @a - 1; UNTIL @a = 0 END REPEAT ; END | CALL sp(); Warnings: Note 1050 Table 't2' already exists DROP PROCEDURE sp; DROP TABLE t1, t2;