Skipping ndbcluster, mysqld not compiled with ndbcluster Skipping SSL, mysqld not compiled with SSL Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 3340 Using MASTER_MYPORT1 = 3341 Using SLAVE_MYPORT = 3356 Using NDBCLUSTER_PORT = 9350 Using IM_MYSQLD1_PORT = 3345 Using IM_MYSQLD2_PORT = 3347 Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases Creating IM password file (/users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051215061510.info/mysql-5.0.18-standard/mysql-test/var/im.passwd) Installing Im_mysqld_1 Databases Installing Im_mysqld_2 Databases ======================================================= Finding Tests in the 'main' suite Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- fulltext [ fail ] Errors are (from /users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051215061510.info/mysql-5.0.18-standard/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/fulltext.result 2005-12-15 09:02:58.000000000 +0300 --- r/fulltext.reject 2005-12-15 14:27:07.000000000 +0300 *************** *** 11,18 **** t1 1 a 2 b NULL NULL NULL NULL YES FULLTEXT select * from t1 where MATCH(a,b) AGAINST ("collections"); a b - Only MyISAM tables support collections Full-text indexes are called collections explain extended select * from t1 where MATCH(a,b) AGAINST ("collections"); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 fulltext a a 0 1 Using where --- 11,18 ---- t1 1 a 2 b NULL NULL NULL NULL YES FULLTEXT select * from t1 where MATCH(a,b) AGAINST ("collections"); a b Full-text indexes are called collections + Only MyISAM tables support collections explain extended select * from t1 where MATCH(a,b) AGAINST ("collections"); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 fulltext a a 0 1 Using where *************** *** 166,173 **** Function MATCH ... AGAINST() is used to do a search select * from t1 where MATCH(a,b) AGAINST ("collections") UNION ALL select * from t1 where MATCH(a,b) AGAINST ("indexes"); a b - Only MyISAM tables support collections Full-text indexes are called collections Full-text indexes are called collections delete from t1 where a like "MySQL%"; update t1 set a='some test foobar' where MATCH a,b AGAINST ('model'); --- 166,173 ---- Function MATCH ... AGAINST() is used to do a search select * from t1 where MATCH(a,b) AGAINST ("collections") UNION ALL select * from t1 where MATCH(a,b) AGAINST ("indexes"); a b Full-text indexes are called collections + Only MyISAM tables support collections Full-text indexes are called collections delete from t1 where a like "MySQL%"; update t1 set a='some test foobar' where MATCH a,b AGAINST ('model'); *************** *** 369,375 **** t collation(t) SELECT t, collation(t),FORMAT(MATCH t AGAINST ('Osnabruck'),6) FROM t1 WHERE MATCH t AGAINST ('Osnabruck'); t collation(t) FORMAT(MATCH t AGAINST ('Osnabruck'),6) ! aus Osnabrück utf8_general_ci 1.591140 alter table t1 modify t varchar(200) collate latin1_german2_ci not null; Warnings: Warning 1265 Data truncated for column 't' at row 3 --- 369,375 ---- t collation(t) SELECT t, collation(t),FORMAT(MATCH t AGAINST ('Osnabruck'),6) FROM t1 WHERE MATCH t AGAINST ('Osnabruck'); t collation(t) FORMAT(MATCH t AGAINST ('Osnabruck'),6) ! aus Osnabrück utf8_general_ci 0.000000 alter table t1 modify t varchar(200) collate latin1_german2_ci not null; Warnings: Warning 1265 Data truncated for column 't' at row 3 ------------------------------------------------------- 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 fulltext2 [ fail ] Errors are (from /users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051215061510.info/mysql-5.0.18-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 176: query 'select count(*) from t1 where match a against ('aaazzz' in boolean mode)' failed: 126: Incorrect key file for table './test/t1.MYI'; try to repair it (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests fulltext_cache [ fail ] Errors are (from /users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051215061510.info/mysql-5.0.18-standard/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/fulltext_cache.result 2005-12-15 09:02:58.000000000 +0300 --- r/fulltext_cache.reject 2005-12-15 14:27:17.000000000 +0300 *************** *** 24,30 **** SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6) as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id; q item id x ! aaaaaaaaa dsaass de sushi 1 1.923787 aaaaaaaaa dsaass de Bolo de Chocolate 2 0.000000 aaaaaaaaa dsaass de Feijoada 3 0.000000 aaaaaaaaa dsaass de Mousse de Chocolate 4 0.000000 --- 24,30 ---- SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6) as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id; q item id x ! aaaaaaaaa dsaass de sushi 1 0.000000 aaaaaaaaa dsaass de Bolo de Chocolate 2 0.000000 aaaaaaaaa dsaass de Feijoada 3 0.000000 aaaaaaaaa dsaass de Mousse de Chocolate 4 0.000000 *************** *** 46,52 **** SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6) as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id; q item id x ! aaaaaaaaa dsaass de sushi 1 1.923787 aaaaaaaaa dsaass de Bolo de Chocolate 2 0.000000 aaaaaaaaa dsaass de Feijoada 3 0.000000 aaaaaaaaa dsaass de Mousse de Chocolate 4 0.000000 --- 46,52 ---- SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6) as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id; q item id x ! aaaaaaaaa dsaass de sushi 1 0.000000 aaaaaaaaa dsaass de Bolo de Chocolate 2 0.000000 aaaaaaaaa dsaass de Feijoada 3 0.000000 aaaaaaaaa dsaass de Mousse de Chocolate 4 0.000000 ------------------------------------------------------- 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 fulltext_distinct [ pass ] 220 fulltext_left_join [ fail ] Errors are (from /users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051215061510.info/mysql-5.0.18-standard/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/fulltext_left_join.result 2005-12-15 09:02:58.000000000 +0300 --- r/fulltext_left_join.reject 2005-12-15 14:27:21.000000000 +0300 *************** *** 21,27 **** round(match(t1.texte,t1.sujet,t1.motsclefs) against('droit'),5) 0.00000 0.00000 ! 0.67003 0.00000 select match(t1.texte,t1.sujet,t1.motsclefs) against('droit' IN BOOLEAN MODE) from t1 left join t2 on t2.id=t1.id; --- 21,27 ---- round(match(t1.texte,t1.sujet,t1.motsclefs) against('droit'),5) 0.00000 0.00000 ! 0.00000 0.00000 select match(t1.texte,t1.sujet,t1.motsclefs) against('droit' IN BOOLEAN MODE) from t1 left join t2 on t2.id=t1.id; ------------------------------------------------------- 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 fulltext_multi [ fail ] Errors are (from /users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051215061510.info/mysql-5.0.18-standard/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/fulltext_multi.result 2005-12-15 09:02:58.000000000 +0300 --- r/fulltext_multi.reject 2005-12-15 14:27:26.000000000 +0300 *************** *** 13,19 **** INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb'); SELECT a, round(MATCH b AGAINST ('lala lkjh'),5) FROM t1; a round(MATCH b AGAINST ('lala lkjh'),5) ! 1 0.67003 2 0.00000 3 0.00000 SELECT a, round(MATCH c AGAINST ('lala lkjh'),5) FROM t1; --- 13,19 ---- INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb'); SELECT a, round(MATCH b AGAINST ('lala lkjh'),5) FROM t1; a round(MATCH b AGAINST ('lala lkjh'),5) ! 1 0.00000 2 0.00000 3 0.00000 SELECT a, round(MATCH c AGAINST ('lala lkjh'),5) FROM 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 fulltext_order_by [ pass ] 163 fulltext_update [ pass ] 47 fulltext_var [ pass ] 32 ------------------------------------------------------- Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Failed 5/9 tests, 44.44% 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): fulltext fulltext2 fulltext_cache fulltext_left_join fulltext_multi