diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-05-15 12:11:07 +0500 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-05-15 12:11:07 +0500 |
| commit | 376d67e5c0718fc611917523435c1a753eaffe7a (patch) | |
| tree | de162ac67331aad8bb2ab68081ce0d6cb5183c0f /mysql-test/r/union.result | |
| parent | 5f3dc895b0b80228a3c09385f82be001db2bf2c4 (diff) | |
| parent | fc57b4cfb569635edc1613154d9b7ed14efaf840 (diff) | |
| download | mariadb-git-376d67e5c0718fc611917523435c1a753eaffe7a.tar.gz | |
5.0-bugteam->5.1-bugteam merge
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 23a7724984c..44a3812725a 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -1574,4 +1574,17 @@ SHOW FIELDS FROM t2; Field Type Null Key Default Extra d double(9,6) YES NULL DROP TABLE t1, t2; +CREATE TABLE t1(a INT); +EXPLAIN EXTENDED +SELECT a FROM t1 +UNION +SELECT a FROM t1 +ORDER BY a; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY t1 system NULL NULL NULL NULL 0 0.00 const row not found +2 UNION t1 system NULL NULL NULL NULL 0 0.00 const row not found +NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL NULL Using filesort +Warnings: +Note 1003 select '0' AS `a` from `test`.`t1` union select '0' AS `a` from `test`.`t1` order by `a` +DROP TABLE t1; End of 5.0 tests |