SET storage_engine = Falcon;
#
# Mantis bug #139: AND fails if index exists
#
--echo *** Bug #139 ***
--disable_warnings
DROP TABLE IF EXISTS t3;
--enable_warnings

CREATE TABLE t3 (
  place_id int (10) unsigned,
  ts timestamp, 
  PRIMARY KEY (place_id, ts)
);

INSERT INTO t3 VALUES (1,20000928174434);
SELECT * FROM t3 WHERE place_id = 1 AND ts>='2000-09-28 00:00:00';
SELECT * FROM t3 WHERE place_id = 1 AND ts >= 20000928000000;

# Final cleanup
DROP TABLE t3;
