Bug #1921 udf linkage fails on
Submitted: 23 Nov 2003 6:48 Modified: 28 Nov 2003 6:56
Reporter: Jason Pyeron Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: User-defined functions ( UDF ) Severity:S2 (Serious)
Version:mysql Ver 12.22 Distrib 4.0.16, for pc- OS:Linux (RedHat 9 Kernel 2.4.20-8 on an i)
Assigned to: CPU Architecture:Any

[23 Nov 2003 6:48] Jason Pyeron
Description:
see http://lists.blitzed.org/pipermail/services/2003-October/000891.html

it has to do with ld and static vs dynamic?

the documentation is horribly insufficient here.

rpmbuild --rebuild src.rpm (is the wrong approach/doesnt work )

How to repeat:
[jpyeron@server2 jpyeron]$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.16-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE FUNCTION diff RETURNS INTEGER SONAME "diff.so";
ERROR 2013: Lost connection to MySQL server during query
mysql> CREATE FUNCTION diff RETURNS INTEGER SONAME "diff.so";
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: *** NONE ***

ERROR 1126: Can't open shared library 'diff.so' (errno: 0 /lib/tls/libc.so.6: un
expected reloc type 0x0€$ôç¿_½)
mysql>

Suggested fix:

USE MySQL-Max RPM
[23 Nov 2003 6:52] Jason Pyeron
Annotate these sections to explain to use MySQL-Max or recompile MySQL with dynamic linking enabled.

13.2.2 Adding a New User-definable Function
13.2.2.5 Compiling and Installing User-definable Functions
[26 Nov 2003 11:55] Dean Ellis
The manual already includes this information.

Thank you.
[26 Nov 2003 15:38] Jason Pyeron
the information is not indexed
it is not easiliy serchable
nor are there links to sections which clearly point such information out.

would it be better if I provide a diff for you?
[28 Nov 2003 6:56] Dean Ellis
The second and third paragraphs of 13.2.2 "Adding a New User-definable Function" contain the information you suggested, which seems a logical enough place to have it.  Are you viewing the current version of the manual?

You are welcome to submit changes, but, as above, we do already have this information in the manual.