MySQL Bugs: #10871: Unknown character set: 'ucs2'

Bug #10871	Unknown character set: 'ucs2'
Submitted:	25 May 2005 22:14	Modified:	13 Jun 2005 5:25
Reporter:	David Dick	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.4-beta	OS:	Linux (Redhat 7.3)
Assigned to:	Jorge del Conde	CPU Architecture:	Any

Description:
./configure; make; make test for mysql-5.0.4-beta fails with

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_eucjpms                  [ skipped ]
ctype_latin1                   [ pass ]
ctype_latin1_de                [ 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               [ fail ]

Errors are (from /home/dave/mysql-5.0.4-beta/mysql-test/var/log/mysqltest-time) :
/home/dave/mysql-5.0.4-beta/client/.libs/mysqltest: At line 7: query 'create table t2 (c char(30)) charset=ucs2' failed: 1115: Unknown character set: 'ucs2'
(the last lines may be the most important ones)

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

How to repeat:
as described above, test suite fails to complete.

Suggested fix:
possibly allow ./configure option to disallow bad/missing character sets.

Hi,

I was unable to reproduce this bug in FC2 using 5.0.7 from bk:

root-mysql/mysql-test# ./mysql-test-run ctype_ucs_binlog
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb     
Installing Slave Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb     
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
ctype_ucs_binlog               [ pass ]   
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
All 1 tests were successful.

After compiling mysql with:
configure;make

I got the following:

root-mysql55/mysql-test# ./mysql-test-run ctype_ucs_binlog 
<cut>
TEST                            RESULT
-------------------------------------------------------
ctype_ucs_binlog               [ skipped ]
-------------------------------------------------------

Fixed in 5.0.6-beta