diff options
| author | unknown <mskold/marty@mysql.com/linux.site> | 2006-09-05 17:07:00 +0200 |
|---|---|---|
| committer | unknown <mskold/marty@mysql.com/linux.site> | 2006-09-05 17:07:00 +0200 |
| commit | 545c9b8fdecad04d6b5acaaa1400ca8be7a7066c (patch) | |
| tree | ff9cd6c538af3a1d2f1d0a998f82d25e2a312d63 /mysql-test/t/ndb_condition_pushdown.test | |
| parent | 7ec32371295cd3050d3a9f80585f21e4c6b20919 (diff) | |
| download | mariadb-git-545c9b8fdecad04d6b5acaaa1400ca8be7a7066c.tar.gz | |
Bug #21056 ndb pushdown equal/setValue error on datetime: only pushdown like of string type fields
Diffstat (limited to 'mysql-test/t/ndb_condition_pushdown.test')
| -rw-r--r-- | mysql-test/t/ndb_condition_pushdown.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_condition_pushdown.test b/mysql-test/t/ndb_condition_pushdown.test index cc138b32b7e..765c5d06bab 100644 --- a/mysql-test/t/ndb_condition_pushdown.test +++ b/mysql-test/t/ndb_condition_pushdown.test @@ -1649,6 +1649,16 @@ set engine_condition_pushdown = on; explain select * from t5 where b like '%jo%'; select * from t5 where b like '%jo%' order by a; +# bug#21056 ndb pushdown equal/setValue error on datetime +set engine_condition_pushdown = off; +select auto from t1 where date_time like '1902-02-02 %'; +select auto from t1 where date_time not like '1902-02-02 %'; +set engine_condition_pushdown = on; +explain select auto from t1 where date_time like '1902-02-02 %'; +select auto from t1 where date_time like '1902-02-02 %'; +explain select auto from t1 where date_time not like '1902-02-02 %'; +select auto from t1 where date_time not like '1902-02-02 %'; + # bug#17421 -1 drop table t1; create table t1 (a int, b varchar(3), primary key using hash(a)) |