With mysql-4.1.1-alpha, using any User Defined Function ( UDF) at the
query execution stage, on Linux 2.6, gave me the following error:
"ERROR 2013 (HY000): Lost connection to MySQL server during query"
However, upgrading to mysql-4.1.2-alpha seemed to solve the problem.
Both versions were configured exactly as follows
../configure --with-openssl --enable-thread-safe-client --with-mysqld-ldflags
=-rdynamic
The only way I could solve this was by upgrading to 4.1.2-alpha-log. Then,
recompiling the functions, drop the old UDF functions, then, recreate.
So far so good.
Anyway, if you run into this problem, or just want more detail on the sample
User Defined Functions that come with MySQL ( /sql/udf_example.cc), I've put
my notes in the following link ( TIP 27 )
http://prdownloads.sourceforge.net/s...l.txt?download
Regards,
Mike Chirico