diff options
| author | unknown <acurtis@xiphis.org> | 2005-08-07 03:16:15 +0100 |
|---|---|---|
| committer | unknown <acurtis@xiphis.org> | 2005-08-07 03:16:15 +0100 |
| commit | fdb4d307ab8c7639ced6e08c61528bfe81823fae (patch) | |
| tree | 58a1759c94967db7d8ef575fe9f3af0cec92c74a /mysql-test/t/insert_update.test | |
| parent | 75c06af27784e6fa6ba23f4cd6803bc7574f8253 (diff) | |
| download | mariadb-git-fdb4d307ab8c7639ced6e08c61528bfe81823fae.tar.gz | |
Bug#10109
"INSERT .. SELECT ... ON DUPLICATE KEY UPDATE fails"
Ensure that check_insert_fields() is only called once when
doing an INSERT..SELECT
mysql-test/r/insert_update.result:
Test for bug 10109
mysql-test/t/insert_update.test:
Test for bug 10109
sql/sql_class.h:
select_insert needs more state
sql/sql_insert.cc:
ensure that check_insert_fields() is only called once when
doing an INSERT...SELECT
sql/sql_parse.cc:
more args for select_insert constructor
Diffstat (limited to 'mysql-test/t/insert_update.test')
| -rw-r--r-- | mysql-test/t/insert_update.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/insert_update.test b/mysql-test/t/insert_update.test index d0e75f0fa2a..8038bd7bfe7 100644 --- a/mysql-test/t/insert_update.test +++ b/mysql-test/t/insert_update.test @@ -101,4 +101,18 @@ insert into t1 select a from t1 on duplicate key update a=a+1 ; insert ignore into t1 select a from t1 on duplicate key update a=t1.a+1 ; drop table t1; +# +# Bug#10109 - INSERT .. SELECT ... ON DUPLICATE KEY UPDATE fails +# Bogus "Duplicate columns" error message +# + +CREATE TABLE t1 ( + a BIGINT(20) NOT NULL DEFAULT 0, + PRIMARY KEY (a) +) ENGINE=MyISAM; + +INSERT INTO t1 ( a ) SELECT 0 ON DUPLICATE KEY UPDATE a = a + VALUES (a) ; + +DROP TABLE t1; + # End of 4.1 tests |