Bug #11086 configure --with-charset --with-collation hinibit stored procedures

• Submitted: 3 Jun 2005 21:28
• Modified: 4 Jun 2005 17:00
• Reporter: Francesco Riosa
• Status: Can't repeat
• Category: MySQL Server: Compiling
• Severity: S2 (Serious)
• Version: 5.0.x
• OS: Linux (Linux)
• CPU Architecture: Any

[3 Jun 2005 21:28] Francesco Riosa

Description:
Compiling with the mentioned options produce a mysql server that crash when stored procedures /function are used.

symptoms:
- mysql_create_system_tables
CREATE TABLE mysql.proc->sql_mode fail to accept the default "0" , "" (empty string)  must be used instead.

- when the previous is manually fixed the testsuite fails on the following tests:
mysql_client_test
ps
rpl_rotate_logs
rpl_sp
schema
show_check
sp-error
sp-security
sp-threads
sp
sp_trans
strict
system_mysql_db
type_newdecimal
view

generally with error 2013 (CR_SERVER_LOST)

The previous has been verified using a amd duron (x86), with various CXXFLAGS, gcc, glibc, kernel-headers combination.

How to repeat:
#./configure --with-charset=utf8 --with-collation=utf8_general_ci
||
#./configure --with-charset=latin1 --with-collation=latin1_swedish_ci
make && make test

Suggested fix:
Disable --with-charset, --with-collation, leave this a run-time only option.

[4 Jun 2005 16:46] Jorge del Conde

I was unable to reproduce this bug:

I compiled mysql as:

root-mysql/mysql-test# ./configure --with-charset=latin1 --with-collation=latin1_swedish_ci ; make ; make test

and then tested all of the tests that you said failed.  All of them passed without problems.  I used 5.0.6 src to test this bug.