Bug #37523 Create procedures failing on Mac OS 10.5 using PPC 10.4 binaries

• Submitted: 19 Jun 2008 12:24
• Modified: 19 Jun 2008 13:45
• Reporter: Geert Vanderkelen
• Status: Not a Bug
• Category: MySQL Server: Stored Routines
• Severity: S3 (Non-critical)
• Version: 5.1.25
• OS: MacOS (10.5 (PowerPC))
• CPU Architecture: Any

[19 Jun 2008 12:24] Geert Vanderkelen

Description:
Quite odd, but CREATE PROCEDURE is failing on my Apple PowerBook (PowerPC) running Mac OS 10.5, using MySQL binaries compiled on 10.4. The rest seems to work OK.

$ file /usr/local/mysql/bin/mysqld
/usr/local/mysql/bin/mysqld: Mach-O executable ppc
silver:~ geert$ ls -ld /usr/local/mysql
lrwxr-xr-x  1 root  wheel  32 Jun  9 16:55 /usr/local/mysql -> mysql-5.1.25-rc-osx10.4-powerpc/

Running the same CREATE PROCEDURE statement on my iMac with Intel Mac OS 10.5, works fine. Elsewhere too..

How to repeat:
Example from our manual:

DROP PROCEDURE IF EXISTS simpleproc;
delimiter //
CREATE PROCEDURE simpleproc (OUT param1 INT)
BEGIN
 SELECT 'asdfasf';
END;
//
delimiter ;

Gives:

ERROR 1307 (HY000) at line 4: Failed to CREATE PROCEDURE simpleproc

[19 Jun 2008 12:43] Geert Vanderkelen

All on PowerPC:
* Not reproducible with 5.0.62 compiled for Mac OS 10.4, running on Mac OS 10.5.
* Not reproducible with 5.1.25 compiled on Mac OS 10.5.
* Reproducible using 5.1.25 compiled for Mac OS 10.4, running on Mac OS 10.5.

On intel Mac, running 10.4 binaries on Mac OS 10.5 works fine too.

Don't know what this is about.. but it doesn't sound correct that it fails like that.
I'll leave it to 'Open' for now.

[19 Jun 2008 13:37] Susanne Ebrecht

How did you install MySQL 5.1.25?

[19 Jun 2008 13:45] Geert Vanderkelen

Was about to close it.

./bin/mysql_upgrade

And apparently the definition of the mysql.proc changed or something.

It could tell something smarter. :)