summaryrefslogtreecommitdiff
path: root/mysql-test/main/create_or_replace.result
diff options
context:
space:
mode:
authorAleksey Midenkov <midenok@gmail.com>2022-10-05 17:46:51 +0300
committerAleksey Midenkov <midenok@gmail.com>2022-10-05 19:53:13 +0300
commit074e358213ac8f358fa01c2c03ed58e94c81baf8 (patch)
tree95c71997e93b5d0cfe0c7cb16cae79cf6838ce98 /mysql-test/main/create_or_replace.result
parent0779e2cb1013556c4d67bcc326706dfd449db392 (diff)
downloadmariadb-git-074e358213ac8f358fa01c2c03ed58e94c81baf8.tar.gz
MDEV-29697 Assertion failure in Diagnostics_area::set_ok_status
upon CREATE OR REPLACE causing ER_UPDATE_TABLE_USED Missed set return status to 1.
Diffstat (limited to 'mysql-test/main/create_or_replace.result')
-rw-r--r--mysql-test/main/create_or_replace.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/create_or_replace.result b/mysql-test/main/create_or_replace.result
index c9863f56154..09ae481e3d9 100644
--- a/mysql-test/main/create_or_replace.result
+++ b/mysql-test/main/create_or_replace.result
@@ -532,3 +532,12 @@ SELECT * FROM t3;
ERROR HY000: Table 't3' was not locked with LOCK TABLES
UNLOCK TABLES;
DROP TABLE t3;
+#
+# MDEV-29697 Assertion failure in Diagnostics_area::set_ok_status
+# upon CREATE OR REPLACE causing ER_UPDATE_TABLE_USED
+#
+CREATE TABLE t (a INT) ENGINE=MyISAM;
+CREATE TABLE tm (a INT) ENGINE=MERGE UNION(t);
+CREATE OR REPLACE TABLE t LIKE tm;
+ERROR HY000: Table 'tm' is specified twice, both as a target for 'CREATE' and as a separate source for data
+DROP TABLE IF EXISTS tm, t;