diff options
| author | evgen@moonbone.local <> | 2005-06-23 01:02:43 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2005-06-23 01:02:43 +0400 |
| commit | 5c8e3341d3764e06be0196f109cbf015bab99f09 (patch) | |
| tree | 2eb5c9308d86de24da712c95e1f909985b459694 /mysql-test/r/insert_select.result | |
| parent | bafab2dd6f26c62bd528062fb7edb65c1871ff6d (diff) | |
| parent | 54d3b00184f73af12a8757e4e53954ad91099a48 (diff) | |
| download | mariadb-git-5c8e3341d3764e06be0196f109cbf015bab99f09.tar.gz | |
Bug #9728 fix merge
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 11384b0feff..026dae8381a 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -634,3 +634,18 @@ ff1 ff2 1 2 2 1 drop table t1, t2; +create table t1 (a int unique); +create table t2 (a int, b int); +insert into t1 values (1),(2); +insert into t2 values (1,2); +select * from t1; +a +1 +2 +insert into t1 select t2.a from t2 on duplicate key update a= a + t2.b; +select * from t1; +a +2 +3 +drop table t1; +drop table t2; |