MySQL Bugs: #57499: Missing rows in DataTable when there are multiple line items

Bug #57499	Missing rows in DataTable when there are multiple line items
Submitted:	16 Oct 2010 17:11	Modified:	19 Nov 2010 6:59
Reporter:	Tony Tran	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	6.3.5	OS:	Windows (Visa)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	MySqlDataReader DataTable

Description:
When there are more than one lines in the order_line table, only one row is return instead of all of the lines.

How to repeat:
MySqlConnection myCon = null;
MySqlCommand myCommand = null;
MySqlDataReader dr = null;
DataTable dt = null;

myCon = new MySqlConnection( <insert connection string> );
myCon.Open();
myCommand = new MySqlCommand(
    @"select * 
        from order o
        inner join order_line l on o.order_id=l.order_id", myCon);

dr = myCommand.ExecuteReader();
dt = new DataTable();
dt.Load(dr);

Hi Tony and thanks for your report.

Please provide a full test case, along with connection string and database, if necessary, so I can check.

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".