summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <joreland@mysql.com>2004-07-05 07:14:45 +0200
committerunknown <joreland@mysql.com>2004-07-05 07:14:45 +0200
commit41b04a9b1eea5828179be8316364c681388fce95 (patch)
tree99b073436f363faebccf3263aebff03032f6a6f5 /mysql-test
parenta7909ab90a3bbfcc69016af4d7a6541929bc2839 (diff)
downloadmariadb-git-41b04a9b1eea5828179be8316364c681388fce95.tar.gz
Fix mysql-test-run ndb order by/endian issue
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/ndb_index_ordered.result4
-rw-r--r--mysql-test/t/ndb_index_ordered.test2
2 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/ndb_index_ordered.result b/mysql-test/r/ndb_index_ordered.result
index 79472c70e8e..0e3bd555b0a 100644
--- a/mysql-test/r/ndb_index_ordered.result
+++ b/mysql-test/r/ndb_index_ordered.result
@@ -175,10 +175,10 @@ insert into t1 values (19,4, 0);
select * from t1 where b<=5 and c=0;
a b c
19 4 0
-select * from t1 where b=4 and c<=5;
+select * from t1 where b=4 and c<=5 order by a;
a b c
-19 4 0
17 4 4
+19 4 0
select * from t1 where b<=4 and c<=5 order by a;
a b c
7 2 1
diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test
index 79686fce0e1..feb4476f5e7 100644
--- a/mysql-test/t/ndb_index_ordered.test
+++ b/mysql-test/t/ndb_index_ordered.test
@@ -106,7 +106,7 @@ select * from t1 where b<=5 order by a;
select * from t1 where b<=5 and c=0;
insert into t1 values (19,4, 0);
select * from t1 where b<=5 and c=0;
-select * from t1 where b=4 and c<=5;
+select * from t1 where b=4 and c<=5 order by a;
select * from t1 where b<=4 and c<=5 order by a;
select * from t1 where b<=5 and c=0 or b<=5 and c=2;
drop table t1;