diff options
| author | unknown <evgen@moonbone.local> | 2005-06-21 22:25:49 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-06-21 22:25:49 +0400 |
| commit | a23bf16577eedae26e5865e52f14db01270b1e1f (patch) | |
| tree | aacd78c4bd4363878886e478bc4debd96d7c810f /mysql-test/t/insert_select.test | |
| parent | 9f4db562840be11175b3e93ea70ba8a6dfcc2317 (diff) | |
| parent | 8e45c0572bf6503b1fd126428aac203c90c949b7 (diff) | |
| download | mariadb-git-a23bf16577eedae26e5865e52f14db01270b1e1f.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1
into moonbone.local:/work/mysql-4.1-bug-10886
sql/sql_insert.cc:
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 ecc83e3883b..613c97dc4f1 100644 --- a/mysql-test/t/insert_select.test +++ b/mysql-test/t/insert_select.test @@ -166,3 +166,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; |