cd mysql-test; \ ./mysql-test-run --force && \ ./mysql-test-run --ps-protocol --force Logging: ./mysql-test-run --force Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Manager disabled, skipping manager start. 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 [ pass ] func_timestamp [ pass ] 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 [ fail ] Errors are (from /mws/src/mysql/mysql-4.1.22/mysql-test/var/log/mysqltest-time) : mysql_client_test.c:8667: check failed: 'rc == 0' Abort - core dumped mysqltest: At line 13: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M" failed (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon master not cooperating with mysqladmin, will try manual kill ./mysql-test-run: kill: no such process master refused to die. Sending SIGKILL ./mysql-test-run: kill: no such process Master shutdown finished Slave shutdown finished Resuming Tests mysql_protocols [ pass ] mysqlbinlog [ pass ] mysqlbinlog2 [ pass ] mysqldump [ pass ] mysqltest [ pass ] ndb_alter_table [ skipped ] ndb_autodiscover [ skipped ] ndb_autodiscover2 [ skipped ] ndb_autodiscover3 [ skipped ] ndb_basic [ skipped ] ndb_blob [ skipped ] ndb_cache [ skipped ] ndb_charset [ skipped ] ndb_config [ skipped ] ndb_database [ skipped ] ndb_index [ skipped ] ndb_index_ordered [ skipped ] ndb_index_unique [ skipped ] ndb_insert [ skipped ] ndb_limit [ skipped ] ndb_load [ skipped ] ndb_loaddatalocal [ skipped ] ndb_lock [ skipped ] ndb_minmax [ skipped ] ndb_multi [ skipped ] ndb_rename [ skipped ] ndb_replace [ skipped ] ndb_restore [ skipped ] ndb_subquery [ skipped ] ndb_transaction [ skipped ] ndb_truncate [ skipped ] ndb_types [ skipped ] ndb_update [ skipped ] negation_elimination [ pass ] not_embedded_server [ pass ] null [ fail ] Errors are (from /mws/src/mysql/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/null.result Fri Nov 3 05:35:21 2006 --- r/null.reject Mon Jun 4 13:00:59 2007 *************** *** 12,18 **** NULL NULL NULL NULL select NULL=NULL,NULL<>NULL,IFNULL(NULL,1.1)+0,IFNULL(NULL,1) | 0; NULL=NULL NULL<>NULL IFNULL(NULL,1.1)+0 IFNULL(NULL,1) | 0 ! NULL NULL 1.1 1 select strcmp("a",NULL),(1NULL,IFNULL(NULL,1.1)+0,IFNULL(NULL,1) | 0; NULL=NULL NULL<>NULL IFNULL(NULL,1.1)+0 IFNULL(NULL,1) | 0 ! NULL NULL -NaN 1 select strcmp("a",NULL),(1