| Bug #10040 | 'func_sapdb' fails on 64bit build hosts | ||
|---|---|---|---|
| Submitted: | 20 Apr 2005 17:38 | Modified: | 25 Apr 2005 8:00 |
| Reporter: | Matt Wagner | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.5 test build | OS: | Many 64bit |
| Assigned to: | Dmitry Lenev | CPU Architecture: | Any |
[22 Apr 2005 19:31]
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/internals/24239
[25 Apr 2005 7:24]
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/internals/24270
[25 Apr 2005 8:00]
Dmitry Lenev
Patch was reviewed by Ingo and pushed into 5.0.5 tree.
[25 Apr 2005 8:01]
Dmitry Lenev
(Fix was also applied to 4.1 tree)
Description: Test 'func_sapdb' fails on almost all of our 64bit build hosts. Here is the reject: 11702: Below are the diffs between actual and expected results: 11703: ------------------------------------------------------- 11704: *** r/func_sapdb.result Wed Apr 20 01:07:49 2005 11705: --- r/func_sapdb.reject Wed Apr 20 04:58:27 2005 11706: *************** 11707: *** 83,89 **** 11708: NULL 11709: select addtime("1997-12-31 23:59:59.999999", "1 1:1:1.000002"); 11710: addtime("1997-12-31 23:59:59.999999", "1 1:1:1.000002") 11711: ! 1998-01-02 01:01:01.000001 11712: select subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002"); 11713: subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002") 11714: 1997-12-30 22:58:57.999999 11715: --- 83,89 ---- 11716: NULL 11717: select addtime("1997-12-31 23:59:59.999999", "1 1:1:1.000002"); 11718: addtime("1997-12-31 23:59:59.999999", "1 1:1:1.000002") 11719: ! NULL 11720: select subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002"); 11721: subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002") 11722: 1997-12-30 22:58:57.999999 11723: *************** 11724: *** 188,194 **** 11725: f9 time YES NULL 11726: select * from t1; 11727: f1 f2 f3 f4 f5 f6 f7 f8 f9 11728: ! 1997-01-01 1998-01-02 01:01:00 49:01:01 46:58:57 -24:00:00 10:11:12 2001-12-01 01:01:01 1997-12-31 23:59:59 11729: create table test(t1 datetime, t2 time, t3 time, t4 datetime); 11730: insert into test values 11731: ('2001-01-01 01:01:01', '01:01:01', null, '2001-02-01 01:01:01'), 11732: --- 188,194 ---- 11733: f9 time YES NULL 11734: select * from t1; 11735: f1 f2 f3 f4 f5 f6 f7 f8 f9 11736: ! 1997-01-01 NULL 49:01:01 46:58:57 -24:00:00 10:11:12 2001-12-01 01:01:01 1997-12-31 23:59:59 11737: create table test(t1 datetime, t2 time, t3 time, t4 datetime); 11738: insert into test values 11739: ('2001-01-01 01:01:01', '01:01:01', null, '2001-02-01 01:01:01'), 11740: ------------------------------------------------------- How to repeat: Run test suite on affected build host.