diff options
| author | Gleb Shchepa <gshchepa@mysql.com> | 2010-08-31 02:22:01 +0400 |
|---|---|---|
| committer | Gleb Shchepa <gshchepa@mysql.com> | 2010-08-31 02:22:01 +0400 |
| commit | da9c598a88b52e699eed36caeb39bed9f9b18197 (patch) | |
| tree | f4c427e89720b5c1d1a90c7c0d4973f8ee6e8f7b /mysql-test/t/delete.test | |
| parent | be4ce1b811ac44366a3b0e55476eda41b2a5a4fb (diff) | |
| parent | ccab4d8771b728e334b26d0be1150b4ecf0bc7a6 (diff) | |
| download | mariadb-git-da9c598a88b52e699eed36caeb39bed9f9b18197.tar.gz | |
automerge 5.1-bugteam --> 5.5-merge (bug 53034)
Diffstat (limited to 'mysql-test/t/delete.test')
| -rw-r--r-- | mysql-test/t/delete.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test index a21fff60d33..15aade73ab7 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -540,4 +540,17 @@ DELETE FROM t1 WHERE a = 10 OR b = 20 ORDER BY c LIMIT 1; DROP TABLE t1; +--echo # +--echo # Bug #53034: Multiple-table DELETE statements not accepting +--echo # "Access compatibility" syntax +--echo # + +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; + --echo End of 5.1 tests |