[MDEV-5133] Test suite tests *_func_view fail in time zones East of UTC+3 Created: 2013-10-14  Updated: 2013-10-23  Resolved: 2013-10-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.33a
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Duncan Roe Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None
Environment:

Slackware Linux 14.0 + kernel 3.10.4 32-bit i386

Attachments: File 14_hr_func_view.diff.gz     File func_view.diff.gz    

 Description   

Tests innodb_func_view, memory_func_view and myisam_func_view all fail on the timestamp of 1970-01-01 03:00:01. This timestamp is expressed in local time but stored in UTC time. In countries like Australia (UTC+10:00), this tmestamp falls before the Epoch and so is rejected.
The attached patch changes the timestamp to 1970-01-01 13:00:01, which should pass almost everywhere (the International Date Line has a deviation in the South Pacific which could enable UTC+14:00 but any such countries are too small to show up on my A5 world map).

 Comments   
Comment by Oleksandr Byelkin [ 2013-10-21 ]

Why not 14:00 to pass everywhere?

Comment by Duncan Roe [ 2013-10-22 ]

OK you got it

Comment by Oleksandr Byelkin [ 2013-10-22 ]

Thank you a lot! (I was going to do it just wanted to know if there is something special about 13 hour which I could not see, so you made my work way more simple)

Generated at Thu Feb 08 07:01:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.