diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-10-06 12:49:56 +0500 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-10-06 12:49:56 +0500 |
| commit | 95e1c07483005b784aaefa35b5a8597ffb1d3932 (patch) | |
| tree | 0535bd32f3125c03c099324bb261b9a5c9924a56 /mysql-test/t/delete.test | |
| parent | 4d93bb95625131b703db76c2ad0c33fe8beeb274 (diff) | |
| parent | dc3f3ce69430ed1608c0134da7a7e95f527c3d7c (diff) | |
| download | mariadb-git-95e1c07483005b784aaefa35b5a8597ffb1d3932.tar.gz | |
Merge rkalimullin@bk-internal.mysql.com:/home/bk/mysql-4.0
into gw.mysql.r18.ru:/usr/home/ram/work/4.0.b5733
sql/records.cc:
Auto merged
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 904d959d148..07cb9155b3f 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -61,3 +61,13 @@ select count(*) from t1; drop table t1; +# +# Bug #5733: Table handler error with self-join multi-table DELETE +# + +create table t1 (a int not null auto_increment primary key, b char(32)); +insert into t1 (b) values ('apple'), ('apple'); +select * from t1; +delete t1 from t1, t1 as t2 where t1.b = t2.b and t1.a > t2.a; +select * from t1; +drop table t1; |