diff options
| author | gkodinov@mysql.com <> | 2006-06-21 13:03:06 +0300 |
|---|---|---|
| committer | gkodinov@mysql.com <> | 2006-06-21 13:03:06 +0300 |
| commit | f327a8c536b48b64b45ef7049aaa46881bd1d302 (patch) | |
| tree | ef3a7f7c8b8fc35254fc283ad145010517bc59e3 /mysql-test/t/insert_select.test | |
| parent | d924f70cc7b00dcc650a354b76707f0fe4cd27a7 (diff) | |
| parent | 5508df251f4ba04182233ff920e1a14f55a223f4 (diff) | |
| download | mariadb-git-f327a8c536b48b64b45ef7049aaa46881bd1d302.tar.gz | |
merge of the changes for bug #18080
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 0b9a0e86ba9..05953a1fd49 100644 --- a/mysql-test/t/insert_select.test +++ b/mysql-test/t/insert_select.test @@ -238,3 +238,12 @@ INSERT INTO t1 SELECT a + 2 FROM t1 LIMIT 1; DROP TABLE t1; # End of 4.1 tests + +# +# Bug #18080: INSERT ... SELECT ... JOIN results in ambiguous field list error +# +CREATE TABLE t1 (x int, y int); +CREATE TABLE t2 (z int, y int); +CREATE TABLE t3 (a int, b int); +INSERT INTO t3 (SELECT x, y FROM t1 JOIN t2 USING (y) WHERE z = 1); +DROP TABLE IF EXISTS t1,t2,t3; |