diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-12 16:09:06 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-12 16:09:06 +0200 |
| commit | 657b311206e5230e540845fedbb388a683d0e917 (patch) | |
| tree | 92a456da0a6fe604493cc93e3cfbb89268ca086e /mysql-test/t/derived.test | |
| parent | 62ce900c2e116627b05a611e6ad03698b6b18a3b (diff) | |
| download | mariadb-git-657b311206e5230e540845fedbb388a683d0e917.tar.gz | |
derived tables with UNION's ...
Scrum task !!!!!
mysql-test/r/analyse.result:
reverting a fix
mysql-test/r/derived.result:
derived tables with UNION's ...
mysql-test/t/analyse.test:
reverting a fix
mysql-test/t/derived.test:
derived tables with UNION's ...
sql/mysql_priv.h:
derived tables with UNION's ...
sql/sql_analyse.cc:
reverting a fix
sql/sql_derived.cc:
derived tables with UNION's ...
sql/sql_lex.cc:
derived tables with UNION's ...
sql/sql_select.cc:
derived tables with UNION's ...
sql/sql_union.cc:
derived tables with UNION's ...
Diffstat (limited to 'mysql-test/t/derived.test')
| -rw-r--r-- | mysql-test/t/derived.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test index 8f187dd46ba..5f63cea3c11 100644 --- a/mysql-test/t/derived.test +++ b/mysql-test/t/derived.test @@ -24,6 +24,10 @@ drop table if exists t1.t2,t3; select * from (select 1) as a; select a from (select 1 as a) as b; select 1 from (select 1) as a; +select * from (select * from t1 union select * from t1) a; +select * from (select * from t1 union all select * from t1) a; +explain select * from (select * from t1 union select * from t1) a; +explain select * from (select * from t1 union all select * from t1) a; drop table if exists t1; create table t1(a int not null, t char(8), index(a)); disable_query_log; |