[#MCOL-3598] ORDER BY over negative SEC_TO_TIME() results produce an incorrect order

Failed tests in the 001 suite in 1.4 (MCOL-3594) [MCOL-3598] ORDER BY over negative SEC_TO_TIME() results produce an incorrect order Created: 2019-11-08 Updated: 2020-02-20 Resolved: 2020-02-20
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	None
Affects Version/s:	None
Fix Version/s:	1.4.3

Type:

Sub-Task

Priority:

Minor

Reporter:

Roman

Assignee:

Daniel Lee (Inactive)

Resolution:

Fixed

Votes:

Labels:

None

Sprint:

2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7

Description

The query:
select cidx, CSMALLINT,SEC_TO_TIME(CSMALLINT) from datatypetestm order by SEC_TO_TIME(CSMALLINT), cidx;
taken from working_tpch1/qa_fe_postProcessedFunctions/SEC_TO_TIME.NS.sql is the way to reproduce the issue.

Comments

Comment by Gagan Goel (Inactive) [ 2020-01-31 ]

This was fixed in PR 969.

Comment by Daniel Lee (Inactive) [ 2020-02-20 ]

Build verified: 1.4.3-1 Azure build (20200220)

Verified test case in the ticket.

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

[MCOL-3598] ORDER BY over negative SEC_TO_TIME() results produce an incorrect order Created: 2019-11-08 Updated: 2020-02-20 Resolved: 2020-02-20