diff options
| author | gkodinov/kgeorge@macbook.gmz <> | 2006-09-04 18:45:48 +0300 |
|---|---|---|
| committer | gkodinov/kgeorge@macbook.gmz <> | 2006-09-04 18:45:48 +0300 |
| commit | 4c1db01833ead391cc19aad76493f3164aeb863a (patch) | |
| tree | 8a2db1f4c86eeb87afa5bee8f3be3722a9e263dc /mysql-test/t/delete.test | |
| parent | 55163a36f08558856000a72825356be228f58685 (diff) | |
| parent | 3758b975f8c535917c9507b005ccc8ff5a76bfb8 (diff) | |
| download | mariadb-git-4c1db01833ead391cc19aad76493f3164aeb863a.tar.gz | |
Merge macbook.gmz:/Users/kgeorge/mysql/work/B21392-4.1-opt
into macbook.gmz:/Users/kgeorge/mysql/work/B21392-5.0-opt
Diffstat (limited to 'mysql-test/t/delete.test')
| -rw-r--r-- | mysql-test/t/delete.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test index 677ffaa2860..865e1746fd3 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -153,6 +153,16 @@ DELETE FROM t1 WHERE t1.a > 0 ORDER BY t1.a LIMIT 1; SELECT * FROM t1; DROP TABLE t1; +# +# Bug #21392: multi-table delete with alias table name fails with +# 1003: Incorrect table name +# + +create table t1 (a int); +delete `4.t1` from t1 as `4.t1` where `4.t1`.a = 5; +delete FROM `4.t1` USING t1 as `4.t1` where `4.t1`.a = 5; +drop table t1; + # End of 4.1 tests # |