diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2004-03-22 16:35:15 +0200 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2004-03-22 16:35:15 +0200 |
| commit | 2eaa07f1993f3719874e65aeb39f37539e19311b (patch) | |
| tree | 309edb65362798ab2f4b68d7a2bdcfd27c4aca54 /mysql-test/t/union.test | |
| parent | 99d6ad06b5b13b3ced97005c0aba7f0242ca4fbc (diff) | |
| download | mariadb-git-2eaa07f1993f3719874e65aeb39f37539e19311b.tar.gz | |
union.result:
A test case for the bug that allowed table names to be used in ORDER BY columns (But #3064)
union.test:
A test case for the bug that allowed table names to be used in ORDER BY columns (But #3064)
sql_union.cc:
A fix for a bug that allowed table names to be used in ORDER BY columns (But #3064)
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index badfe4b9a3a..c978aef9ce0 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -226,6 +226,8 @@ SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a desc LIMIT 1; create temporary table t1 select a from t1 union select a from t2; --error 1093 create table t1 select a from t1 union select a from t2; +--error 1054 +select a from t1 union select a from t2 order by t2.a; drop table t1,t2; # |