diff options
| author | unknown <timour/timka@lamia.home> | 2006-09-13 15:22:50 +0300 |
|---|---|---|
| committer | unknown <timour/timka@lamia.home> | 2006-09-13 15:22:50 +0300 |
| commit | ae63ba500aee07b65623765661b141d135079aaf (patch) | |
| tree | 4292b4392f5f5b7332964eccf5e262408f1fb3ef /mysql-test/r/insert_select.result | |
| parent | 40828100e7abb90c12b9e315404a25908d09b67b (diff) | |
| parent | f8ce6e255aa4547d4830b7f61c66f510b817be58 (diff) | |
| download | mariadb-git-ae63ba500aee07b65623765661b141d135079aaf.tar.gz | |
Merge lamia.home:/home/timka/mysql/src/5.0-bug-21774-sm
into lamia.home:/home/timka/mysql/src/5.1-dbg
mysql-test/r/insert_select.result:
Auto merged
sql/sql_base.cc:
Auto merged
sql/sql_insert.cc:
Auto merged
sql/sql_parse.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 1ec24701ae1..95ada9d37be 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -695,6 +695,16 @@ 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; +CREATE DATABASE bug21774_1; +CREATE DATABASE bug21774_2; +CREATE TABLE bug21774_1.t1(id VARCHAR(10) NOT NULL,label VARCHAR(255)); +CREATE TABLE bug21774_2.t1(id VARCHAR(10) NOT NULL,label VARCHAR(255)); +CREATE TABLE bug21774_1.t2(id VARCHAR(10) NOT NULL,label VARCHAR(255)); +INSERT INTO bug21774_2.t1 SELECT t1.* FROM bug21774_1.t1; +use bug21774_1; +INSERT INTO bug21774_2.t1 SELECT t1.* FROM t1; +DROP DATABASE bug21774_1; +DROP DATABASE bug21774_2; CREATE DATABASE meow; CREATE TABLE table_target ( mexs_id CHAR(8), messzeit TIMESTAMP, PRIMARY KEY (mexs_id)); CREATE TABLE table_target2 ( mexs_id CHAR(8), messzeit TIMESTAMP, PRIMARY KEY (mexs_id)); |