[MDEV-30377] Aggregate functions lose microseconds for timestamps below 1 Created: 2023-01-10  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Temporal Types
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None


 Description    

CREATE TABLE t (t TIMESTAMP(1));
 
INSERT INTO t VALUES (FROM_UNIXTIME(0.1));
 
 
 
SELECT t FROM t;
 
SELECT MIN(t), MAX(t) FROM t;
 
 
 
# Cleanup
 
DROP TABLE t;

10.4 f97f6955

 
SELECT t FROM t;
 
t
 
1970-01-01 02:00:00.1
 
SELECT MIN(t), MAX(t) FROM t;
 
MIN(t)	MAX(t)
 
0000-00-00 00:00:00.0	0000-00-00 00:00:00.0

Started happening after this commit in 10.4.1:

commit 34eb98387f8f46a80fb053081dbe20d415f23b39
 
Author: Alexander Barkov <bar@mariadb.com>
 
Date:   Sat Dec 8 19:39:23 2018 +0400
 
 
 
    MDEV-13995 MAX(timestamp) returns a wrong result near DST change


Generated at Thu Feb 08 10:15:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.