Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a YEAR(2)); |
INSERT INTO t1 VALUES (0); |
SELECT a,NULLIF(a,2000),NULLIF(2001,a) FROM t1; |
returns
+------+----------------+----------------+
|
| a | NULLIF(a,2000) | NULLIF(2001,a) |
|
+------+----------------+----------------+
|
| 00 | NULL | 1 |
|
+------+----------------+----------------+
|
This is Ok that YEAR=00 is compared as equal to 2000, but the return value for NULLIF(2001,a) does not look Ok. The expected values is 2001, not 1.