MySQLテスト3

昨日、MySQL のテストがうまくいったので、気をよくして、make test を実行したときに実行される、mysql-test/mysql-test-run も実行してみます。

$ cd ~/src/mysql-5.0.27/mysql-test
$ ./mysql-test-run
Logging: ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
.........................................
TEST                            RESULT
-------------------------------------------------------
alias                          [ pass ]
.........................................
ctype_ucs_binlog               [ fail ]

Errors are (from /home/espiya/src/mysql-5.0.27/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/ctype_ucs_binlog.result   2006-10-21 03:36:44.000000000 +0300
--- r/ctype_ucs_binlog.reject   2006-12-18 22:20:43.000000000 +0300
***************
*** 15,22 ****
  SET TIMESTAMP=10000"
  SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1"
  SET @@session.sql_mode=0"
! /*!\C latin1 */"
! SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8"
  insert into t2 values (@v)"
  # End of log file
  ROLLBACK /* added by mysqlbinlog */"
--- 15,21 ----
  SET TIMESTAMP=10000"
  SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1"
  SET @@session.sql_mode=0"
! SET @@session.auto_increment_increment=29811, @@session.auto_increment_offset=1124"
  insert into t2 values (@v)"
  # End of log file
  ROLLBACK /* added by mysqlbinlog */"
-------------------------------------------------------
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.


Aborting: ctype_ucs_binlog failed in default mode. 
                 To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
$

ctype_ucs_binlog でエラーです。とりあえず --force オプションを指定して先に行きます。

$ ./mysql-test-run --force　2>&1 >TEST.log
$ grep -o '.*\[ fail \]' TEST.log
ctype_ucs_binlog               [ fail ]
mysql_client_test              [ fail ]
mysqlbinlog                    [ fail ]
mysqlbinlog2                   [ fail ]
mysqlcheck                     [ fail ]
mysqldump                      [ fail ]
mysqlshow                      [ fail ]
null_key                       [ fail ]
order_by                       [ fail ]
preload                        [ fail ]
ps                             [ fail ]
query_cache                    [ fail ]
rename                         [ fail ]
rpl000002                      [ fail ]
rpl000005                      [ fail ]
rpl_auto_increment             [ fail ]
rpl_charset                    [ fail ]
rpl_dual_pos_advance           [ fail ]
rpl_innodb                     [ fail ]
rpl_insert_id                  [ fail ]
rpl_insert_ignore              [ fail ]
rpl_loaddata                   [ fail ]
rpl_log                        [ fail ]
rpl_multi_update2              [ fail ]
rpl_multi_update3              [ fail ]
rpl_optimize                   [ fail ]
rpl_replicate_do               [ fail ]
rpl_set_charset                [ fail ]
rpl_sp_effects                 [ fail ]
rpl_sporadic_master            [ fail ]
rpl_timezone                   [ fail ]
rpl_trigger                    [ fail ]
select                         [ fail ]
show_check                     [ fail ]
system_mysql_db                [ fail ]
system_mysql_db_fix            [ fail ]
user_var-binlog                [ fail ]
view                           [ fail ]
$

これは、かなりの数のエラーです。
コンパイルオプションかなにかで解決できるかもしれませんが、coLinux ですから見なかったことにします。どうしてもだめな場合が現れたら、yum でインストールして、FedoraCore にお任せすればよいですから。