diff options
| author | unknown <evgen@moonbone.local> | 2007-03-07 12:10:59 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-03-07 12:10:59 +0300 |
| commit | cf31dff6f21e3459406218f8f0fe9eb184c93019 (patch) | |
| tree | 616af65d647639468e1ee7bb3433f28cf6fe3293 /mysql-test/r/order_by.result | |
| parent | 4b40ed9532c28605a19fd9cd0ed27da3746fa430 (diff) | |
| parent | 38acf43e34a617480f9bdb21df25f5ca76d54c8a (diff) | |
| download | mariadb-git-cf31dff6f21e3459406218f8f0fe9eb184c93019.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into moonbone.local:/mnt/gentoo64/work/25376-bug-5.0-opt-mysql
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/order_by.result')
| -rw-r--r-- | mysql-test/r/order_by.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result index e81d46c9199..0b1edfd3e8f 100644 --- a/mysql-test/r/order_by.result +++ b/mysql-test/r/order_by.result @@ -926,3 +926,11 @@ NULL 2 3 DROP TABLE t1,t2,t3,t4; +create table t1 (a int, b int, c int); +insert into t1 values (1,2,3), (9,8,3), (19,4,3), (1,4,9); +select a,(sum(b)/sum(c)) as ratio from t1 group by a order by sum(b)/sum(c) asc; +a ratio +1 0.5000 +19 1.3333 +9 2.6667 +drop table t1; |