diff options
author | unknown <mskold@mysql.com> | 2004-08-31 10:19:10 +0200 |
---|---|---|
committer | unknown <mskold@mysql.com> | 2004-08-31 10:19:10 +0200 |
commit | c52a30b5dfc80341567a2e286c554fc35964cae9 (patch) | |
tree | 21913d37dde16a0be3ad58b3b6405223d2ee0b23 /mysql-test/t/ndb_index_ordered.test | |
parent | 2e86cdb17918e13aca61ea116f9a9ee4c0b6e1ed (diff) | |
download | mariadb-git-c52a30b5dfc80341567a2e286c554fc35964cae9.tar.gz |
Enabled HA_NULL_IN_KEY support
Diffstat (limited to 'mysql-test/t/ndb_index_ordered.test')
-rw-r--r-- | mysql-test/t/ndb_index_ordered.test | 34 |
1 files changed, 19 insertions, 15 deletions
diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test index cffe9236fb5..00807bfcb98 100644 --- a/mysql-test/t/ndb_index_ordered.test +++ b/mysql-test/t/ndb_index_ordered.test @@ -122,18 +122,22 @@ drop table t1; # Indexing NULL values # -#CREATE TABLE t1 ( -# a int unsigned NOT NULL PRIMARY KEY, -# b int unsigned, -# c int unsigned, -# KEY bc(b,c) -#) engine = ndb; - -#insert into t1 values(1,1,1),(2,NULL,2),(3,NULL,NULL),(4,4,NULL); -#select * from t1 use index (bc); -#select count(*) from t1 use index (bc); -#select count(*) from t1 use index (PRIMARY) where b IS NULL; -#select count(*) from t1 use index (bc) where b IS NULL; -#select count(*) from t1 use index (bc) where b IS NULL and c = 2; -#select count(*) from t1 use index (bc) where b IS NOT NULL; -#drop table t1; +CREATE TABLE t1 ( + a int unsigned NOT NULL PRIMARY KEY, + b int unsigned, + c int unsigned, + KEY bc(b,c) +) engine = ndb; + +insert into t1 values(1,1,1),(2,NULL,2),(3,NULL,NULL),(4,4,NULL); +select * from t1 use index (bc) where b IS NULL; + +select * from t1 use index (bc)order by a; +select * from t1 use index (bc) order by a; +select * from t1 use index (PRIMARY) where b IS NULL order by a; +select * from t1 use index (bc) where b IS NULL order by a; +select * from t1 use index (bc) where b IS NULL and c IS NULL order by a; +select * from t1 use index (bc) where b IS NULL and c = 2 order by a; +select * from t1 use index (bc) where b < 4 order by a; +select * from t1 use index (bc) where b IS NOT NULL order by a; +drop table t1; |