--disable_warnings

drop table if exists t1;

--enable_warnings

SET timestamp=DEFAULT;

SET @@old_mode=zero_date_time_cast;

--echo # TIMESTAMP literal, old mode

CREATE TABLE t1 (a TIME);

INSERT INTO t1 VALUES ('0000-00-00 10:20:30'),('0000-00-00 10:20:31');

INSERT INTO t1 VALUES ('0000-00-01 10:20:30'),('0000-00-01 10:20:31');

INSERT INTO t1 VALUES ('31 10:20:30'),('32 10:20:30'),('33 10:20:30'),('34 10:20:30');

SELECT * FROM t1;

--echo # Old mode, TIMESTAMP-alike literal, zon-zero YYYYMMDD, no propagation

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30';

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30' AND LENGTH(a)=8;

EXPLAIN EXTENDED

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30' AND LENGTH(a)=8;

EXPLAIN EXTENDED

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30' AND LENGTH(a)=30+RAND();

DROP TABLE t1;

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30';

a

34:20:30

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30' AND LENGTH(a)=8;

a

34:20:30

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30';

a

SELECT * FROM t1 WHERE a='0000-00-01 10:20:30' AND LENGTH(a)=8;

a