[MDEV-22854] Garbage returned with SELECT CASE..DEFAULT(timestamp_field_with_now_as_default) Created: 2020-06-10  Updated: 2020-06-10  Resolved: 2020-06-10

Status: Closed
Project: MariaDB Server
Component/s: Data types, Temporal Types
Fix Version/s: 10.5.4, 10.4.14

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

Issue Links:
Relates
relates to MDEV-21637 Assertion `!is_valid_datetime() || fr... Closed

 Description    

CREATE OR REPLACE TABLE t1 (a TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP);
 
INSERT INTO t1 VALUES ('2019-02-23 11:31:04'),('2023-02-09 00:00:00');
 
SELECT CASE WHEN a THEN DEFAULT(a) END FROM t1;


+---------------------------------+
 
| CASE WHEN a THEN DEFAULT(a) END |
 
+---------------------------------+
 
| 2058-01-24 15:14:45.999         |
 
| 2058-01-24 15:14:45.999         |
 
+---------------------------------+


Generated at Thu Feb 08 09:17:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.