MySQL Bugs: #61690: Last NET Connector 6.3.7 don't work on VisualStudio 2008 Typed DataSet

Bug #61690	Last NET Connector 6.3.7 don't work on VisualStudio 2008 Typed DataSet
Submitted:	29 Jun 2011 14:47	Modified:	7 Jul 2011 13:07
Reporter:	Francesco Serafini	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.3.7	OS:	Windows (7)
Assigned to:	Julio Casal	CPU Architecture:	Any
Tags:	NET Connector 6.3.7, regression

Description:
After upgrade from 6.3.6 to 6.3.7 of NET Connector, my Typed Dataset won't work.
Every call to the TableAdapter GetData function, fail with message that object could not be found on database.

Seem a problem due to "`" chr.

The message is like 'Function "`theobjectname`" could not be found on database "`thedatabasename`".

How to repeat:
Install lastest connector and, in Visual Studio 2008, create a new Dataset.
In the designer, drag and drop TableAdapter, then configure to select data from a stored procedure.

From an event, create the tableadapter, then call GetData.

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

The provided steps will not reproduce the bug. Please provide a database script and a small Visual Studio solution where the issue appears consistently.

Thank you for your interest in MySQL.

Hello,
I'm unable to repeat every time same error.
Seem random failure.
Anyway I'm able to reproduce a error in this way:

Use this Sql statements

CREATE DATABASE `ciaobugtest`;

DELIMITER $$

CREATE PROCEDURE `ciaotest`()
BEGIN
  select 'ciao' as Ciao;
END$$

DELIMITER ;

Then create a VS2008 Windows Project,
add a dataset, configure a tableadapter
to select data from the stored procedure.
From a button event, create tableadapter,
then call function GetData twice. 
Second time no data are returned.

You can use the small project I uploaded.
thanks

Francesco

VS2008 Project to test bug

Attachment: CiaoBugTest.zip (application/x-zip-compressed, text), 101.01 KiB.

With new version 6.4.3, issue resolved.

Even when the original issue ("Every call to the TableAdapter GetData function, fail with message that object could notbe found on database.") does not happen anymore, the last issue you described ("then call function GetData twice. Second time no data are returned.") is still happening.

Working on the patch.

With NET Connector 6.4.3 and Server Version 5.5.14, calling GetData twice work as expected. I tested it.

True. However that's because of a couple code changes introduced in 6.3.7 that are missing in 6.4.3. Such code changes are required for some other scenarios and must be ported to 6.4. 

I'm porting the 6.3 code, with the new fix, to 6.4.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

Fixed in 6.3.8 and 6.4.4+.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html