[MCOL-3817] CLONE - ORDER BY over negative SEC_TO_TIME() results produce an incorrect order Created: 2020-02-20  Updated: 2020-03-16  Resolved: 2020-03-16

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

Type: Bug Priority: Minor
Reporter: Patrick LeBlanc (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2020-1, 2020-2, 2020-3, 2020-4

 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 Daniel Lee (Inactive) [ 2020-03-16 ]

Build verified: 1.2.6-1 BB

engine commit:
d4173ef

Verified that ColumnStore returned the same results as InnoDB

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