|
This problem is similar to MDEV-11497, but now for the simple CASE operator:
CASE suffers from the same problem:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a BIGINT, b BIGINT UNSIGNED);
|
INSERT INTO t1 VALUES (-9223372036854775808,18446744073709551615);
|
SELECT
|
CASE -1
|
WHEN -9223372036854775808 THEN 'one'
|
WHEN 18446744073709551615 THEN 'two'
|
END;
|
+-------------------------------------------------------------------------------------------------+
|
| CASE -1
|
WHEN -9223372036854775808 THEN 'one'
|
WHEN 18446744073709551615 THEN 'two'
|
END |
|
+-------------------------------------------------------------------------------------------------+
|
| two |
|
+-------------------------------------------------------------------------------------------------+
|
The expected result is to return NULL.
|