MySQL Bugs: #61671: stored procedures not found on 6.3.7.0

Bug #61671	stored procedures not found on 6.3.7.0
Submitted:	28 Jun 2011 13:34	Modified:	7 Jul 2011 13:10
Reporter:	kamel Fahd	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.3.7	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	.Net connector bug, 6.3.7.0

Description:
Hi,
I was using .Net connector 6.3.5.0 ,and then I updated to 6.3.7.0.
But after the update ,it is giving "stored procedures not found"
for some stored procedures

How to repeat:
This error for some stored procedures and it is not clear for me.

We'll need a bit more information to diagnose this problem.

when I execute any storedprocedure it is giving not found for the first time,but if call it again,it works fine.

if you need more info,please specify it

more details:
-This only when using executeNoQuery.
-To solve it temporary at my side ,I added a stored procedure which do nothing.
Then all others work fine.

Please provide reproduction steps for this bug, plus a sample database schema and a small Visual Studio project where the issue appears.

mysql db

Attachment: 110703154056.psc (application/octet-stream, text), 358 bytes.

Database and Visual basic sample

Attachment: mysqlconnector.rar (application/octet-stream, text), 181.43 KiB.

I'm able to figure out the problem.
This problem happen when there using dataadapter before executenonquery.

I attached the visual basic sample + database

ka ka, would you provide your database as a .sql script? I don't know how to extract your database from that .psc file.

Database Sql file

Attachment: test.sql (application/octet-stream, text), 1.27 KiB.

Hi,

I uploaded as requested.
FYI:
.psc you can use with Navicat Preminum software.

The root cause of this bug is the same as in bug #61690.