[MCOL-3657] unix_timestamp() drops microseconds Created: 2019-12-09  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Patrick Safarov Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None


 Description    

create table test (ts datetime(3)) ENGINE = Columnstore;
 
insert into test (ts) VALUES ('2019-12-06 14:53:04.350');
 
select unix_timestamp(ts), extract(MICROSECOND FROM ts) from test;

Expected result: 1575643984.350,350000
Actual result: 1575643984.000,350000

 Comments   
Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was opened prior to convergence with the server. It may have been rendered obsolete. If this issue still exists in a modern version, please open a new request.

Generated at Thu Feb 08 02:44:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.