Logging: ./mysql-test-run --force
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb     
Installing Master Databases 1
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data1 --skip-innodb --skip-ndbcluster --skip-bdb     
Installing Slave Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb     
Manager disabled, skipping manager start.
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
alias                          [ pass ]   
alter_table                    [ pass ]   
analyse                        [ pass ]   
analyze                        [ pass ]   
ansi                           [ pass ]   
archive                        [ skipped ]
auto_increment                 [ pass ]   
backup                         [ pass ]   
bdb-alter-table-1              [ skipped ]
bdb-alter-table-2              [ skipped ]
bdb-crash                      [ skipped ]
bdb-deadlock                   [ skipped ]
bdb                            [ skipped ]
bdb_cache                      [ skipped ]
bench_count_distinct           [ pass ]   
bigint                         [ pass ]   
binary                         [ pass ]   
blackhole                      [ skipped ]
bool                           [ pass ]   
bulk_replace                   [ pass ]   
case                           [ pass ]   
cast                           [ pass ]   
check                          [ pass ]   
comments                       [ pass ]   
compare                        [ pass ]   
connect                        [ pass ]   
consistent_snapshot            [ pass ]   
constraints                    [ pass ]   
count_distinct                 [ pass ]   
count_distinct2                [ pass ]   
count_distinct3                [ pass ]   
create                         [ pass ]   
create_select_tmp              [ pass ]   
csv                            [ skipped ]
ctype_big5                     [ pass ]   
ctype_collate                  [ pass ]   
ctype_cp1250_ch                [ pass ]   
ctype_cp1251                   [ pass ]   
ctype_cp932                    [ pass ]   
ctype_cp932_binlog             [ pass ]   
ctype_create                   [ pass ]   
ctype_euckr                    [ pass ]   
ctype_gb2312                   [ pass ]   
ctype_gbk                      [ pass ]   
ctype_latin1                   [ pass ]   
ctype_latin1_de                [ pass ]   
ctype_latin2                   [ pass ]   
ctype_latin2_ch                [ pass ]   
ctype_many                     [ pass ]   
ctype_mb                       [ pass ]   
ctype_recoding                 [ pass ]   
ctype_sjis                     [ pass ]   
ctype_tis620                   [ pass ]   
ctype_uca                      [ pass ]   
ctype_ucs                      [ pass ]   
ctype_ucs2_def                 [ pass ]   
ctype_ucs_binlog               [ pass ]   
ctype_ujis                     [ pass ]   
ctype_utf8                     [ pass ]   
date_formats                   [ pass ]   
delayed                        [ pass ]   
delete                         [ pass ]   
derived                        [ pass ]   
dirty_close                    [ pass ]   
distinct                       [ pass ]   
drop                           [ pass ]   
drop_temp_table                [ pass ]   
empty_table                    [ pass ]   
endspace                       [ pass ]   
errors                         [ pass ]   
exampledb                      [ skipped ]
explain                        [ pass ]   
flush                          [ pass ]   
flush_block_commit             [ pass ]   
flush_table                    [ pass ]   
foreign_key                    [ pass ]   
fulltext                       [ pass ]   
fulltext2                      [ pass ]   
fulltext_cache                 [ pass ]   
fulltext_distinct              [ pass ]   
fulltext_left_join             [ pass ]   
fulltext_multi                 [ pass ]   
fulltext_order_by              [ pass ]   
fulltext_update                [ pass ]   
fulltext_var                   [ pass ]   
func_compress                  [ pass ]   
func_concat                    [ pass ]   
func_crypt                     [ pass ]   
func_date_add                  [ pass ]   
func_default                   [ pass ]   
func_des_encrypt               [ skipped ]
func_encrypt                   [ skipped ]
func_encrypt_nossl             [ pass ]   
func_equal                     [ pass ]   
func_gconcat                   [ pass ]   
func_group                     [ pass ]   
func_if                        [ pass ]   
func_in                        [ pass ]   
func_isnull                    [ pass ]   
func_like                      [ pass ]   
func_math                      [ pass ]   
func_misc                      [ pass ]   
func_op                        [ pass ]   
func_regexp                    [ pass ]   
func_sapdb                     [ pass ]   
func_set                       [ pass ]   
func_str                       [ pass ]   
func_system                    [ pass ]   
func_test                      [ pass ]   
func_time                      [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/func_time.result	Sonntag, 31. Dezember 2006 11:30:55
--- r/func_time.reject	Sonntag, 31. Dezember 2006 12:03:39
***************
*** 473,479 ****
  drop table t1,t2,t3;
  select @a:=FROM_UNIXTIME(1);
  @a:=FROM_UNIXTIME(1)
! 1970-01-01 03:00:01
  select unix_timestamp(@a);
  unix_timestamp(@a)
  1
--- 473,479 ----
  drop table t1,t2,t3;
  select @a:=FROM_UNIXTIME(1);
  @a:=FROM_UNIXTIME(1)
! 1969-12-31 21:00:01
  select unix_timestamp(@a);
  unix_timestamp(@a)
  1
***************
*** 488,494 ****
  NULL
  select from_unixtime(0);
  from_unixtime(0)
! 1970-01-01 03:00:00
  CREATE TABLE t1 (datetime datetime, timestamp timestamp, date date, time time);
  INSERT INTO t1 values ("2001-01-02 03:04:05", "2002-01-02 03:04:05", "2003-01-02", "06:07:08");
  SELECT * from t1;
--- 488,494 ----
  NULL
  select from_unixtime(0);
  from_unixtime(0)
! 1969-12-31 21:00:00
  CREATE TABLE t1 (datetime datetime, timestamp timestamp, date date, time time);
  INSERT INTO t1 values ("2001-01-02 03:04:05", "2002-01-02 03:04:05", "2003-01-02", "06:07:08");
  SELECT * from t1;
***************
*** 587,596 ****
  19971231.0
  select strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0;
  strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0
! 1
  select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%T"), utc_time())=0;
  strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%T"), utc_time())=0
! 1
  select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0;
  strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0
  1
--- 587,596 ----
  19971231.0
  select strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0;
  strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0
! 0
  select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%T"), utc_time())=0;
  strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%T"), utc_time())=0
! 0
  select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0;
  strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0
  1
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

func_timestamp                 [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/func_timestamp.result	Sonntag, 31. Dezember 2006 11:30:55
--- r/func_timestamp.reject	Sonntag, 31. Dezember 2006 12:04:21
***************
*** 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	905948760
! 1998-9-16 09:26:00	905948760
  drop table t1;
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

gcc296                         [ pass ]   
gis-rtree                      [ pass ]   
gis                            [ pass ]   
grant                          [ pass ]   
grant2                         [ pass ]   
grant_cache                    [ pass ]   
group_by                       [ pass ]   
handler                        [ pass ]   
having                         [ pass ]   
heap                           [ pass ]   
heap_auto_increment            [ pass ]   
heap_btree                     [ pass ]   
heap_hash                      [ pass ]   
help                           [ pass ]   
init_connect                   [ pass ]   
init_file                      [ pass ]   
innodb-deadlock                [ pass ]   
innodb-lock                    [ pass ]   
innodb-replace                 [ pass ]   
innodb                         [ pass ]   
innodb_cache                   [ pass ]   
innodb_handler                 [ pass ]   
innodb_mysql                   [ pass ]   
insert                         [ pass ]   
insert_select-binlog           [ pass ]   
insert_select                  [ pass ]   
insert_update                  [ pass ]   
isam                           [ skipped ]
join                           [ pass ]   
join_crash                     [ pass ]   
join_outer                     [ pass ]   
key                            [ pass ]   
key_cache                      [ pass ]   
key_diff                       [ pass ]   
key_primary                    [ pass ]   
keywords                       [ pass ]   
kill                           [ pass ]   
limit                          [ pass ]   
loaddata                       [ pass ]   
lock                           [ pass ]   
lock_multi                     [ pass ]   
lock_tables_lost_commit        [ pass ]   
lowercase_fs_off               [ pass ]   
lowercase_table                [ pass ]   
lowercase_table2               [ skipped ]
lowercase_table3               [ skipped ]
lowercase_table_grant          [ pass ]   
lowercase_table_qcache         [ pass ]   
merge                          [ pass ]   
metadata                       [ pass ]   
mix_innodb_myisam_binlog       [ pass ]   
multi_statement                [ pass ]   
multi_update                   [ pass ]   
myisam-blob                    [ pass ]   
myisam                         [ pass ]   
mysql_client                   [ pass ]   
mysql_client_test              [ pass ]   
mysql_protocols                [ pass ]   
mysqlbinlog                    [ pass ]   
mysqlbinlog2                   [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysqlbinlog2.result	Sonntag, 31. Dezember 2006 11:30:55
--- r/mysqlbinlog2.reject	Sonntag, 31. Dezember 2006 12:15:15
***************
*** 17,38 ****
  --- Local --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- offset --
--- 17,38 ----
  --- Local --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- offset --
***************
*** 39,81 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
  
--- 39,81 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
  
***************
*** 83,132 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  
  --- Local with 2 binlogs on command line --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- offset --
--- 83,132 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  
  --- Local with 2 binlogs on command line --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- offset --
***************
*** 133,189 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  
--- 133,189 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  
***************
*** 191,240 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  
  --- Remote --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- offset --
--- 191,240 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  
  --- Remote --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- offset --
***************
*** 241,283 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
  
--- 241,283 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
  
***************
*** 285,334 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  
  --- Remote with 2 binlogs on command line --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- offset --
--- 285,334 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  
  --- Remote with 2 binlogs on command line --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- offset --
***************
*** 335,391 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  
--- 335,391 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=1;
  use test;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- start-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- stop-position --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  
***************
*** 393,445 ****
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  
  --- to-last-log --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579609942;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579609942;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579609944;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579609946;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
! SET TIMESTAMP=1579609943;
  insert into t1 values(null, "f");
  
  --- end of test --
--- 393,445 ----
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  SET INSERT_ID=3;
  use test;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
  use test;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- stop-datetime --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  
  --- to-last-log --
  /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  use test;
! SET TIMESTAMP=1579631542;
  create table t1 (a int auto_increment not null primary key, b char(3));
  SET INSERT_ID=1;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "a");
  SET INSERT_ID=2;
! SET TIMESTAMP=1579631542;
  insert into t1 values(null, "b");
  SET INSERT_ID=3;
! SET TIMESTAMP=1579631544;
  insert into t1 values(null, "c");
  SET INSERT_ID=4;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "d");
  SET INSERT_ID=5;
! SET TIMESTAMP=1579631546;
  insert into t1 values(null, "e");
  SET INSERT_ID=6;
! SET TIMESTAMP=1579631543;
  insert into t1 values(null, "f");
  
  --- end of test --
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

mysqldump                      [ pass ]   
mysqltest                      [ pass ]   
ndb_alter_table                [ pass ]   
ndb_autodiscover               [ pass ]   
ndb_autodiscover2              [ pass ]   
ndb_autodiscover3              [ pass ]   
ndb_basic                      [ pass ]   
ndb_blob                       [ pass ]   
ndb_cache                      [ pass ]   
ndb_charset                    [ pass ]   
ndb_config                     [ pass ]   
ndb_database                   [ pass ]   
ndb_index                      [ pass ]   
ndb_index_ordered              [ pass ]   
ndb_index_unique               [ pass ]   
ndb_insert                     [ pass ]   
ndb_limit                      [ pass ]   
ndb_load                       [ pass ]   
ndb_loaddatalocal              [ pass ]   
ndb_lock                       [ pass ]   
ndb_minmax                     [ pass ]   
ndb_multi                      [ pass ]   
ndb_rename                     [ pass ]   
ndb_replace                    [ pass ]   
ndb_restore                    [ pass ]   
ndb_subquery                   [ pass ]   
ndb_transaction                [ pass ]   
ndb_truncate                   [ pass ]   
ndb_types                      [ pass ]   
ndb_update                     [ pass ]   
negation_elimination           [ pass ]   
not_embedded_server            [ pass ]   
null                           [ pass ]   
null_key                       [ pass ]   
odbc                           [ pass ]   
olap                           [ pass ]   
openssl_1                      [ skipped ]
order_by                       [ pass ]   
order_fill_sortbuf             [ pass ]   
outfile                        [ pass ]   
overflow                       [ pass ]   
packet                         [ pass ]   
preload                        [ pass ]   
ps                             [ pass ]   
ps_10nestset                   [ pass ]   
ps_11bugs                      [ pass ]   
ps_1general                    [ pass ]   
ps_2myisam                     [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_2myisam.result	Sonntag, 31. Dezember 2006 11:30:56
--- r/ps_2myisam.reject	Sonntag, 31. Dezember 2006 12:28:18
***************
*** 1850,1857 ****
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662680861
! param10	662680861
  const11	1991
  param11	1991
  const12	NULL
--- 1850,1857 ----
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662702461
! param10	662702461
  const11	1991
  param11	1991
  const12	NULL
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

ps_3innodb                     [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_3innodb.result	Sonntag, 31. Dezember 2006 11:30:56
--- r/ps_3innodb.reject	Sonntag, 31. Dezember 2006 12:29:02
***************
*** 1833,1840 ****
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662680861
! param10	662680861
  const11	1991
  param11	1991
  const12	NULL
--- 1833,1840 ----
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662702461
! param10	662702461
  const11	1991
  param11	1991
  const12	NULL
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

ps_4heap                       [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_4heap.result	Sonntag, 31. Dezember 2006 11:30:56
--- r/ps_4heap.reject	Sonntag, 31. Dezember 2006 12:29:45
***************
*** 1834,1841 ****
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662680861
! param10	662680861
  const11	1991
  param11	1991
  const12	NULL
--- 1834,1841 ----
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662702461
! param10	662702461
  const11	1991
  param11	1991
  const12	NULL
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

ps_5merge                      [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_5merge.result	Sonntag, 31. Dezember 2006 11:30:56
--- r/ps_5merge.reject	Sonntag, 31. Dezember 2006 12:30:29
***************
*** 1770,1777 ****
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662680861
! param10	662680861
  const11	1991
  param11	1991
  const12	NULL
--- 1770,1777 ----
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662702461
! param10	662702461
  const11	1991
  param11	1991
  const12	NULL
***************
*** 4784,4791 ****
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662680861
! param10	662680861
  const11	1991
  param11	1991
  const12	NULL
--- 4784,4791 ----
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662702461
! param10	662702461
  const11	1991
  param11	1991
  const12	NULL
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

ps_6bdb                        [ skipped ]
ps_7ndb                        [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_7ndb.result	Sonntag, 31. Dezember 2006 11:30:56
--- r/ps_7ndb.reject	Sonntag, 31. Dezember 2006 12:31:32
***************
*** 1833,1840 ****
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662680861
! param10	662680861
  const11	1991
  param11	1991
  const12	NULL
--- 1833,1840 ----
  param08	1991-08-05 01:01:01
  const09	1991-08-05 01:01:01
  param09	1991-08-05 01:01:01
! const10	662702461
! param10	662702461
  const11	1991
  param11	1991
  const12	NULL
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

ps_grant                       [ pass ]   
query_cache                    [ pass ]   
query_cache_merge              [ pass ]   
query_cache_notembedded        [ pass ]   
raid                           [ skipped ]
range                          [ pass ]   
rename                         [ pass ]   
repair                         [ pass ]   
replace                        [ skipped ]
rollback                       [ pass ]   
row                            [ pass ]   
rpl000001                      [ pass ]   
rpl000002                      [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl000002.result	Sonntag, 31. Dezember 2006 11:30:56
--- r/rpl000002.reject	Sonntag, 31. Dezember 2006 12:35:02
***************
*** 22,28 ****
  insert into t2 set created=now();
  select * from t2;
  id	created
! 1	1970-01-01 06:25:45
  create table t3 like t2;
  create temporary table t4 like t2;
  create table t5 select * from t4;
--- 22,28 ----
  insert into t2 set created=now();
  select * from t2;
  id	created
! 1	1970-01-01 00:25:45
  create table t3 like t2;
  create temporary table t4 like t2;
  create table t5 select * from t4;
***************
*** 29,35 ****
  start slave;
  select * from t2;
  id	created
! 1	1970-01-01 06:25:45
  show create table t3;
  Table	Create Table
  t3	CREATE TABLE `t3` (
--- 29,35 ----
  start slave;
  select * from t2;
  id	created
! 1	1970-01-01 00:25:45
  show create table t3;
  Table	Create Table
  t3	CREATE TABLE `t3` (
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

rpl000004                      [ pass ]   
rpl000005                      [ pass ]   
rpl000006                      [ pass ]   
rpl000008                      [ pass ]   
rpl000009                      [ pass ]   
rpl000010                      [ pass ]   
rpl000011                      [ pass ]   
rpl000012                      [ pass ]   
rpl000013                      [ pass ]   
rpl000015                      [ pass ]   
rpl000017                      [ pass ]   
rpl000018                      [ skipped ]
rpl_EE_error                   [ pass ]   
rpl_alter                      [ pass ]   
rpl_chain_temp_table           [ skipped ]
rpl_change_master              [ pass ]   
rpl_charset                    [ pass ]   
rpl_commit_after_flush         [ pass ]   
rpl_create_database            [ pass ]   
rpl_ddl                        [ pass ]   
rpl_deadlock                   [ pass ]   
rpl_delete_all                 [ pass ]   
rpl_do_grant                   [ pass ]   
rpl_drop                       [ pass ]   
rpl_drop_db                    [ pass ]   
rpl_drop_temp                  [ pass ]   
rpl_dual_pos_advance           [ pass ]   
rpl_empty_master_crash         [ pass ]   
rpl_error_ignored_table        [ pass ]   
rpl_failed_optimize            [ pass ]   
rpl_failsafe                   [ skipped ]
rpl_flush_log_loop             [ pass ]   
rpl_flush_tables               [ pass ]   
rpl_free_items                 [ pass ]   
rpl_get_lock                   [ pass ]   
rpl_heap                       [ skipped ]
rpl_ignore_grant               [ pass ]   
rpl_ignore_table               [ pass ]   
rpl_init_slave                 [ pass ]   
rpl_innodb                     [ pass ]   
rpl_insert_id                  [ pass ]   
rpl_insert_ignore              [ pass ]   
rpl_insert_select              [ pass ]   
rpl_loaddata                   [ pass ]   
rpl_loaddata_rule_m            [ pass ]   
rpl_loaddata_rule_s            [ pass ]   
rpl_loaddatalocal              [ pass ]   
rpl_log                        [ pass ]   
rpl_log_pos                    [ pass ]   
rpl_many_optimize              [ pass ]   
rpl_master_pos_wait            [ pass ]   
rpl_max_relay_size             [ pass ]   
rpl_misc_functions             [ pass ]   
rpl_multi_delete               [ pass ]   
rpl_multi_delete2              [ pass ]   
rpl_multi_query                [ pass ]   
rpl_multi_update               [ pass ]   
rpl_multi_update2              [ pass ]   
rpl_multi_update3              [ pass ]   
rpl_multi_update4              [ pass ]   
rpl_mystery22                  [ pass ]   
rpl_openssl                    [ skipped ]
rpl_optimize                   [ pass ]   
rpl_ps                         [ pass ]   
rpl_redirect                   [ pass ]   
rpl_relayrotate                [ pass ]   
rpl_relayspace                 [ pass ]   
rpl_replicate_do               [ pass ]   
rpl_reset_slave                [ pass ]   
rpl_rewrite_db                 [ pass ]   
rpl_rotate_logs                [ pass ]   
rpl_server_id1                 [ pass ]   
rpl_server_id2                 [ pass ]   
rpl_set_charset                [ pass ]   
rpl_skip_error                 [ pass ]   
rpl_slave_status               [ pass ]   
rpl_sporadic_master            [ pass ]   
rpl_start_stop_slave           [ pass ]   
rpl_temporary                  [ pass ]   
rpl_timezone                   [ pass ]   
rpl_trunc_binlog               [ skipped ]
rpl_trunc_temp                 [ pass ]   
rpl_until                      [ pass ]   
rpl_user_variables             [ pass ]   
rpl_variables                  [ pass ]   
select                         [ pass ]   
select_found                   [ pass ]   
select_safe                    [ pass ]   
show_check                     [ pass ]   
skip_name_resolve              [ pass ]   
sql_mode                       [ pass ]   
status                         [ pass ]   
subselect                      [ pass ]   
subselect2                     [ pass ]   
subselect_gis                  [ pass ]   
subselect_innodb               [ pass ]   
symlink                        [ pass ]   
synchronization                [ pass ]   
system_mysql_db                [ pass ]   
system_mysql_db_fix            [ pass ]   
system_mysql_db_refs           [ pass ]   
tablelock                      [ pass ]   
temp_table                     [ pass ]   
timezone                       [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/timezone.result	Sonntag, 31. Dezember 2006 11:30:58
--- r/timezone.reject	Sonntag, 31. Dezember 2006 12:51:06
***************
*** 27,34 ****
  1035680400	2002-10-27 02:00:00
  1035673200	2002-10-27 01:00:00
  1035680400	2002-10-27 02:00:00
! 1048986000	2003-03-30 03:00:00
! 1048986000	2003-03-30 03:00:00
  1048989599	2003-03-30 03:59:59
  1048989601	2003-03-30 04:00:01
  DROP TABLE t1;
--- 27,34 ----
  1035680400	2002-10-27 02:00:00
  1035673200	2002-10-27 01:00:00
  1035680400	2002-10-27 02:00:00
! 1048986000	2003-03-30 02:00:00
! 1048989600	2003-03-30 04:00:00
  1048989599	2003-03-30 03:59:59
  1048989601	2003-03-30 04:00:01
  DROP TABLE t1;
***************
*** 38,43 ****
--- 38,44 ----
  ('2003-03-30 03:00:00');
  Warnings:
  Warning	1299	Invalid TIMESTAMP value in column 'ts' at row 2
+ Warning	1299	Invalid TIMESTAMP value in column 'ts' at row 3
  DROP TABLE t1;
  select unix_timestamp('1970-01-01 01:00:00'), 
  unix_timestamp('1970-01-01 01:00:01'),
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

timezone2                      [ pass ]   
timezone3                      [ skipped ]
timezone_grant                 [ pass ]   
truncate                       [ pass ]   
type_blob                      [ pass ]   
type_date                      [ pass ]   
type_datetime                  [ pass ]   
type_decimal                   [ pass ]   
type_enum                      [ pass ]   
type_float                     [ pass ]   
type_nchar                     [ pass ]   
type_ranges                    [ pass ]   
type_set                       [ pass ]   
type_time                      [ pass ]   
type_timestamp                 [ fail ]

Errors are (from /tmp/mysql-4.1.22/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/type_timestamp.result	Sonntag, 31. Dezember 2006 11:30:58
--- r/type_timestamp.reject	Sonntag, 31. Dezember 2006 12:52:24
***************
*** 15,29 ****
  insert into t1 (a) select a+1 from t2 where a=8;
  select * from t1;
  a	t
! 1	1970-01-01 03:20:34
  2	2002-03-03 00:00:00
! 3	1970-01-01 03:20:35
! 4	1970-01-01 03:20:36
  5	2002-03-04 00:00:00
! 6	1970-01-01 03:20:37
  7	2002-03-05 00:00:00
  8	0000-00-00 00:00:00
! 9	1970-01-01 03:20:38
  drop table t1,t2;
  SET TIMESTAMP=1234;
  CREATE TABLE t1 (value TEXT NOT NULL, id VARCHAR(32) NOT NULL, stamp timestamp, PRIMARY KEY (id));
--- 15,29 ----
  insert into t1 (a) select a+1 from t2 where a=8;
  select * from t1;
  a	t
! 1	1969-12-31 21:20:34
  2	2002-03-03 00:00:00
! 3	1969-12-31 21:20:35
! 4	1969-12-31 21:20:36
  5	2002-03-04 00:00:00
! 6	1969-12-31 21:20:37
  7	2002-03-05 00:00:00
  8	0000-00-00 00:00:00
! 9	1969-12-31 21:20:38
  drop table t1,t2;
  SET TIMESTAMP=1234;
  CREATE TABLE t1 (value TEXT NOT NULL, id VARCHAR(32) NOT NULL, stamp timestamp, PRIMARY KEY (id));
***************
*** 40,46 ****
  insert into t1 values (now());
  select date_format(a,"%Y %y"),year(a),year(now()) from t1;
  date_format(a,"%Y %y")	year(a)	year(now())
! 1970 70	1970	1970
  drop table t1;
  create table t1 (ix timestamp);
  insert into t1 values (19991101000000),(19990102030405),(19990630232922),(19990601000000),(19990930232922),(19990531232922),(19990501000000),(19991101000000),(19990501000000);
--- 40,46 ----
  insert into t1 values (now());
  select date_format(a,"%Y %y"),year(a),year(now()) from t1;
  date_format(a,"%Y %y")	year(a)	year(now())
! 1969 69	1969	1969
  drop table t1;
  create table t1 (ix timestamp);
  insert into t1 values (19991101000000),(19990102030405),(19990630232922),(19990601000000),(19990930232922),(19990531232922),(19990501000000),(19991101000000),(19990501000000);
***************
*** 177,183 ****
  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
--- 177,183 ----
  insert into t1 (t1,t3) values (default, default);
  select * from t1;
  t1	t2	t3
! 2003-01-01 00:00:00	2001-09-08 22: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
***************
*** 201,208 ****
  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` (
--- 201,208 ----
  insert into t1 (t1,t3) values (default, default);
  select * from t1;
  t1	t2	t3
! 2001-09-08 22:46:42	2001-09-08 22:46:43	0000-00-00 00:00:00
! 2001-09-08 22:46:43	NULL	0000-00-00 00:00:00
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
***************
*** 228,234 ****
  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
--- 228,234 ----
  insert into t1 (t1) values (default);
  select * from t1;
  t1	t2
! 2001-09-08 22:46:45	2001-09-08 22:46:45
  2003-01-01 00:00:00	NULL
  show create table t1;
  Table	Create Table
***************
*** 246,252 ****
  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;
--- 246,252 ----
  insert into t1 values ();
  select * from t1;
  t1	t2
! 2001-09-08 22:46:46	NULL
  SET TIMESTAMP=1000000007;
  update t1 set t2=now();
  SET TIMESTAMP=1000000007;
***************
*** 253,260 ****
  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` (
--- 253,260 ----
  insert into t1 (t1) values (default);
  select * from t1;
  t1	t2
! 2001-09-08 22:46:47	2001-09-08 22:46:47
! 2001-09-08 22:46:47	NULL
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
***************
*** 271,277 ****
  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;
--- 271,277 ----
  insert into t1 values ();
  select * from t1;
  t1	t2	t3
! 2001-09-08 22:46:47	NULL	0000-00-00 00:00:00
  SET TIMESTAMP=1000000008;
  update t1 set t2=now();
  SET TIMESTAMP=1000000008;
***************
*** 278,285 ****
  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` (
--- 278,285 ----
  insert into t1 (t1,t3) values (default, default);
  select * from t1;
  t1	t2	t3
! 2001-09-08 22:46:48	2001-09-08 22:46:48	0000-00-00 00:00:00
! 2001-09-08 22:46:48	NULL	0000-00-00 00:00:00
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
***************
*** 298,304 ****
  insert into t1 values ();
  select * from t1;
  t1	t2
! 2001-09-09 04:46:49	NULL
  SET TIMESTAMP=1000000010;
  update t1 set t2=now();
  SET TIMESTAMP=1000000011;
--- 298,304 ----
  insert into t1 values ();
  select * from t1;
  t1	t2
! 2001-09-08 22:46:49	NULL
  SET TIMESTAMP=1000000010;
  update t1 set t2=now();
  SET TIMESTAMP=1000000011;
***************
*** 305,312 ****
  insert into t1 (t1) values (default);
  select * from t1;
  t1	t2
! 2001-09-09 04:46:50	2001-09-09 04:46:50
! 2001-09-09 04:46:51	NULL
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
--- 305,312 ----
  insert into t1 (t1) values (default);
  select * from t1;
  t1	t2
! 2001-09-08 22:46:50	2001-09-08 22:46:50
! 2001-09-08 22:46:51	NULL
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
***************
*** 335,341 ****
  replace into t1 set pk = 1, bulk= 20;
  select * from t1;
  pk	t1	bulk
! 1	2001-09-09 04:46:53	20
  drop table t1;
  create table t1 (pk int primary key, t1 timestamp default '2003-01-01 00:00:00' on update current_timestamp, bulk int);
  insert into t1 values (1, '2004-04-01 00:00:00', 10);
--- 335,341 ----
  replace into t1 set pk = 1, bulk= 20;
  select * from t1;
  pk	t1	bulk
! 1	2001-09-08 22:46:53	20
  drop table t1;
  create table t1 (pk int primary key, t1 timestamp default '2003-01-01 00:00:00' on update current_timestamp, bulk int);
  insert into t1 values (1, '2004-04-01 00:00:00', 10);
***************
*** 351,357 ****
  replace into t1 set pk = 1, bulk= 20;
  select * from t1;
  pk	t1	bulk
! 1	2001-09-09 04:46:55	20
  drop table t1;
  create table t1 (t1 timestamp default current_timestamp on update current_timestamp);
  insert into t1 values ('2004-04-01 00:00:00');
--- 351,357 ----
  replace into t1 set pk = 1, bulk= 20;
  select * from t1;
  pk	t1	bulk
! 1	2001-09-08 22:46:55	20
  drop table t1;
  create table t1 (t1 timestamp default current_timestamp on update current_timestamp);
  insert into t1 values ('2004-04-01 00:00:00');
***************
*** 389,395 ****
  select * from t1;
  a	b
  NULL	NULL
! 2001-09-09 04:46:58	NULL
  drop table t1;
  create table t1 (a timestamp null default null, b timestamp null default '2003-01-01 00:00:00');
  show create table t1;
--- 389,395 ----
  select * from t1;
  a	b
  NULL	NULL
! 2001-09-08 22:46:58	NULL
  drop table t1;
  create table t1 (a timestamp null default null, b timestamp null default '2003-01-01 00:00:00');
  show create table t1;
***************
*** 411,417 ****
  alter table t1 modify a timestamp, modify b timestamp;
  select * from t1;
  a	b
! 2001-09-09 04:46:59	2001-09-09 04:46:59
  2003-01-01 00:00:00	2003-01-02 00:00:00
  drop table t1;
  create table t1 (a char(2), t timestamp);
--- 411,417 ----
  alter table t1 modify a timestamp, modify b timestamp;
  select * from t1;
  a	b
! 2001-09-08 22:46:59	2001-09-08 22:46:59
  2003-01-01 00:00:00	2003-01-02 00:00:00
  drop table t1;
  create table t1 (a char(2), t timestamp);
***************
*** 452,458 ****
  1	0	2001-01-01 01:01:01
  2	2	2002-02-02 02:02:02
  3	0	2003-03-03 03:03:03
! 4	NULL	2001-09-09 04:46:59
  update t1 set c = '2004-04-04 04:04:04' where a = 4;
  select * from t1;
  a	b	c
--- 452,458 ----
  1	0	2001-01-01 01:01:01
  2	2	2002-02-02 02:02:02
  3	0	2003-03-03 03:03:03
! 4	NULL	2001-09-08 22:46:59
  update t1 set c = '2004-04-04 04:04:04' where a = 4;
  select * from t1;
  a	b	c
***************
*** 467,473 ****
  2	2	2002-02-02 02:02:02
  3	3	2003-03-03 03:03:03
  4	NULL	2004-04-04 04:04:04
! 5	NULL	2001-09-09 04:46:59
  insert into t1 (a, c) values (4, '2004-04-04 00:00:00'),
  (6, '2006-06-06 06:06:06') on duplicate key update b = 4;
  select * from t1;
--- 467,473 ----
  2	2	2002-02-02 02:02:02
  3	3	2003-03-03 03:03:03
  4	NULL	2004-04-04 04:04:04
! 5	NULL	2001-09-08 22:46:59
  insert into t1 (a, c) values (4, '2004-04-04 00:00:00'),
  (6, '2006-06-06 06:06:06') on duplicate key update b = 4;
  select * from t1;
***************
*** 475,481 ****
  1	0	2001-01-01 01:01:01
  2	2	2002-02-02 02:02:02
  3	3	2003-03-03 03:03:03
! 4	4	2001-09-09 04:46:59
! 5	NULL	2001-09-09 04:46:59
  6	NULL	2006-06-06 06:06:06
  drop table t1;
--- 475,481 ----
  1	0	2001-01-01 01:01:01
  2	2	2002-02-02 02:02:02
  3	3	2003-03-03 03:03:03
! 4	4	2001-09-08 22:46:59
! 5	NULL	2001-09-08 22:46:59
  6	NULL	2006-06-06 06:06:06
  drop table t1;
-------------------------------------------------------
Please follow the instructions outlined at
http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.


Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Starting ndbcluster
Starting ndbd
Starting ndbd
Waiting for started...
NDBT_ProgramExit: 0 - OK
Connected to Management Server at: localhost:9350
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=1	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0, Master)
id=2	@127.0.0.1  (Version: 4.1.22, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=3	@127.0.0.1  (Version: 4.1.22)

[mysqld(API)]	4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Resuming Tests

type_uint                      [ pass ]   
type_year                      [ pass ]   
union                          [ pass ]   
update                         [ pass ]   
user_var-binlog                [ pass ]   
user_var                       [ pass ]   
varbinary                      [ pass ]   
variables                      [ pass ]   
wait_timeout                   [ pass ]   
warnings                       [ pass ]   
windows                        [ skipped ]
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Failed 11/340 tests, 96.76% were successful.

The log files in /tmp/mysql-4.1.22/mysql-test/var/log may give you some hint
of what when wrong.
If you want to report this error, please read first the documentation at
http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run in default mode: *** Failing the test(s): func_time func_timestamp mysqlbinlog2 ps_2myisam ps_3innodb ps_4heap ps_5merge ps_7ndb rpl000002 timezone type_timestamp