Re: Stored procedure/function appears non-deterministic (and I'm going crazy)

[Jay Pipes]

Martin Aspeli wrote:
> It looks to me like IF() may not be thread-safe or
> something along those lines, which certainly
> sounds strange. Has anyone heard of any problems
> with this before?

I doubt that this is the reason for the issue. The IF() function is not thread-specific but rather operates on local values returned from the current resultset defined in the joins. So, what is more likely happening is an isolation level issue, where you are having implicit commits occurring. Could you post the exact *test case* you're using to reproduce the behaviour, now that we have the schema and function definition? Thanks, Martin!

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com