diff options
| author | unknown <joreland@mysql.com> | 2004-08-27 01:01:47 +0200 |
|---|---|---|
| committer | unknown <joreland@mysql.com> | 2004-08-27 01:01:47 +0200 |
| commit | cb76f3c076fa61d3cc979c80d518417efade434e (patch) | |
| tree | 72d7c35808f62c237f964103b9ae41c8d82ea960 /mysql-test | |
| parent | 1b0dee296d2623c48229ce930f6dba84d40fc393 (diff) | |
| parent | b5ebc0f259de7d3ed8a13adaf161d499f6596b6c (diff) | |
| download | mariadb-git-cb76f3c076fa61d3cc979c80d518417efade434e.tar.gz | |
Merge joreland@bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/jonas/src/mysql-4.1
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 | 3 |
2 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_ordered.result b/mysql-test/r/ndb_index_ordered.result index 75de1ac4a7f..1441e53e935 100644 --- a/mysql-test/r/ndb_index_ordered.result +++ b/mysql-test/r/ndb_index_ordered.result @@ -205,4 +205,10 @@ a b c select * from t1 where b<=5 and c=0 or b<=5 and c=2; a b c 19 4 0 +select count(*) from t1 where b = 0; +count(*) +0 +select count(*) from t1 where b = 1; +count(*) +1 drop table t1; diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test index 3def52e865c..cffe9236fb5 100644 --- a/mysql-test/t/ndb_index_ordered.test +++ b/mysql-test/t/ndb_index_ordered.test @@ -113,6 +113,9 @@ select * from t1 where b<=5 and c=0; 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; + +select count(*) from t1 where b = 0; +select count(*) from t1 where b = 1; drop table t1; # |