polymorphism alternative for MySQL stored procedures

Question

I'm porting some stored procedures from Informix to MySQL, but I have two stored procedures on Informix that have same name and different parameters.

In MySQL, I can't create two SP with the same name, and also can't create a SP with default values in parameters.

so, do someone out there know any hackery or black magic that may help me solve this problem?

thanks.

Answer 1

We had the same problem porting a number crunching app from informix to mysql.

The problem was 'solved' by adding the parameter count to the procedure name...

INFORMIX                     MySQL
-------------------------    ---------------------------
min(int a, int b)         => min2(int a, int b)
min(int a, int b, int c)  => min3(int a, int b, int c)

This worked because the calling application (Perl Scripts) always knew exactly how many parameters there were ..