MySQL Bugs: #7612: MySqlDataReader.GetString(index) returns non-Null value when field is Null

Bug #7612	MySqlDataReader.GetString(index) returns non-Null value when field is Null
Submitted:	2 Jan 2005 5:19	Modified:	5 Jan 2005 19:38
Reporter:	Steven Toth
Status:	Closed
Category:	Connector/Net	Severity:	S2 (Serious)
Version:	1.0.3-gamma	OS:	Microsoft Windows (Windows XP)
Assigned to:	Reggie Burnett	Target Version:

Description:
MySqlDataReader.GetString(index) returns non-Null value when the field is Null.  I have a
resultset being generated from a SELECT statement that returns a String field that is
defined as NULLABLE.  Row 3 in the resultset has a non-NULL value in the field.  Every
consectutive row in the resultset after row 3 that has a NULL value for the field in the
database returns the non-NULL value (from row 3) instead of a NULL.  The IsDBNull method
correctly returns TRUE for the fields that should be NULL even though the GetString
method returns a non-NULL value.  The SELECT statement generates the correct output when
run from the MySql Command Line Client.

How to repeat:
Generate a resultset from a table with a NULLABLE VARCHAR column with a row with a
non-NULL value and a subsequent row with a NULL value.  The MySqlDataReader.GetString
will return the non-NULL value for NULL value row.

Suggested fix:
Have the GetString return a NULL value.

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.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html