diff options
| author | unknown <acurtis@xiphis.org> | 2005-09-08 18:15:05 +0100 |
|---|---|---|
| committer | unknown <acurtis@xiphis.org> | 2005-09-08 18:15:05 +0100 |
| commit | 6e3efdfea7a2f113a9ec874184d87a0eec3f199b (patch) | |
| tree | ff1eda742da9e8543fc6a78360fa2293d3feeb63 /mysql-test/r/derived.result | |
| parent | 824750a9edc0ec1c186d9afbdcdbbdcb7b0b7ac0 (diff) | |
| download | mariadb-git-6e3efdfea7a2f113a9ec874184d87a0eec3f199b.tar.gz | |
Bug#10586
regression test
mysql-test/r/derived.result:
Test for bug
mysql-test/t/derived.test:
Test for bug
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 7c9d88acf90..19325731d35 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -368,3 +368,15 @@ create table t2 (a int); select * from (select * from t1,t2) foo; ERROR 42S21: Duplicate column name 'a' drop table t1,t2; +create table t1 (ID int unsigned not null auto_increment, +DATA varchar(5) not null, primary key (ID)); +create table t2 (ID int unsigned not null auto_increment, +DATA varchar(5) not null, FID int unsigned not null, +primary key (ID)); +select A.* from (t1 inner join (select * from t2) as A on t1.ID = A.FID); +ID DATA FID +select t2.* from ((select * from t1) as A inner join t2 on A.ID = t2.FID); +ID DATA FID +select t2.* from (select * from t1) as A inner join t2 on A.ID = t2.FID; +ID DATA FID +drop table t1, t2; |