Has ndbcluster support Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Using NDBCLUSTER_PORT = 9350 Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases Install 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) ======================================================= Finding Tests in the 'main' suite Starting Tests in the 'main' suite 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 2006-12-31 11:30:55.081466200 -0300 --- r/func_time.reject 2007-01-19 08:18:34.043240800 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:55.095703000 -0300 --- r/func_timestamp.reject 2007-01-19 08:18:41.392449200 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:55.876146000 -0300 --- r/mysqlbinlog2.reject 2007-01-19 08:25:42.569048000 -0300 *************** *** 17,81 **** --- 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 -- /*!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; --- 17,81 ---- --- 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 -- /*!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,189 **** /*!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 -- /*!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; --- 83,189 ---- /*!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 -- /*!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,283 **** /*!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 -- /*!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; --- 191,283 ---- /*!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 -- /*!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,391 **** /*!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 -- /*!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; --- 285,391 ---- /*!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 -- /*!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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:56.629641800 -0300 --- r/ps_2myisam.reject 2007-01-19 08:38:59.503588600 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:56.663089800 -0300 --- r/ps_3innodb.reject 2007-01-19 08:39:07.770511000 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:56.698652200 -0300 --- r/ps_4heap.reject 2007-01-19 08:39:13.362353000 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:56.702249800 -0300 --- r/ps_5merge.reject 2007-01-19 08:39:22.711870400 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:56.773775400 -0300 --- r/ps_7ndb.reject 2007-01-19 08:40:05.369554600 -0300 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:56.954249800 -0300 --- r/rpl000002.reject 2007-01-19 08:42:51.625583800 -0300 *************** *** 22,35 **** 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; 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` ( --- 22,35 ---- 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; 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 15:30:58.186196800 +0100 --- r/timezone.reject 2007-01-19 12:54:10.841367800 +0100 *************** *** 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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 2006-12-31 11:30:58.390844000 -0300 --- r/type_timestamp.reject 2007-01-19 08:54:33.668973800 -0300 *************** *** 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,260 **** 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` ( --- 246,260 ---- 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; 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,285 **** 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` ( --- 271,285 ---- 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; 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,312 **** 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; 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` ( --- 298,312 ---- 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; 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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished 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(s) shutdown finished Slave(s) shutdown finished Failed 11/340 tests, 96.76% were successful. The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://www.mysql.com/doc/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