Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.3, 10.3.36, 10.5.17, 10.9.2
-
None
Description
This was found on MariaDB 10.6.3. There are some inconsistencies in the below expressions using <=>, which I'd expect to all equal 1.
mariadb10.6.3> SELECT CAST(-1 AS DATETIME),
|
CAST(NULL AS DATETIME),
|
CAST(-1 AS DATE), CAST(NULL AS DATE),
|
CAST(-1 AS DATETIME) <=> CAST(NULL AS DATETIME),
|
CAST(-1 AS DATETIME) <=> NULL,
|
CAST(NULL AS DATETIME) <=> NULL,
|
CAST(-1 AS DATE) <=> CAST(NULL AS DATE),
|
CAST(-1 AS DATE) <=> NULL,
|
CAST(NULL AS DATE) <=> NULL, NULL <=> NULL\G
|
*************************** 1. row ***************************
|
CAST(-1 AS DATETIME): NULL
|
CAST(NULL AS DATETIME): NULL
|
CAST(-1 AS DATE): NULL
|
CAST(NULL AS DATE): NULL
|
CAST(-1 AS DATETIME) <=> CAST(NULL AS DATETIME): 0
|
CAST(-1 AS DATETIME) <=> NULL: 0
|
CAST(NULL AS DATETIME) <=> NULL: 1
|
CAST(-1 AS DATE) <=> CAST(NULL AS DATE): 0
|
CAST(-1 AS DATE) <=> NULL: 0
|
CAST(NULL AS DATE) <=> NULL: 1
|
NULL <=> NULL: 1
|
1 row in set, 6 warnings (0.00 sec)
|