Bug #19409 Test 'func_timestamp' fails on Windows x64
Submitted: 27 Apr 2006 19:54 Modified: 3 Jul 2006 19:12
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.21 OS:Windows (Windows 2003 x64)
Assigned to: Tatiana Azundris Nuernberg CPU Architecture:Any

[27 Apr 2006 19:54] Kent Boortz 
Description:
Test 'func_timestamp' fails with

 *** r/func_timestamp.result    Thu Apr 27 17:59:31 2006
 --- r/func_timestamp.reject    Thu Apr 27 19:06:36 2006
 ***************
 *** 6,11 ****
   UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit)) AS Unix
   FROM t1;
   Date Unix
 ! 1998-9-16 09:26:00   905927160
 ! 1998-9-16 09:26:00   905927160
   drop table t1;
 --- 6,11 ----
   UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit)) AS Unix
   FROM t1;
   Date Unix
 ! 1998-9-16 09:26:00   905923560
 ! 1998-9-16 09:26:00   905923560
   drop table t1;

How to repeat:
Run the test case on Windows x64
[27 Apr 2006 20:03] Kent Boortz 
If any luck this is only a problem with mysql-test-run.pl,
the 'type_timestamp' has many problems as well

 *** r/type_timestamp.result    Thu Apr 27 17:59:32 2006
 --- r/type_timestamp.reject    Thu Apr 27 19:43:25 2006
 ***************
 *** 189,195 ****
   insert into t1 (t1,t3) values (default, default);
   select * from t1;
   t1   t2      t3
 ! 2003-01-01 00:00:00  2001-09-09 04:46:41     0000-00-00 00:00:00
   2003-01-01 00:00:00  NULL    0000-00-00 00:00:00
   show create table t1;
   Table        Create Table
 --- 189,195 ----
   insert into t1 (t1,t3) values (default, default);
   select * from t1;
   t1   t2      t3
 ! 2003-01-01 00:00:00  2001-09-09 05:46:41     0000-00-00 00:00:00
   2003-01-01 00:00:00  NULL    0000-00-00 00:00:00
   show create table t1;
   Table        Create Table
 ***************
 *** 213,220 ****
   insert into t1 (t1,t3) values (default, default);
   select * from t1;
   t1   t2      t3
 ! 2001-09-09 04:46:42  2001-09-09 04:46:43     0000-00-00 00:00:00
 ! 2001-09-09 04:46:43  NULL    0000-00-00 00:00:00
   show create table t1;
   Table        Create Table
   t1   CREATE TABLE `t1` (
 --- 213,220 ----
   insert into t1 (t1,t3) values (default, default);
   select * from t1;
   t1   t2      t3
 ! 2001-09-09 05:46:42  2001-09-09 05:46:43     0000-00-00 00:00:00
 ! 2001-09-09 05:46:43  NULL    0000-00-00 00:00:00
   show create table t1;
   Table        Create Table
   t1   CREATE TABLE `t1` (
 ***************
 *** 240,246 ****
   insert into t1 (t1) values (default);
   select * from t1;
   t1   t2
 ! 2001-09-09 04:46:45  2001-09-09 04:46:45
   2003-01-01 00:00:00  NULL
   show create table t1;
   Table        Create Table
 --- 240,246 ----
   insert into t1 (t1) values (default);
   select * from t1;
   t1   t2
 ! 2001-09-09 05:46:45  2001-09-09 05:46:45
   2003-01-01 00:00:00  NULL
   show create table t1;
   Table        Create Table
 ***************
 *** 258,272 ****
   insert into t1 values ();
   select * from t1;
   t1   t2
 ! 2001-09-09 04:46:46  NULL
   SET TIMESTAMP=1000000007;
   update t1 set t2=now();
   SET TIMESTAMP=1000000007;
   insert into t1 (t1) values (default);
   select * from t1;
   t1   t2
 ! 2001-09-09 04:46:47  2001-09-09 04:46:47
 ! 2001-09-09 04:46:47  NULL
   show create table t1;
   Table        Create Table
   t1   CREATE TABLE `t1` (
 --- 258,272 ----
   insert into t1 values ();
   select * from t1;
   t1   t2
 ! 2001-09-09 05:46:46  NULL
   SET TIMESTAMP=1000000007;
   update t1 set t2=now();
   SET TIMESTAMP=1000000007;
   insert into t1 (t1) values (default);
   select * from t1;
   t1   t2
 ! 2001-09-09 05:46:47  2001-09-09 05:46:47
 ! 2001-09-09 05:46:47  NULL
   show create table t1;
   Table        Create Table
   t1   CREATE TABLE `t1` (
 ***************
 *** 283,297 ****
   insert into t1 values ();
   select * from t1;
   t1   t2      t3
 ! 2001-09-09 04:46:47  NULL    0000-00-00 00:00:00
   SET TIMESTAMP=1000000008;
   update t1 set t2=now();
   SET TIMESTAMP=1000000008;
   insert into t1 (t1,t3) values (default, default);
   select * from t1;
   t1   t2      t3
 ! 2001-09-09 04:46:48  2001-09-09 04:46:48     0000-00-00 00:00:00
 ! 2001-09-09 04:46:48  NULL    0000-00-00 00:00:00
   show create table t1;
   Table        Create Table
   t1   CREATE TABLE `t1` (
 --- 283,297 ----
   insert into t1 values ();
   select * from t1;
   t1   t2      t3
 ! 2001-09-09 05:46:47  NULL    0000-00-00 00:00:00
   SET TIMESTAMP=1000000008;
   update t1 set t2=now();
   SET TIMESTAMP=1000000008;
   insert into t1 (t1,t3) values (default, default);
   select * from t1;
   t1   t2      t3
 ! 2001-09-09 05:46:48  2001-09-09 05:46:48     0000-00-00 00:00:00
 ! 2001-09-09 05:46:48  NULL    0000-00-00 00:00:00
   show create table t1;
   Table        Create Table
   t1   CREATE TABLE `t1` (
 .
 .
 .
[22 Jun 2006 22:20] Tatiana Azundris Nuernberg 
pushed to 5.0.23 in 5.0-maint, http://lists.mysql.com/commits/8095
[26 Jun 2006 18:14] Tatiana Azundris Nuernberg 
fixed in 5.0.23
[3 Jul 2006 19:12] Paul DuBois 
Changes to test case only.
No changelog entry needed.