Bug #420 Server 4.1 Make test fails - 'latin1_german2_ci' is not valid
Submitted: 12 May 2003 10:15 Modified: 22 May 2003 12:36
Reporter: Brent Smith Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:4.1 OS:Solaris (Solaris 8 x86)
Assigned to: Bugs System CPU Architecture:Any

[12 May 2003 10:15] Brent Smith
I am able to successfully compile, but when I run 'make test' I get the following:

ctype_collate                 ....     ....     ....       [ fail ]

   >> Error at line 61: query 'SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE latin1_german2_ci' failed: 1251: COLLATION 'latin1_german2_ci' is not valid for CHARACTER SET 'latin1'<<

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

>Release:       mysql-4.1.0-alpha (Source distribution)

>C compiler:    gcc (GCC) 3.1
>C++ compiler:  g++ (GCC) 3.1
        <machine, os, target, libraries (multiple lines)>
System: SunOS brentserver 5.8 Generic_108529-14 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/local/bin/perl /opt/sfw/bin/make /opt/sfw/bin/gmake /usr/local
/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/3.1/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/l
d --disable-nls
Thread model: posix
gcc version 3.1
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLA
-rw-r--r--   1 root     bin      1589264 May 24  2002 /lib/libc.a
lrwxrwxrwx   1 root     root          11 May 26  2002 /lib/libc.so -> ./libc.so.
-rwxr-xr-x   1 root     bin       944544 May 24  2002 /lib/libc.so.1
-rw-r--r--   1 root     bin      1589264 May 24  2002 /usr/lib/libc.a
lrwxrwxrwx   1 root     root          11 May 26  2002 /usr/lib/libc.so -> ./libc
-rwxr-xr-x   1 root     bin       944544 May 24  2002 /usr/lib/libc.so.1
Configure command: configure '--without-debug' '--prefix=/usr/local/mysql' '--ma

How to repeat:
run 'make test'
[15 May 2003 5:11] Alexander Barkov
It does work for me under FreeBSD. I can't understand the reason of this problem.

To MySQL team: does anybody have Solaris I can try this on?
[22 May 2003 12:36] Per-Erik Martin
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

I was able to repeat this by omitting the "--with-extra-charsets=complex"
option when running ./configure. With this configure option, the ctype
tests pass.