[MDEV-17634] Regression: TIME(0)=TIME('z') returns NULL vs 1 Created: 2018-11-07  Updated: 2018-11-07  Resolved: 2018-11-07

Status: Closed
Project: MariaDB Server
Component/s: Temporal Types
Affects Version/s: 10.4
Fix Version/s: 10.4.0

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17563 Different results using table or view... Closed
relates to MDEV-17625 Different warnings when comparing a g... Closed
relates to MDEV-17632 Inconsistent behavior of conversion t... Open

 Description   

10.4

SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t;


+------+------+------+
 
| ts   | d    | t    |
 
+------+------+------+
 
|    1 |    1 | NULL |
 
+------+------+------+

10.3

SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t;


+------+------+------+
 
| ts   | d    | t    |
 
+------+------+------+
 
|    1 |    1 |    1 |
 
+------+------+------+


Generated at Thu Feb 08 08:37:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.