diff options
| author | unknown <evgen@moonbone.local> | 2005-06-22 21:07:28 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-06-22 21:07:28 +0400 |
| commit | d12119689ff351fc7ae173d975b6776e7f2876aa (patch) | |
| tree | 80b1de27301fb45eb527dbbc8ffabe6d745eb676 /mysql-test/t/insert_select.test | |
| parent | bf851ae2a0d3fc1b45a81739046ab05d7285b666 (diff) | |
| parent | a23bf16577eedae26e5865e52f14db01270b1e1f (diff) | |
| download | mariadb-git-d12119689ff351fc7ae173d975b6776e7f2876aa.tar.gz | |
Fix for bug #10886 merge
mysql-test/r/insert_select.result:
Auto merged
mysql-test/t/insert_select.test:
Auto merged
Diffstat (limited to 'mysql-test/t/insert_select.test')
| -rw-r--r-- | mysql-test/t/insert_select.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/insert_select.test b/mysql-test/t/insert_select.test index 40dc4e20093..834561ed5f7 100644 --- a/mysql-test/t/insert_select.test +++ b/mysql-test/t/insert_select.test @@ -164,3 +164,12 @@ INSERT INTO t1 (SEQ, NO) SELECT "1" AS SEQ, IF(MAX(NO) IS NULL, 0, MAX(NO)) + 1 select SQL_BUFFER_RESULT * from t1 WHERE (SEQ = 1); drop table t1; +# +# Bug#10886 - Have to restore default values after update ON DUPLICATE KEY +# +create table t1 (f1 int); +create table t2 (ff1 int unique, ff2 int default 1); +insert into t1 values (1),(1),(2); +insert into t2(ff1) select f1 from t1 on duplicate key update ff2=ff2+1; +select * from t2; +drop table t1, t2; |