diff options
| author | unknown <gkodinov@mysql.com> | 2006-06-21 13:03:06 +0300 |
|---|---|---|
| committer | unknown <gkodinov@mysql.com> | 2006-06-21 13:03:06 +0300 |
| commit | b92ad63f995d9cd301dc9ebbad241a834e2d9ed0 (patch) | |
| tree | ef3a7f7c8b8fc35254fc283ad145010517bc59e3 /mysql-test/r/insert_select.result | |
| parent | 2346733139a5286a5d6596f4c086c985e03b8b4f (diff) | |
| parent | b7e27e80d9dc065d2ecc49aad371a71ad3a824a4 (diff) | |
| download | mariadb-git-b92ad63f995d9cd301dc9ebbad241a834e2d9ed0.tar.gz | |
merge of the changes for bug #18080
mysql-test/t/insert_select.test:
Auto merged
mysql-test/r/insert_select.result:
manual merge
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 2cfbb51441d..49d9c3594db 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -690,3 +690,8 @@ CREATE TABLE t1 (a int PRIMARY KEY); INSERT INTO t1 values (1), (2); INSERT INTO t1 SELECT a + 2 FROM t1 LIMIT 1; DROP TABLE t1; +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; |