MySQL Bugs: #66255: use procedure bodies = true is not using mysql.proc table

Bug #66255	use procedure bodies = true is not using mysql.proc table
Submitted:	8 Aug 2012 8:10	Modified:	9 Sep 2012 16:48
Reporter:	D Srinivas	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	6.0.27	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
use procedure bodies = true is not using mysql.proc table while calling stored procedures. It is still using I_S table. User account is root.

How to repeat:
1. .NET connector 6.0.27 using stored procedures. In web.config give "use procedure bodies=true" along with the connection string which is the default value still it is fetching I_S table which it suppose to fetch from mysql.proc 

2. There are other Sub-Domains in the same box which are using default value, I mean I did not mention "use procedure bodies = true" explicitly. 

3. But the Stored Procedure belongs to 1., I mean it belongs to the Sub-Domain in which I have mentioned the option along with the connection string.

Suggested fix:
No Idea. Please let me know.

Hi, 

Please note the last production version of Connector/NET currently available is 6.5.4.

We no longer officially support your version of Connector/NET (6.0.27), however will try to help, is there some reason why you cannot update to a latest version (either 6.4.4 or 6.5.4)?

By the way, in the latest versions the "Use Procedure Bodies" connection string option is deprecated and has no effect, you can get a similar effect using "Check Parameters".

Thanks.

We tried with next version of .Net Connector 6.1.0 but there was some connection issue in our code we were getting error and then we tried with the version 6.0.27. That's why we are asking about this.

In otherwise we will go for the latest version as you said but we did not try this anyways. One more thing I wanted to tell you that our MySQL version is 5.0.27 and .Net 2.0 will the .Net Connector you said support these versions.

If yes, we will try. Otherwise please help us.

Hi,

Yes, we still support .NET 2.0 & MySql Server 5.0.x (for more details on all versions supported see http://dev.mysql.com/doc/refman/5.0/en/connector-net-versions.html).

You can get the latest Connector/NET version from
http://dev.mysql.com/downloads/connector/net/

For Visual Studio 2005 support, the connector 6.4.5 is recommended.

Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".