diff options
| author | joreland@mysql.com <> | 2004-10-12 07:20:38 +0200 |
|---|---|---|
| committer | joreland@mysql.com <> | 2004-10-12 07:20:38 +0200 |
| commit | 4041575a460bed8320475283004c53b23a101ba7 (patch) | |
| tree | f74b7380781ab5e96f737b6b9c6d2d2d51de8e89 /mysql-test | |
| parent | ed52b77483dc683333c327f99858f55553af58a3 (diff) | |
| download | mariadb-git-4041575a460bed8320475283004c53b23a101ba7.tar.gz | |
Fix order by
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ndb_index_ordered.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/ndb_index_ordered.test | 2 |
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/ndb_index_ordered.result b/mysql-test/r/ndb_index_ordered.result index 2910161eb74..2dc260ec43d 100644 --- a/mysql-test/r/ndb_index_ordered.result +++ b/mysql-test/r/ndb_index_ordered.result @@ -37,14 +37,14 @@ a b c 1 2 3 2 3 5 3 4 6 -select tt1.* from t1 as tt1, t1 as tt2 use index(b) where tt1.b = tt2.b order by tt1.c; +select tt1.* from t1 as tt1, t1 as tt2 use index(b) where tt1.b = tt2.b order by tt1.b; a b c -6 7 2 -5 6 2 1 2 3 2 3 5 3 4 6 4 5 8 +5 6 2 +6 7 2 select a, b, c from t1 where a!=2 and c=6; a b c 3 4 6 diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test index 67c42e29e0c..64291c8ab97 100644 --- a/mysql-test/t/ndb_index_ordered.test +++ b/mysql-test/t/ndb_index_ordered.test @@ -24,7 +24,7 @@ select * from t1 where b < 4 order by b; select * from t1 where b <= 4 order by b; # Test of reset_bounds -select tt1.* from t1 as tt1, t1 as tt2 use index(b) where tt1.b = tt2.b order by tt1.c; +select tt1.* from t1 as tt1, t1 as tt2 use index(b) where tt1.b = tt2.b order by tt1.b; select a, b, c from t1 where a!=2 and c=6; select a, b, c from t1 where a!=2 order by a; |