diff options
| author | acurtis@pcgem.rdg.cyberkinetica.com <> | 2005-02-03 21:11:12 +0000 |
|---|---|---|
| committer | acurtis@pcgem.rdg.cyberkinetica.com <> | 2005-02-03 21:11:12 +0000 |
| commit | b8ceaa4a1f8c664558a5212287e7c85950cb4cb8 (patch) | |
| tree | 056958852eb020358f636101553d7947b16e9231 /mysql-test/r/update.result | |
| parent | 24716111c1b6cfaa6ac48a9f80c17ce06b742eaa (diff) | |
| download | mariadb-git-b8ceaa4a1f8c664558a5212287e7c85950cb4cb8.tar.gz | |
Bug#8057
Fix crash with LAST_INSERT_ID() in UPDATE,
Tests included,
Diffstat (limited to 'mysql-test/r/update.result')
| -rw-r--r-- | mysql-test/r/update.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index beab6105f79..ac370db9ecc 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -212,3 +212,10 @@ 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; +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; +id id_str +1 test1 +drop table t1; |