diff options
| author | unknown <timour@mysql.com> | 2004-12-16 18:46:38 +0200 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2004-12-16 18:46:38 +0200 |
| commit | ae6f147a4f65b0392e61c6d447523fa9b6db186f (patch) | |
| tree | 5fdb46113d600925dcd372deb235ef2eb63523b4 /mysql-test/t/update.test | |
| parent | bfa45f2fa2aa9dfd7bb8cdea974ade3af7867b08 (diff) | |
| download | mariadb-git-ae6f147a4f65b0392e61c6d447523fa9b6db186f.tar.gz | |
Test for BUG#6054. The bug itsel is fixed by the fix for #5837.
mysql-test/r/update.result:
test result
mysql-test/t/update.test:
test queries
Diffstat (limited to 'mysql-test/t/update.test')
| -rw-r--r-- | mysql-test/t/update.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index aeefa3c33f5..704263b1216 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -161,3 +161,12 @@ SELECT * FROM t2; DROP TABLE t1; DROP TABLE t2; +# +# Bug #6054 +# +create table t1 (c1 int, c2 char(6), c3 int); +create table t2 (c1 int, c2 char(6)); +insert into t1 values (1, "t1c2-1", 10), (2, "t1c2-2", 20); +update t1 left join t2 on t1.c1 = t2.c1 set t2.c2 = "t2c2-1"; +update t1 left join t2 on t1.c1 = t2.c1 set t2.c2 = "t2c2-1" where t1.c3 = 10; +drop table t1, t2; |