diff options
| author | Andrei Elkin <aelkin@mysql.com> | 2008-09-03 14:43:26 +0300 |
|---|---|---|
| committer | Andrei Elkin <aelkin@mysql.com> | 2008-09-03 14:43:26 +0300 |
| commit | d62f27a90a7bcc54819bf70667be7b2d96fd5adc (patch) | |
| tree | 9c0972b042342bd138f0dedc5a3353ba2c0ac47e /mysql-test/t | |
| parent | 2f8c0a16754147d451a0472866cc78e116f318cf (diff) | |
| parent | 5cee5b9b965f68aed1b81d87f773f74302eb21d7 (diff) | |
| download | mariadb-git-d62f27a90a7bcc54819bf70667be7b2d96fd5adc.tar.gz | |
merging with 5.1.29.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/default.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/default.test b/mysql-test/t/default.test index 14aa4b02cfe..b719cb83448 100644 --- a/mysql-test/t/default.test +++ b/mysql-test/t/default.test @@ -145,5 +145,24 @@ insert into t1 values(default); drop view v1; drop table t1; +# +# Bug #39002: crash with +# INSERT ... SELECT ... ON DUPLICATE KEY UPDATE col=DEFAULT +# + +create table t1 (a int unique); +create table t2 (b int default 10); +insert into t1 (a) values (1); +insert into t2 (b) values (1); + +insert into t1 (a) select b from t2 on duplicate key update a=default; +select * from t1; + +insert into t1 (a) values (1); +insert into t1 (a) select b from t2 on duplicate key update a=default(b); +select * from t1; + +drop table t1, t2; + --echo End of 5.0 tests. |