MySQL Bugs: #1838: using source tar ball "gmake test" always fails at ctype_latin1

Bug #1838	using source tar ball "gmake test" always fails at ctype_latin1_de test
Submitted:	14 Nov 2003 9:52	Modified:	17 Dec 2003 2:25
Reporter:	Ken Menzel	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	All current	OS:	Any (All)
Assigned to:	Alexander Barkov	CPU Architecture:	Any

Description:
executive summary: sql/share/charsets is missing latin1_de.conf, please add it if you are going to test it.

Details:
After download a fresh tar ball ( I chose the recend 4.0.16 ) for to demostrate this long existing problem. Unpack the source tree then proceed though your favorite config and make.  final step is to test before install.  This always fails with:
create                         [ pass ]
ctype_cp1251                   [ pass ]
ERROR: /usr/home/sysadm/mysql/mysql-4.0.16/mysql-test/var/run/master.pid was not created in 30 seconds;  Aborting
gmake: *** [test] Error 1

Error file contains:
CURRENT_TEST: ctype_latin1_de
/usr/home/sysadm/mysql/mysql-4.0.16/sql/mysqld: File '/usr/home/sysadm/mysql/mysql-4.0.16/sql/share/charsets/latin1_de.conf' not found (Errcode: 2)
/usr/home/sysadm/mysql/mysql-4.0.16/sql/mysqld: Character set 'latin1_de' is not a compiled character set and is not specified in the '/usr/home/sysadm/mysql/mysql-4.0.16/sql/share/charsets/Index' file
bash-2.05a$

Looking thourgh the tar.gz file I find the test but not the char set!
----------------------------------------------------------------------
bash-2.05a$ tar tvzf ../mysql-4.0.16.tar.gz | grep latin1_de
-rw-r--r-- 503/100        4317 Oct 17 01:46 2003 mysql-4.0.16/mysql-test/r/ctype_latin1_de.result
-rw-r--r-- 503/100          41 Oct 17 01:46 2003 mysql-4.0.16/mysql-test/t/ctype_latin1_de-master.opt
-rw-r--r-- 503/100        2988 Oct 17 01:46 2003 mysql-4.0.16/mysql-test/t/ctype_latin1_de.test
-rw-r--r-- 503/100       12064 Oct 17 01:29 2003 mysql-4.0.16/strings/ctype-latin1_de.c
bash-2.05a$

A simple copy of latin1.conf to latin1_de.conf allows the tests to continue.
cp sql/share/charsets/latin1.conf sql/share/charsets/latin1_de.conf
But fails due to charset not being correct,  however this was expected as the latin1_de is not the same as latin1.  But the server started and the test ran.
ctype_latin1_de                [ fail ]

Errors are (from /usr/home/sysadm/mysql/mysql-4.0.16/mysql-test/var/log/mysqltest-time) :
/usr/home/sysadm/mysql/mysql-4.0.16/client/.libs/mysqltest: At line 75: Result length mismatch
< much cut>

How to repeat:
gmaks -s test from fresh source tarball in new directories.

Suggested fix:
please add latin1_de.conf to tar.gz source distributions if you are going to test it.

Forgot to mention ujis.conf (ujis character) as the ujis characterset is also tested bu missing in the distribution!

The test suite in 4.0 assumes that all character sets are incompiled.
You need to run configure --with-extra-charsets=all to be able to
run 4.0 test suite. Unfortunately, it is hard to fix this kind of behaviour
in 4.0. 

Note, this problem is already solved in 4.1. All tests related to not
incompiled character sets are skipped.