[MDEV-17634] Regression: TIME(0)=TIME('z') returns NULL vs 1 - Jira

XML

Word

Printable

SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t;

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

| ts   | d    | t    |

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

|    1 |    1 | NULL |

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

SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t;

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

| ts   | d    | t    |

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

|    1 |    1 |    1 |

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

relates to

MDEV-17632 Inconsistent behavior of conversion to DATETIME for comparison

MDEV-17563 Different results using table or view when comparing values of time type

MDEV-17625 Different warnings when comparing a garbage to DATETIME vs TIME