Failed tests in the 001 suite in 1.4 (MCOL-3594)

[MCOL-3597] TIMEDIFF() returns NULL instead of expected value Created: 2019-11-08  Updated: 2019-11-20  Resolved: 2019-11-20

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

Type: Sub-Task Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

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

 Description   

Queries from both working_tpch1/qa_fe_cnxFunctions/TIMEDIFF.DM.sql and
working_tpch1/qa_fe_postProcessedFunctions/TIMEDIFF.DM.sql are exampes to reproduce the issue.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-11-08 ]

This is likely due to MCOL-3474, the test may need updating.

Comment by Daniel Lee (Inactive) [ 2019-11-20 ]

Build verified: 1.4.1-1

Server
/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit 6cedb671e99038f1a10e0d8504f835aaabed9780
Author: Marko Mäkelä <marko.makela@mariadb.com>

Engine
commit 0f86a3ab14a530183c4fc30b752f8c54c89f13d2
Merge: 7c6a086 2275f4f
Author: benthompson15 <ben.thompson.015@gmail.com>
Date: Tue Nov 19 23:07:31 2019 +0100

MariaDB [tpch1]> select cidx, CDATETIME, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm;
-----------------------------------------------------------------

cidx CDATETIME TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')

-----------------------------------------------------------------

1 1997-01-01 00:00:00 -838:59:59
2 1997-01-01 00:00:01 -838:59:59
3 1997-01-02 00:00:01 -838:59:59
4 1997-01-03 00:00:02 -838:59:59
5 1997-01-04 00:00:03 -838:59:59
6 2009-12-31 23:59:56 838:59:59
7 2009-12-31 23:59:57 838:59:59
8 2009-12-31 23:59:58 838:59:59
9 2009-12-31 23:59:59 838:59:59
10 2009-12-31 23:59:59 838:59:59
11 2009-12-31 23:59:59 838:59:59

-----------------------------------------------------------------
11 rows in set (0.011 sec)

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