diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-02 20:18:51 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-02 20:18:51 +0200 |
| commit | 47af809c617a9582a71ff0a13aeed4c74d848ef6 (patch) | |
| tree | 374595893cfcdc147203da32bfac612391bffa8d /mysql-test/t/union.test | |
| parent | 36429430c6bd18b7cccd459711ddd0ab30a2e63e (diff) | |
| download | mariadb-git-47af809c617a9582a71ff0a13aeed4c74d848ef6.tar.gz | |
Proper handling of ORDER BY table.column in UNION's
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 0b4e4943ba6..9ddfda7872f 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -20,6 +20,7 @@ select 't1',b,count(*) from t1 group by b UNION select 't2',b,count(*) from t2 g (select a,b from t1 limit 2) union all (select a,b from t2 order by a) limit 4; (select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1); (select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1) order by b desc; +--error 1248 (select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1) order by t1.b; explain (select a,b from t1 limit 2) union all (select a,b from t2 order by a limit 1) order by b desc; #(select sql_calc_found_rows a,b from t1 limit 2) union all (select a,b from t2 order by a) limit 2; |