diff options
| author | unknown <hf@deer.(none)> | 2003-11-21 11:58:28 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2003-11-21 11:58:28 +0400 |
| commit | 95c6226af717ed5fad0ea013d4c75433743c1156 (patch) | |
| tree | 1958030cb2e4fd7b1e8695db55ab95957c4c1eab /mysql-test/r/derived.result | |
| parent | 8848cea28797c2e08898bbcb782b6c830ee3f42e (diff) | |
| parent | e2661bdbba9d81f00fb6ef5bdfeee343b3496ee2 (diff) | |
| download | mariadb-git-95c6226af717ed5fad0ea013d4c75433743c1156.tar.gz | |
Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-4.1
into deer.(none):/home/hf/work/mysql-4.1.1727
mysql-test/r/derived.result:
Auto merged
mysql-test/t/derived.test:
Auto merged
sql/sql_lex.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 6d322078018..bb268cd1094 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -228,3 +228,20 @@ id select_type table type possible_keys key key_len ref rows Extra 2 DERIVED t1 ALL NULL NULL NULL NULL 2 Using where 3 DEPENDENT SUBQUERY B ALL NULL NULL NULL NULL 2 Using where drop table t1; +create table t1 (a int); +insert into t1 values (1),(2); +select * from ( select * from t1 union select * from t1) a,(select * from t1 union select * from t1) b; +a a +1 1 +2 1 +1 2 +2 2 +explain select * from ( select * from t1 union select * from t1) a,(select * from t1 union select * from t1) b; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 +1 PRIMARY <derived4> ALL NULL NULL NULL NULL 2 +4 DERIVED t1 ALL NULL NULL NULL NULL 2 +5 UNION t1 ALL NULL NULL NULL NULL 2 +2 DERIVED t1 ALL NULL NULL NULL NULL 2 +3 UNION t1 ALL NULL NULL NULL NULL 2 +drop table t1; |