Bug #26536 func_time failure on vm-win2003-64-b, occurs every time

Submitted: 21 Feb 2007 17:50 Modified: 13 Mar 2007 19:19
Reporter: Mads Martin Joergensen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.0 OS:Windows (windows)
Assigned to: Magnus BlÄudd CPU Architecture:Any

[21 Feb 2007 17:50] Mads Martin Joergensen
Description:
*** r/func_time.result	Tue Feb 20 20:01:56 2007
--- r/func_time.reject	Tue Feb 20 20:16:32 2007
***************
*** 561,567 ****
  1970-01-01 03:00:00
  select unix_timestamp(from_unixtime(2147483647));
  unix_timestamp(from_unixtime(2147483647))
! 2147483647
  select unix_timestamp(from_unixtime(2147483648));
  unix_timestamp(from_unixtime(2147483648))
  NULL
--- 561,567 ----
  1970-01-01 03:00:00
  select unix_timestamp(from_unixtime(2147483647));
  unix_timestamp(from_unixtime(2147483647))
! 0
  select unix_timestamp(from_unixtime(2147483648));
  unix_timestamp(from_unixtime(2147483648))
  NULL

How to repeat:
Pushbuild repeats it every time
[23 Feb 2007 16:33] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/20468

ChangeSet@1.2440, 2007-02-23 17:33:11+01:00, msvensson@pilot.blaudden +2 -0
  Bug#26536 func_time failure on vm-win2003-64-b, occurs every time
   - Avoid overflow in sec_since_epoch by shifting the time
     back 2 days for times close to the maximum range of my_time_t
   - Improve comment about why we need my_time_t
   - Patch will also fix timezone2.test
[23 Feb 2007 16:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/20473

ChangeSet@1.2459, 2007-02-23 17:59:07+01:00, msvensson@pilot.blaudden +1 -0
  Bug#26536 func_time failure on vm-win2003-64-b, occurs every time
   - Fixes for 5.1
   - Always use long for my_time_t
[27 Feb 2007 15:58] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/20661

ChangeSet@1.2471, 2007-02-27 16:58:40+01:00, msvensson@pilot.blaudden +1 -0
  Bug#26536 func_time failure on vm-win2003-64-b, occurs every time
   - my_time_t is defined as long which means it will not always be the
  same size as time_t. See explanation in include/my_time.h
[8 Mar 2007 21:32] Timothy Smith
pushed to 5.0.38, 5.1.17
[13 Mar 2007 19:19] Paul DuBois
Noted in 5.0.38, 5.1.17 changelogs.

On 64-bit Windows, large timestamp values could be
handled incorrectly.
[22 Mar 2007 8:09] Dmitry Lenev
Bug #26924 "Test 'timezone2' fails on Windows x64" was marked as duplicate of this bug.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.068 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.