diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-11-07 11:53:48 +0100 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-11-07 11:53:48 +0100 |
| commit | 4d37f9b56aff2df91f40f9c3c00be611914724d5 (patch) | |
| tree | 75c8623a7899bddd9ba5b4bbffdee0bf1869702d /mysql-test/t/order_by.test | |
| parent | 030d080d8b4eb8154aa4da13b28c5b81cba09b03 (diff) | |
| parent | c095f98ff7d18e2e5de1adf629147f2b199fbfaf (diff) | |
| download | mariadb-git-4d37f9b56aff2df91f40f9c3c00be611914724d5.tar.gz | |
Merge dl145s.mysql.com:/data/bk/team_tree_merge/mysql-4.1-opt
into dl145s.mysql.com:/data/bk/team_tree_merge/MERGE/mysql-5.0-opt
sql/item.cc:
Auto merged
mysql-test/r/order_by.result:
SCCS merged
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 1104c859ab8..30dc4d2653e 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -577,6 +577,22 @@ INSERT INTO t1 VALUES (1,30), (2,20), (1,10), (2,30), (1,20), (2,10); DROP TABLE t1; +# +# Bug #22457: Column alias in ORDER BY works, but not if in an expression +# + +CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1),(2); +SELECT a + 1 AS num FROM t1 ORDER BY 30 - num; +SELECT CONCAT('test', a) AS str FROM t1 ORDER BY UPPER(str); +SELECT a + 1 AS num FROM t1 GROUP BY 30 - num; +SELECT a + 1 AS num FROM t1 HAVING 30 - num; +--error 1054 +SELECT a + 1 AS num, num + 1 FROM t1; +SELECT a + 1 AS num, (select num + 2 FROM t1 LIMIT 1) FROM t1; +--error 1054 +SELECT a.a + 1 AS num FROM t1 a JOIN t1 b ON num = b.a; +DROP TABLE t1; + # End of 4.1 tests # |