Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.1.2
-
Component/s: Temporal Types
-
Labels: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.