diff options
| author | Jon Olav Hauglid <jon.hauglid@oracle.com> | 2010-08-09 14:11:29 +0200 |
|---|---|---|
| committer | Jon Olav Hauglid <jon.hauglid@oracle.com> | 2010-08-09 14:11:29 +0200 |
| commit | fa69eeb1135e18beeee6f85338a8b208276a425b (patch) | |
| tree | 8578afc04afde36b010302fa689040e1eda71652 /mysql-test/r/insert.result | |
| parent | a0919642873ae7b3172705578d67c8f093fc5fba (diff) | |
| parent | d62bfebc7ede98df28ac75ec0d0880fd07f201db (diff) | |
| download | mariadb-git-fa69eeb1135e18beeee6f85338a8b208276a425b.tar.gz | |
manual merge from mysql-5.1-bugteam
Diffstat (limited to 'mysql-test/r/insert.result')
| -rw-r--r-- | mysql-test/r/insert.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/insert.result b/mysql-test/r/insert.result index b322c5da73a..655303be7f4 100644 --- a/mysql-test/r/insert.result +++ b/mysql-test/r/insert.result @@ -671,3 +671,18 @@ drop table t1; # # End of 5.4 tests # +# +# Bug#54106 assert in Protocol::end_statement, +# INSERT IGNORE ... SELECT ... UNION SELECT ... +# +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 (a, a) VALUES (1, 1); +ERROR 42000: Column 'a' specified twice +INSERT IGNORE t1 (a, a) VALUES (1, 1); +ERROR 42000: Column 'a' specified twice +INSERT IGNORE t1 (a, a) SELECT 1,1; +ERROR 42000: Column 'a' specified twice +INSERT IGNORE t1 (a, a) SELECT 1,1 UNION SELECT 2,2; +ERROR 42000: Column 'a' specified twice +DROP TABLE t1; |