[MDEV-3480] LP:736358 - Unexpected increased timestamp resolution with UNION Created: 2011-03-16  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Philip Stoev (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug736358.xml    

 Description   

When executed in a UNION context, datetime operations return a millisecond precision, even though no fractional seconds were used anywhere in the expression.

Test case:

CREATE TABLE t1 (f1 timestamp(6));
INSERT INTO t1 VALUES ('2002-07-15 21:00:00');

SELECT TIME(f1) FROM t1;

returns:

21:00:00

( SELECT TIME(f1) FROM t1) UNION ALL ( SELECT TIME(f1) FROM t1);

returns
21:00:00.000000
21:00:00.000000

 Comments   
Comment by Philip Stoev (Inactive) [ 2011-03-16 ]

Re: Unexpected increased timestamp resolution with UNION
Same applies for DISTINCT

Comment by Rasmus Johansson (Inactive) [ 2011-10-28 ]

Launchpad bug id: 736358

Generated at Thu Feb 08 06:48:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.