--source include/have_innodb.inc

CREATE TABLE t1(
 `c1` date NOT NULL,
  `c2` date DEFAULT NULL,
  `c3` datetime DEFAULT NULL,
  `c4` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`c1`),
  UNIQUE KEY `c2` (`c2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `t1` VALUES ('0000-00-00','0000-00-00','2008-01-04 00:00:00','2008-01-04 18:30:00'),('1983-09-05','1983-09-05','1983-09-06 13:28:00','1983-09-06 07:58:00'),('1983-09-07','1983-09-07','1983-09-08 00:00:00','1983-09-07 18:30:00'),('1998-12-28','1998-12-28','1998-12-28 00:00:00','1998-12-27 18:30:00'),('1998-12-29','1998-12-29','1998-12-29 00:00:00','1998-12-28 18:30:00'),('1998-12-30','1998-12-30','1998-12-30 11:30:45','1998-12-30 06:00:45'),('1998-12-31','1998-12-31','1998-12-31 11:30:45','1998-12-31 06:00:45'),('2007-05-23','2007-05-23','2007-05-24 09:15:28','2007-05-24 03:45:28'),('2007-05-25','2007-05-25','2007-05-26 00:00:00','2007-05-25 18:30:00'),('2008-01-01',NULL,'2008-01-02 00:00:00','2008-01-02 18:30:00'),('2008-01-17',NULL,NULL,'2009-01-29 05:41:27'),('2009-01-29','2009-01-29','2009-01-29 11:11:27','2009-01-28 18:30:00');

SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2;
SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2 LIMIT 2;

--error 0, 1286
alter table t1 engine=falcon;

SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2;
SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2 LIMIT 2;

--error 0, 1286
alter table t1 engine=maria;

SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2;
SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2 LIMIT 2;

alter table t1 engine=myisam;

SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2;
SELECT * FROM t1 WHERE c1 > '1998-12-31 11:30:45' ORDER BY c1,c2 LIMIT 2;

drop table t1;