[MCOL-345] Saturated time() func handling is different to MariaDB Created: 2016-10-04  Updated: 2018-09-28  Resolved: 2018-09-28

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

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

Issue Links:
Relates
relates to MCOL-344 Set test001 working_tpch1 to Tr mode Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

The results of bug3333.sql should be compared to MariaDB's to fix the logic.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-09-26 ]

Almost certain this is now correct.

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.

Confirmed with developer that this ticket is for the time() function in the bug3333.sql script only. Verified that that query 17 that has the time() matches with MariaDB 10.3.9.

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