diff options
| author | unknown <joreland@mysql.com> | 2005-02-04 06:09:43 +0100 |
|---|---|---|
| committer | unknown <joreland@mysql.com> | 2005-02-04 06:09:43 +0100 |
| commit | ef5c8dbf7b5e0e4eb6535e6c2c2d40b4a374982d (patch) | |
| tree | 8f4b07615781cf1548225cc7f14604e11cad6e1d /mysql-test/t | |
| parent | a6cb0e5ff1c5160f60ebc5303f5c0d898d28dcda (diff) | |
| parent | 876b4a59b1e72c29061a8ff973d2baa39f2cc6d0 (diff) | |
| download | mariadb-git-ef5c8dbf7b5e0e4eb6535e6c2c2d40b4a374982d.tar.gz | |
Merge joreland@bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/jonas/src/mysql-4.1
configure.in:
Auto merged
ndb/test/src/NDBT_Test.cpp:
Auto merged
Diffstat (limited to 'mysql-test/t')
| -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 704263b1216..04192f25ac8 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -170,3 +170,12 @@ 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 #8057 +# +create table t1 (id int not null auto_increment primary key, id_str varchar(32)); +insert into t1 (id_str) values ("test"); +update t1 set id_str = concat(id_str, id) where id = last_insert_id(); +select * from t1; +drop table t1; |