[MDEV-17244] MAKETIME(900,0,0.111) returns a wrong result - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 5.5.62, 10.0.37, 10.2.18, 10.3.11, 10.4.0, 10.1.37
Component/s: Temporal Types
Labels:
None

Description

SELECT MAKETIME(900,0,0.111);

+-----------------------+

| MAKETIME(900,0,0.111) |

+-----------------------+

| 838:59:59.000         |

+-----------------------+

This is wrong. The expected result is 838:59:59.999, i.e. the maximum possible value with 3 fractional digits, according to the last argument precision.

Attachments

Issue Links

blocks

MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-09-19 15:00

Updated:: 2018-09-20 12:53

Resolved:: 2018-09-20 12:53

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.