diff options
| author | unknown <pekka@mysql.com> | 2005-01-08 15:18:24 +0100 |
|---|---|---|
| committer | unknown <pekka@mysql.com> | 2005-01-08 15:18:24 +0100 |
| commit | 2a3f285eb5a0c3156fc768f886e17d9cc7f1d195 (patch) | |
| tree | 1da7d6e6a55022b2d72e495e670a28e891af7f8f | |
| parent | ce6de604c899167d930d01f8500bbd81d1f0e24b (diff) | |
| download | mariadb-git-2a3f285eb5a0c3156fc768f886e17d9cc7f1d195.tar.gz | |
ndb - wl-1442 updated ndb_index_ordered.result
mysql-test/r/ndb_index_ordered.result:
wl-1442 missed result file
| -rw-r--r-- | mysql-test/r/ndb_index_ordered.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_ordered.result b/mysql-test/r/ndb_index_ordered.result index 50f904af750..a3eb5630131 100644 --- a/mysql-test/r/ndb_index_ordered.result +++ b/mysql-test/r/ndb_index_ordered.result @@ -310,3 +310,34 @@ SubscrID SbclID 3 NULL drop table test1; drop table test2; +create table t1 ( +pk int primary key, +dt datetime not null, +da date not null, +ye year not null, +ti time not null, +ts timestamp not null, +index(dt), +index(da), +index(ye), +index(ti), +index(ts) +) engine=ndb; +insert into t1 (pk,dt,da,ye,ti) values +(1, '1901-05-05 23:00:59', '1901-05-05', '1901', '23:00:59'), +(2, '1955-12-31 00:00:00', '1955-12-31', '1955', '00:00:00'), +(3, '1999-06-06 06:06:06', '1999-06-06', '1999', '06:06:06'), +(4, '2001-01-01 10:11:11', '2001-01-01', '2001', '10:11:11'), +(5, '2005-01-31 23:59:59', '2005-01-31', '2005', '23:59:59'); +select count(*) from t1 use index (dt) where dt > '1900-01-01 00:00:00'; +count(*) +5 +select count(*) from t1 use index (dt) where dt > '1955-12-31 00:00:00'; +count(*) +3 +select count(*) from t1 use index (dt) where dt < '2001-01-01 10:11:11'; +count(*) +3 +select count(*) from t1 use index (dt) where dt < '2001-01-01 10:11:12'; +count(*) +4 |