[MCOL-359] test001 from_unixtime and unix_timestamp tests are tz dependent Created: 2016-10-13  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Andrew Hutchings (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Epic Link: Time, Timestamp and Timezone
Sprint: 2016-20, 2016-21, 2016-22, 2016-23

 Description   

The tests are timezone dependant at the moment, so only pass on machines in the BST timezone. I need to make them timezone independent.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2016-10-13 ]

Pull request for this at: https://github.com/mariadb-corporation/mariadb-columnstore-regression-test/pull/3

Using date/time diffs from the MariaDB server to make the tests timezone independent.

Comment by David Hall (Inactive) [ 2016-11-28 ]

Reverted bug3784.sql
https://github.com/mariadb-corporation/mariadb-columnstore-regression-test/pull/9

Comment by David Thompson (Inactive) [ 2017-06-05 ]

We should find a way to address this in the test framework as it would remove a point of necessary knowledge to successfully run the regression test without prior knowledge which will help new team members and community contributors.

Comment by David Hall (Inactive) [ 2020-11-09 ]

When we have a way to keep TZ with a table, perhaps we can use that for this issue.

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

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