Bug #6647 "user_var" test fails with "unknown character set"
Submitted: 15 Nov 2004 22:40 Modified: 18 Nov 2004 13:46
Reporter: Lenz Grimmer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.8 OS:Linux (Linux/PPC)
Assigned to: Alexander Barkov CPU Architecture:Any

[15 Nov 2004 22:40] Lenz Grimmer 
Description:
When unpacking a source distribution and simply running "configure" (without any additional options), the "user_var" test fails with the following error:

user_var                       [ fail ]

Errors are (from mysql-4.1.8/mysql-test/var/log/mysqltest-time) :
mysql-4.1.8/client/.libs/mysqltest: At line 111: query 'create table t2 (c char(30)) charset=ucs2' failed: 1115: Unknown character set: 'ucs2'

It seems like configuring without any special charset options does not enable the ucs2 char set?
IMHO the test suite should pass all tests, if the server was just built with a plain "configure" without any additional options.

How to repeat:
Compile MySQL with a plain "./configure ; make" and run the "user_var" test.

Suggested fix:
Either change the test to not use a charset that may not be available, or fix the configure script to enable ucs2 by default.
[18 Nov 2004 13:46] Guilhem Bichot 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

ChangeSet@1.2119, 2004-11-17 17:06:24+01:00, guilhem@mysql.com
  time independent test

ChangeSet@1.2118, 2004-11-17 16:41:30+01:00, guilhem@mysql.com
  Fixes for compilation errors in Windows (casts from uint32* to uint*) in repl and charset code.
  Moving the part of user_var.test using UCS2 to ctype_ucs.test