diff options
| author | ramil@mysql.com <> | 2005-03-17 10:24:50 +0400 |
|---|---|---|
| committer | ramil@mysql.com <> | 2005-03-17 10:24:50 +0400 |
| commit | a773916238d9bece75458b9548e08fac303cdc8a (patch) | |
| tree | 5c075b6f58481b058b5a1b404a70cfd16466776e /mysql-test/t/update.test | |
| parent | c5478c4f25ba8989246fec65a6c0971e681ab79e (diff) | |
| download | mariadb-git-a773916238d9bece75458b9548e08fac303cdc8a.tar.gz | |
A fix (bug #8942: SUBSTRING_INDEX in UPDATE causes internal loop).
Diffstat (limited to 'mysql-test/t/update.test')
| -rw-r--r-- | mysql-test/t/update.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 62439dcc51b..6c7b450f763 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -164,3 +164,13 @@ 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; + +# +# Bug #8942: a problem with update and partial key part +# + +create table t1 (a int, b char(255), key(a, b(20))); +insert into t1 values (0, '1'); +update t1 set b = b + 1 where a = 0; +select * from t1; +drop table t1; |