diff options
| author | unknown <lenz@mysql.com> | 2004-10-07 14:43:09 +0200 |
|---|---|---|
| committer | unknown <lenz@mysql.com> | 2004-10-07 14:43:09 +0200 |
| commit | 81edee8100fb13835c648835b1e6ca0b51710522 (patch) | |
| tree | b0a2946923849f8d0eb0cf0a30cd8a6fdebdacbd /mysql-test/t/delete.test | |
| parent | 02ce88ca8ba354a215e8d8313be5d1be69f029af (diff) | |
| parent | 57fedc40708ed3266d79347cd71e829297352409 (diff) | |
| download | mariadb-git-81edee8100fb13835c648835b1e6ca0b51710522.tar.gz | |
Merge mysql.com:/space/my/mysql-4.1
into mysql.com:/space/my/mysql-4.1-build
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 56c8ce77627..5f60445d765 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -71,6 +71,16 @@ delete from t1 where 3 > 2; 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; # # IGNORE option |