MySQL Bugs: #6281: ExecuteReader() fail when find NULL values

Bug #6281	ExecuteReader() fail when find NULL values
Submitted:	27 Oct 2004 12:47	Modified:	28 Oct 2004 19:14
Reporter:	jorge beckhauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	1.0.0.22708	OS:	Windows (Windows XP)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
When use ExecuteReader to list a set of rows, after show a row with NULL values, all values subsequent from that row will show NULL.

How to repeat:
supous you have a table (one column to simplify) with following values:
john
peter
Andy
<NULL>
Mary
Bob
Karl
(Atention for <NULL> above)

let´s use a ExecuteReader... (make a connection and a command with SELECT * from table)

MySqlDataReader reader = cmd.ExecuteReader()
//on a loop...
while (reader.Read())
{
   Console.WriteLine(reader[0]);
}

you´ll see the follow list:
john
peter
Andy
<NULL>
<NULL>
<NULL>
<NULL>

Suggested fix:
no idea

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

This has been fixed.  Please download and try beta 2