MySQL Forums
Forum List  »  Stored Procedures

Re: SELECT id, myFunc(id) FROM aTable ORDER BY id; returns bad data
Posted by: Mitch Stone
Date: September 28, 2005 10:24AM

Roland Bouman wrote:
> so i don't think you can conclude that EXISTS is buggy

... okay, after wrapping my brain around it, I see what you mean. Since COUNT(*) ~always~ returns a row, and EXISTS ~always~ evaluates to true only when data is returned, it's evaluating the SELECT statement inside the IF statement regaradless of the parameter passed in. I guess I have some bug fixes after all.


> Cut short, try these, and tell me what you think....

I get the same wonky behavior.


> Mitch, are you going to report your bug? If so, could
> you post the id? I'd like to subscribe.

http://bugs.mysql.com/bug.php?id=13575

Thanks for the insight,
Mitch

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.