[MCOL-1647] Fix regressions caused by TIME/DATETIME changes Created: 2018-08-13  Updated: 2018-09-28  Resolved: 2018-09-28

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

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-16, 2018-17, 2018-18

 Description   

The following tests fail:

working_tpch1/qa_fe_cnxFunctions/addtime.sql - test doesn't support microseconds and add/sumtime negative error
working_tpch1/qa_fe_cnxFunctions/bug3333.sql - I think there are some behaviour issues here
working_tpch1/qa_fe_cnxFunctions/bug3334_ceil.sql - first query fails
working_tpch1/qa_fe_cnxFunctions/bug3334_overflow_error.negative.sql - no errors?!
working_tpch1/qa_fe_cnxFunctions/bug3584.sql - this might be correct behaviour now
working_tpch1/qa_fe_cnxFunctions/bug3585.sql - new behaviour is correct
working_tpch1/qa_fe_cnxFunctions/bug3792.negative.sql - subtime failure
working_tpch1/qa_fe_cnxFunctions/from_unixtime.sql - this might be due to my TZ
working_tpch1/qa_fe_cnxFunctions/STR_TO_DATE.sql - missing TIME datatype support
working_tpch1/qa_fe_cnxFunctions/subtime.sql - subtime failure
working_tpch1/qa_fe_cnxFunctions/TIMEDIFF.DM.sql - I think new behaviour is correct
working_tpch1/qa_fe_cnxFunctions/TIME.DS.sql - Need to check this one
working_tpch1/qa_fe_cnxFunctions/unix_timestamp.sql - Don't know
working_tpch1/qa_fe_postProcessedFunctions/SUBTIME.DM.sql - subtime error
working_tpch1/qa_fe_postProcessedFunctions/TIMEDIFF.DM.sql - I think new behaviour is correct
working_tpch1/aggregation/bitop.sql - appears to use internal datetime ints rather than external ones

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-08-17 ]

Pull request in engine and regression suite.

Comment by Daniel Lee (Inactive) [ 2018-09-28 ]

Build verified: Github source
/root/columnstore/mariadb-columnstore-server
commit 7db44a78066cb55b7e2ffded80e2673d16940cee
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Mon Sep 10 13:39:42 2018 +0100
Revert "MDEV-11036 Add link wsrep_sst_rsync_wan -> wsrep_sst_rsync"
This reverts commit e8a2a751212a04e835b2b03408132ecbbab52410.

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 3326be00de5f53ec365910f07a7fd882ba193d4d
Merge: ebbeb30 5cab6c4
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Tue Sep 18 13:57:17 2018 +0100
Merge pull request #565 from drrtuy/MCOL-1601
MCOL-1601 GROUP BY now supports subqueries in HAVING.

Executed run_working_tpch1.sh and all tests passed in the working_tpch1.log

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