🚀 go-pugleaf

I install a mysql server in default installation with latin charset, but
I want to use GBK(a chinese charset), so that I can store and
search chinese words directly.

so, I download, unpack and then rewrite the mysql.spec and then recompile
the
package mysql-3.23.56-1.80.src.rpm.

first, this file contains some files:
[root@a root]# rpm2cpio mysql-3.23.56-1.80.src.rpm |cpio -t
filter-requires-mysql.sh
my.cnf
mysql-3.23.51-manfixes.patch
mysql-3.23.56.tar.gz
mysql-errno.patch
mysql.init
mysql.logrotate
mysql.spec

so, I rewrite the mysql.spec with
./configure \
    --with-charset=gbk\
......

and then cp all file into /usr/src/redhat/SOURCES/
#rpmbuild -ba /usr/src/redhat/SOURCES/mysql.spec

all compile is okay,
but the binary test can not be passed, why ? does it fail in charset=gbk???
and following is the part of output :



+ make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
030727 19:29:53  ../sql/mysqld: Shutdown Complete

Installing Slave Databases
030727 19:29:53  ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

 TEST                         USER   SYSTEM  ELAPSED        RESULT
------------------------------------------------------------------------
alias                         0.10     0.09     0.46       [ pass ]
alter_table                   0.03     0.03     0.18       [ pass ]
analyse                       0.03     0.03     0.06       [ pass ]
auto_increment                0.01     0.05     0.12       [ pass ]
backup                        0.04     0.02     0.12       [ pass ]
bdb-alter-table-1             0.03     0.02     3.08       [ pass ]
bdb-alter-table-2             0.04     0.01     0.06       [ pass ]
bdb-crash                     0.04     0.04     0.36       [ pass ]
bdb-deadlock                  0.04     0.02     0.35       [ pass ]
bdb                           0.02     0.07     9.83       [ pass ]
bench_count_distinct          0.04     0.04     0.13       [ pass ]
bigint                        0.03     0.03     0.10       [ pass ]
binary                        ....     ....     ....       [ fail ]

   >> Error at line 44: Result length mismatch <<Below are the diffs between
actual and expected results:
-------------------------------------------------------
*** r/binary.result     Thu Mar 13 21:46:29 2003
--- r/binary.reject     Sun Jul 27 19:30:25 2003
***************
*** 1,13 ****
  name
- ?
  ?
  ?
  concat("*",name,"*")
- *?*
  *?*
  *?*
  min(name)     min(concat("*",name,"*"))       max(name)
max(concat("*",name,"*"))
! ?     *?*     ?       *?*
  name
  ?
  ?
--- 1,13 ----
  name
  ?
+ ?
  ?
  concat("*",name,"*")
  *?*
+ *?*
  *?*
  min(name)     min(concat("*",name,"*"))       max(name)
max(concat("*",name,"*"))
! ?     *?*     ?       *?*
  name
  ?
  ?
***************
*** 19,26 ****
  min(name)     min(concat("*",name,"*"))       max(name)
max(concat("*",name,"*"))
  ?     *?*     ?       *?*
  name
- ?
- ?
  name
  ?
  ?
--- 19,24 ----
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1
error: Bad exit status from /var/tmp/rpm-tmp.75496 (%build)


RPM build errors:
    Bad exit status from /var/tmp/rpm-tmp.75496 (%build)