Cant create C/C++ UDF in mysql-5.0.0a-alpha-win (win2k/winXP)

Hi,

I cannot create C/C++ UDFs for mysql-5.0.0a-alpha-win
(binary distro) on Win2k & WinXP.

I can create them OK on mysql-4.0.18-win.zip &
mysql-4.1.1a-alpha.
(OSs have up-to-date service packs).

You can recreate the problem with:

mysql> create function no_such_function returns string
soname "no_such_dll.dll"

[root] ERROR 1125: Function 'no_such_function' already exist



There are definitely no functions defined;
'SELECT * FROM func' returns null.

You don't even need to have a real DLL, the error must at a very
early stage.
If I try the 'create function' using a real dll, (one which successfully
loads into mysql 4/4.1) I get the same problem.

I tried tracking it down, the files with the error message
1125 ER_UDF_EXISTS are sql_parse.cpp & sql_udf.cpp,
But couldn't go any further without actually building the source.

Regards,


Mike Pheasant.



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Cant create C/C++ UDF in mysql-5.0.0a-alpha-win (win2k/winXP)

Hi!

See http://bugs.mysql.com/bug.php?id=2485
This bug is already fixed, the bugfix will come in 5.0.1

On Mar 24, m.pheasant wrote:
> Hi,
>
> I cannot create C/C++ UDFs for mysql-5.0.0a-alpha-win
> (binary distro) on Win2k & WinXP.
>
> I can create them OK on mysql-4.0.18-win.zip &
> mysql-4.1.1a-alpha.
> (OSs have up-to-date service packs).
>
> You can recreate the problem with:
>
> mysql> create function no_such_function returns string
> soname "no_such_dll.dll"
>
> [root] ERROR 1125: Function 'no_such_function' already exist
>
> There are definitely no functions defined;
> 'SELECT * FROM func' returns null.
>
> You don't even need to have a real DLL, the error must at a very
> early stage.
> If I try the 'create function' using a real dll, (one which successfully
> loads into mysql 4/4.1) I get the same problem.
>
> I tried tracking it down, the files with the error message
> 1125 ER_UDF_EXISTS are sql_parse.cpp & sql_udf.cpp,
> But couldn't go any further without actually building the source.
>
Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org