diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-10-03 18:47:04 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-10-03 18:47:04 +0300 |
| commit | f094b6af4c5c32bfda7f74461d47675ab61722a0 (patch) | |
| tree | a10d91a6ce2aa4dc6b0104292912675442cafafb /mysql-test/r/union.result | |
| parent | c9a2b58986635015b3f3867999ef3fafa2bd2728 (diff) | |
| download | mariadb-git-f094b6af4c5c32bfda7f74461d47675ab61722a0.tar.gz | |
fixing EXPLAIN select types
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 86f62d11bdb..c64ee2ecd78 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -86,29 +86,29 @@ a b 1 a explain (select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1) order by b desc; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 +1 PRIMARY t1 ALL NULL NULL NULL NULL 4 2 UNION t2 ALL NULL NULL NULL NULL 4 Using filesort select found_rows(); FOUND_ROWS() 0 explain select a,b from t1 union all select a,b from t2; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 +1 PRIMARY t1 ALL NULL NULL NULL NULL 4 2 UNION t2 ALL NULL NULL NULL NULL 4 explain select xx from t1 union select 1; Unknown column 'xx' in 'field list' explain select a,b from t1 union select 1; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 +1 PRIMARY t1 ALL NULL NULL NULL NULL 4 2 UNION No tables used explain select 1 union select a,b from t1 union select 1; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST No tables used +1 PRIMARY No tables used 2 UNION t1 ALL NULL NULL NULL NULL 4 3 UNION No tables used explain select a,b from t1 union select 1 limit 0; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST Impossible WHERE +1 PRIMARY Impossible WHERE 2 UNION Impossible WHERE select a,b from t1 into outfile 'skr' union select a,b from t2; Wrong usage of UNION and INTO |