diff options
| author | timour@mysql.com <> | 2004-12-16 18:04:51 +0200 |
|---|---|---|
| committer | timour@mysql.com <> | 2004-12-16 18:04:51 +0200 |
| commit | 53a9af8f1da46f30b31c52ad14369ccee1718ede (patch) | |
| tree | 6d5fd7b57818f496e6ca5a1ec719ec255ad60113 | |
| parent | cd8743409f3f6a03430f5db16e65a2e98a3a9d4b (diff) | |
| download | mariadb-git-53a9af8f1da46f30b31c52ad14369ccee1718ede.tar.gz | |
Test for BUG#6054. The bug itsel is fixed by the fix for #5837.
| -rw-r--r-- | mysql-test/r/update.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/update.test | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index c9405d71237..08b7f942ccc 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -203,3 +203,9 @@ colC colA colD colE colF 3 4433 10005 492 500 DROP TABLE t1; DROP TABLE t2; +drop table if exists t1, t2; +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; diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 1850564418c..fdf6a57cc11 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -155,3 +155,12 @@ SELECT * FROM t2; DROP TABLE t1; DROP TABLE t2; +# +# Bug #6054 +# +drop table if exists t1, t2; +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; |