summaryrefslogtreecommitdiff
path: root/mysql-test/r/delete.result
diff options
context:
space:
mode:
authorGleb Shchepa <gshchepa@mysql.com>2010-08-31 02:22:01 +0400
committerGleb Shchepa <gshchepa@mysql.com>2010-08-31 02:22:01 +0400
commitda9c598a88b52e699eed36caeb39bed9f9b18197 (patch)
treef4c427e89720b5c1d1a90c7c0d4973f8ee6e8f7b /mysql-test/r/delete.result
parentbe4ce1b811ac44366a3b0e55476eda41b2a5a4fb (diff)
parentccab4d8771b728e334b26d0be1150b4ecf0bc7a6 (diff)
downloadmariadb-git-da9c598a88b52e699eed36caeb39bed9f9b18197.tar.gz
automerge 5.1-bugteam --> 5.5-merge (bug 53034)
Diffstat (limited to 'mysql-test/r/delete.result')
-rw-r--r--mysql-test/r/delete.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/delete.result b/mysql-test/r/delete.result
index 0c9b0d7d2e5..702b9348b7d 100644
--- a/mysql-test/r/delete.result
+++ b/mysql-test/r/delete.result
@@ -499,4 +499,13 @@ INDEX(a), INDEX(b), INDEX(c));
INSERT INTO t1 VALUES (1,2,3), (4,5,6), (7,8,9);
DELETE FROM t1 WHERE a = 10 OR b = 20 ORDER BY c LIMIT 1;
DROP TABLE t1;
+#
+# Bug #53034: Multiple-table DELETE statements not accepting
+# "Access compatibility" syntax
+#
+CREATE TABLE t1 (id INT);
+CREATE TABLE t2 LIKE t1;
+CREATE TABLE t3 LIKE t1;
+DELETE FROM t1.*, test.t2.*, a.* USING t1, t2, t3 AS a;
+DROP TABLE t1, t2, t3;
End of 5.1 tests