|
This problem is similar to MDEV-11514, but now for the CASE operator.
SELECT
|
CASE TIME'10:20:30'
|
WHEN 102030 THEN 'one'
|
WHEN TIME'10:20:31' THEN 'two'
|
END AS good,
|
CASE TIME'10:20:30'
|
WHEN 102030 THEN 'one'
|
WHEN TIME'10:20:31' THEN 'two'
|
WHEN TIMESTAMP'2001-01-01 10:20:32' THEN 'three'
|
END AS bad;
|
SHOW WARNINGS;
|
+------+------+
|
| good | bad |
|
+------+------+
|
| one | NULL |
|
+------+------+
|
+---------+------+------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------+
|
| Warning | 1292 | Incorrect datetime value: '102030' |
|
+---------+------+------------------------------------+
|
The expected result is to return "one" in both columns.
|