MySQL Forums
Forum List  »  Stored Procedures

Wrong results returned from select statement when it is insde a storedprocedure
Posted by: scott
Date: November 26, 2005 10:18AM

Hi,

I am using MYSQL 5.0 production version.

I have been using MYSQL 5.0 for quite a while. For most part, it has been working fine. But recently, I have encountered one case that has caused a lot of frustration.

I get the wrong results from a particular select statement when it is inside a stored procedure. I found this out while debugging a stored procedure.

When I issue the select statement manually from the "Mysql command line" client, i get the correct results. I am not sure I can upload all the tables and stored procedures so that you guys can take a look at this issue as well.

but, has anyone seen a similar problem? if so, is there a work-around for this issue?

thanks a lot

Options: ReplyQuote


Subject
Views
Written By
Posted
Wrong results returned from select statement when it is insde a storedprocedure
2319
November 26, 2005 10:18AM


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.