diff options
| author | bell@sanja.is.com.ua <> | 2004-05-19 17:07:28 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-05-19 17:07:28 +0300 |
| commit | d42d709171cae604dba0c6216a0d0d1878ae16c3 (patch) | |
| tree | ee18fab3d095804e9a76acc18f491adfe2f6cc6f /mysql-test/r/derived.result | |
| parent | bb34b56bfdd39b1c44cd320cf9ba215631b88c04 (diff) | |
| download | mariadb-git-d42d709171cae604dba0c6216a0d0d1878ae16c3.tar.gz | |
after review changes
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index cdbca9aa2aa..dd4c32403b5 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -94,13 +94,13 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> ALL NULL NULL NULL NULL 3 2 DERIVED t1 ALL NULL NULL NULL NULL 4 3 UNION t1 ALL NULL NULL NULL NULL 4 --2 UNION RESULT <union2> ALL NULL NULL NULL NULL NULL +NULL UNION RESULT <union2,3> ALL NULL NULL NULL NULL NULL explain select * from (select * from t1 union all select * from t1) a; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> ALL NULL NULL NULL NULL 8 2 DERIVED t1 ALL NULL NULL NULL NULL 4 3 UNION t1 ALL NULL NULL NULL NULL 4 --2 UNION RESULT <union2> ALL NULL NULL NULL NULL NULL +NULL UNION RESULT <union2,3> ALL NULL NULL NULL NULL NULL CREATE TABLE t2 (a int not null); insert into t2 values(1); select * from (select * from t1 where t1.a=(select a from t2 where t2.a=t1.a)) a; @@ -248,10 +248,10 @@ id select_type table type possible_keys key key_len ref rows Extra 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 --4 UNION RESULT <union4> ALL NULL NULL NULL NULL NULL +NULL UNION RESULT <union4,5> ALL NULL NULL NULL NULL NULL 2 DERIVED t1 ALL NULL NULL NULL NULL 2 3 UNION t1 ALL NULL NULL NULL NULL 2 --2 UNION RESULT <union2> ALL NULL NULL NULL NULL NULL +NULL UNION RESULT <union2,3> ALL NULL NULL NULL NULL NULL drop table t1; CREATE TABLE `t1` ( `N` int(11) unsigned NOT NULL default '0', |