diff options
| author | joreland@mysql.com <> | 2004-08-27 00:59:16 +0200 |
|---|---|---|
| committer | joreland@mysql.com <> | 2004-08-27 00:59:16 +0200 |
| commit | 95e5b457b876e06ec94f02050b79a392fd6cc358 (patch) | |
| tree | 1becf9e6468c4d6c328fa0f502a2755c8d603212 /mysql-test | |
| parent | 9bc14a960515a1e8af4f680adbe24e7a6d915981 (diff) | |
| download | mariadb-git-95e5b457b876e06ec94f02050b79a392fd6cc358.tar.gz | |
Fix ordered index scan with partially specified key
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; # |