Bug #16687 No data fetch - ERROR
Submitted: 20 Jan 2006 21:02 Modified: 21 Feb 2006 12:11
Reporter: Henning Viljoen Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1 OS:Windows (Windows 2003 Server EE)
Assigned to: CPU Architecture:Any

[20 Jan 2006 21:02] Henning Viljoen 
Description:
Experiencing "No data to fetch" - error when inserting data into a table which has a "INSERT TRIGGER", from a windows .NET service (Using ADODB Connection).

However - executing the exact same sql query from SQLyog / mysql Admin - no errors are returned.

How to repeat:
Create a trigger which fires upon a "after insert" command, within the trigger add a couple of select & update queries (I made use of a couple of 'IF' statements)

Now from within asp.net / vb.net (with adodb) try and insert data into the table with the trigger. You will receive a 'no data to fetch' error
[21 Jan 2006 12:11] Valeriy Kravchuk 
Thank you for a problem report. Please, provide the exact test case - a sequence of statements/actions needed to repeat the behaviour you described. If you think it is a server bug, please, use mysql command like client. If the problem is repeatable only through .NET, please, specify the exact MySQL Connector/Net version used.
[22 Feb 2006 0:00] Bugs System 
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".