Attachment 47921 Details for Bug 113756

output from mysql-test/mysql-test-run

mysql.error (text/plain), 8.02 KB, created by Michael Skibbe on 2005-08-29 08:18:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Michael Skibbe

Created: 2005-08-29 08:18:38 UTC

Size: 8.02 KB

patch

obsolete

>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 ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>backup                         [ pass ]   
>bdb-alter-table-1              [ skipped ]
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>bdb-alter-table-2              [ skipped ]
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>bdb-crash                      [ skipped ]
>bdb-deadlock                   [ skipped ]
>bdb                            [ skipped ]
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>bdb_cache                      [ skipped ]
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>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 ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>count_distinct2                [ pass ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>count_distinct3                [ pass ]   
>create                         [ pass ]   
>create_select_tmp              [ pass ]   
>csv                            [ skipped ]
>ctype_big5                     [ skipped ]
>ctype_collate                  [ pass ]   
>ctype_cp1250_ch                [ skipped ]
>ctype_cp1251                   [ pass ]   
>ctype_cp932                    [ skipped ]
>ctype_create                   [ pass ]   
>ctype_latin1                   [ pass ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>ctype_latin1_de                [ pass ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>ctype_latin2                   [ pass ]   
>ctype_many                     [ skipped ]
>ctype_mb                       [ pass ]   
>ctype_recoding                 [ pass ]   
>ctype_sjis                     [ skipped ]
>ctype_tis620                   [ skipped ]
>ctype_uca                      [ skipped ]
>ctype_ucs                      [ skipped ]
>ctype_ucs_binlog               [ skipped ]
>ctype_ujis                     [ skipped ]
>ctype_utf8                     [ pass ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>date_formats                   [ pass ]   
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>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                       [ fail ]
>
>Errors are (from /tmp/mysql-4.1.13/mysql-test/var/log/mysqltest-time) :
>/tmp/mysql-4.1.13/client/.libs/mysqltest: At line 341: 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-08-29 08:24:13.000000000 +0300
>--- r/fulltext.reject	2005-08-29 11:02:01.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
>***************
>*** 165,172 ****
>  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');
>--- 165,172 ----
>  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');
>***************
>*** 368,374 ****
>  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
>--- 368,374 ----
>  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.
>
>
>Aborting: fulltext failed in default mode. To continue, re-run with '--force'.
>
>Ending Tests
>Shutting-down MySQL daemon
>
>master not cooperating with mysqladmin, will try manual kill
>master responded to SIGTERM 
>Master shutdown finished
>Slave shutdown finished

Actions: View

Attachments on bug 113756: 47921