Unexpected increased timestamp resolution with UNION
Bug #736358 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Sergei Golubchik |
Bug 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
Related branches
lp:~maria-captains/maria/5.1-micro
(Merged)
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Sergei (sergii) |
Changed in maria: | |
importance: | Undecided → Medium |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Same applies for DISTINCT