[MDEV-8766] Wrong result for SELECT..WHERE LENGTH(time_column)=8 AND time_column=TIMESTAMP'2001-01-01 10:20:31' - Jira

XML

Word

Printable

SET timestamp=UNIX_TIMESTAMP('2001-01-01 01:02:03');

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a TIME);

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

SELECT * FROM t1 WHERE a=TIMESTAMP'2001-01-01 10:20:31';

SELECT * FROM t1 WHERE LENGTH(a)=8;

SELECT * FROM t1 WHERE LENGTH(a)=8 AND a=TIMESTAMP'2001-01-01 10:20:31';

In the above script the first and the second SELECT queries correctly return one row, the third SELECT query returns erroneously no rows.

blocks

MDEV-8728 Fix a number of problems in equal field and equal expression propagation