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

XML

Word

Printable

SELECT TIMESTAMP(0)='z', TIME(0)='z';

SHOW WARNINGS;

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

| Level   | Code | Message                             |

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

| Warning | 1292 | Incorrect datetime value: 'z'       |

| Warning | 1292 | Truncated incorrect time value: 'z' |

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

Perhaps the same warning should be displayed.

blocks

MDEV-4912 Data type plugin API version 1

relates to

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

MDEV-17632 Inconsistent behavior of conversion to DATETIME for comparison

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