From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/sp-bugs2.result | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 mysql-test/main/sp-bugs2.result (limited to 'mysql-test/main/sp-bugs2.result') diff --git a/mysql-test/main/sp-bugs2.result b/mysql-test/main/sp-bugs2.result new file mode 100644 index 00000000..3e48f0fb --- /dev/null +++ b/mysql-test/main/sp-bugs2.result @@ -0,0 +1,23 @@ +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; -- cgit v1.2.3