diff options
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 206b40f8ce7..263f631a65f 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -265,6 +265,14 @@ drop table t1,t2; select length(version()) > 1 as `*` UNION select 2; # +# Bug #4980: problem with explain +# + +create table t1 (a int); +insert into t1 values (0), (3), (1), (2); +explain (select * from t1) union (select * from t1) order by a; +drop table t1; +# # Test for another bug with UNION and LEFT JOIN # CREATE TABLE t1 ( id int(3) unsigned default '0') ENGINE=MyISAM; |