[MDEV-17330] Wrong result for 0 + LEAST(TIME'-10:00:00',TIME'10:00:00') - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.4.0
Component/s: Data types, Temporal Types
Labels:
None

Description

SELECT 0 + LEAST(TIME'-10:00:00',TIME'10:00:00') AS c;

+--------+

| c      |

+--------+

| 100000 |

+--------+

Looks wrong. The expected result is -100000.

Attachments

Issue Links

blocks

MDEV-4912 Data type plugin API version 1

Closed

relates to

MDEV-17318 CAST(LEAST(zero_date,non_zero_date) AS numeric_data_type) returns a wrong result

Closed

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2018-09-30 13:14

Alexander Barkov made changes - 2018-09-30 13:14

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-17318~~ [ ~~MDEV-17318~~ ]

Alexander Barkov made changes - 2018-09-30 13:15

Link

This issue blocks ~~MDEV-4912~~ [ ~~MDEV-4912~~ ]

Alexander Barkov made changes - 2018-09-30 13:25

issue.field.resolutiondate

2018-09-30 13:25:01.0

2018-09-30 13:25:01.929

Alexander Barkov made changes - 2018-09-30 13:25

Fix Version/s		10.4.0 [ 23115 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:48

Workflow

MariaDB v3 [ 89826 ]

MariaDB v4 [ 154993 ]

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-09-30 13:14

Updated:: 2018-09-30 13:25

Resolved:: 2018-09-30 13:25

Git Integration

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

MariaDB Server