MySQL Forums
Forum List  »  Stored Procedures

Re: Wrong results returned from select statement when it is insde a storedprocedure
Posted by: scott
Date: November 27, 2005 09:29PM

I found the problem. The problem is that, in the stored procedure, i had a variable that has the same as one of the columns of the target table. Since i was a fairly long stored procedure, i did not find that out. Well, as a suggestion, I think in this case, mysql should at least show some warning messages. (Oracle treats this situlation as selection from the table column, Mysql treats this situlation as selecting value from the variable. )

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Wrong results returned from select statement when it is insde a storedprocedure
1696
November 27, 2005 09:29PM


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.