DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a DATE);

INSERT INTO t1 VALUES ('2001-01-01');

EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a BETWEEN '2001-01-01' AND '2001-01-02';

SHOW WARNINGS;

EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a IN ('2001-01-01','2001-01-02');

SHOW WARNINGS;

+-------+------+---------------------------------------------------------------------------------------+

| Level | Code | Message                                                                               |

+-------+------+---------------------------------------------------------------------------------------+

| Note  | 1003 | select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = '2001-01-01') |

+-------+------+---------------------------------------------------------------------------------------+

+-------+------+---------------------------------------------------------------------------------------+

| Level | Code | Message                                                                               |

+-------+------+---------------------------------------------------------------------------------------+

| Note  | 1003 | select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = '2001-01-01') |

+-------+------+---------------------------------------------------------------------------------------+

+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------+

| Level | Code | Message                                                                                                                                             |

+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------+

| Note  | 1003 | select `test`.`t1`.`a` AS `a` from `test`.`t1` where ((`test`.`t1`.`a` = '2001-01-01') and (`test`.`t1`.`a` between '2001-01-01' and '2001-01-02')) |

+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------+

+-------+------+----------------------------------------------------------------------------------------------------------------------------------------------+

| Level | Code | Message                                                                                                                                      |

+-------+------+----------------------------------------------------------------------------------------------------------------------------------------------+

| Note  | 1003 | select `test`.`t1`.`a` AS `a` from `test`.`t1` where ((`test`.`t1`.`a` = '2001-01-01') and (`test`.`t1`.`a` in ('2001-01-01','2001-01-02'))) |

+-------+------+----------------------------------------------------------------------------------------------------------------------------------------------+