diff options
| author | unknown <acurtis@pcgem.rdg.cyberkinetica.com> | 2005-02-03 21:11:12 +0000 |
|---|---|---|
| committer | unknown <acurtis@pcgem.rdg.cyberkinetica.com> | 2005-02-03 21:11:12 +0000 |
| commit | 3c925ee0f1b3387e6df952de8f86c618f11c1a8d (patch) | |
| tree | 056958852eb020358f636101553d7947b16e9231 /mysql-test/t/update.test | |
| parent | bcb31692fc510d8a54fceebee53d750ba5d8f8a6 (diff) | |
| download | mariadb-git-3c925ee0f1b3387e6df952de8f86c618f11c1a8d.tar.gz | |
Bug#8057
Fix crash with LAST_INSERT_ID() in UPDATE,
Tests included,
mysql-test/r/update.result:
Bug#8057
Test for bug
mysql-test/t/update.test:
Bug#8057
Test for bug
sql/item_func.cc:
Bug#8057
Don't create new Item in val_int()
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 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; |