diff options
| author | drh <drh@noemail.net> | 2005-04-01 10:47:40 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2005-04-01 10:47:40 +0000 |
| commit | 495c09a49aeb0e5ebd0c63c382562a4db4e9793e (patch) | |
| tree | b515cba721e9235ef31881f2d8acbc3a5016980c /test/select3.test | |
| parent | 9a7e60865da5c3ecbff7b189a48a5bbfc4397d3c (diff) | |
| download | sqlite-495c09a49aeb0e5ebd0c63c382562a4db4e9793e.tar.gz sqlite-495c09a49aeb0e5ebd0c63c382562a4db4e9793e.zip | |
Make the ORDER BY clause return equal elements in the same order they were
seen (a stable sort). It was returning them in exactly the reverse order. (CVS 2439)
FossilOrigin-Name: e8391491a68018406e30c2a699a4cab9e0de092c
Diffstat (limited to 'test/select3.test')
| -rw-r--r-- | test/select3.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/test/select3.test b/test/select3.test index 2b31329cb..f0be520a2 100644 --- a/test/select3.test +++ b/test/select3.test @@ -12,7 +12,7 @@ # focus of this file is testing aggregate functions and the # GROUP BY and HAVING clauses of SELECT statements. # -# $Id: select3.test,v 1.12 2004/08/20 18:34:20 drh Exp $ +# $Id: select3.test,v 1.13 2005/04/01 10:47:40 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -76,9 +76,9 @@ do_test select3-2.6 { } {1 1 3 1 5 2 7 4 9 8 11 15} do_test select3-2.7 { execsql { - SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y + SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y, x } -} {3 1 1 1 5 2 7 4 9 8 11 15} +} {1 1 3 1 5 2 7 4 9 8 11 15} do_test select3-2.8 { execsql { SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y) |