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

[Martin Aspeli]

We may have solved this now ... it's certainly quite strange. If you look at the testVehicleByRule() function, you'll see:

SELECT IF(COUNT(*)=0, True, False)

...

INTO retn;
RETURN retn;

Now, if we rewrite that as:

SELECT COUNT(*)

...

INTO cnt;
IF cnt = 0 THEN
RETURN True;
ELSE
RETURN False;

Suddenly it works reliably again.

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?

Martin