[Mono-bugs] [Bug 57779][Maj] Changed - MySqlClient DataAdapter not returning all the rows

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Wed, 28 Apr 2004 12:38:14 -0400 (EDT)


Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by baenapablo@hotmail.com.

http://bugzilla.ximian.com/show_bug.cgi?id=57779

--- shadow/57779	2004-04-28 12:04:22.000000000 -0400
+++ shadow/57779.tmp.6881	2004-04-28 12:38:14.000000000 -0400
@@ -132,6 +132,64 @@
 
 </body>
 </html>
 
 ------- Additional Comments From gonzalo@ximian.com  2004-04-28 12:04 -------
 Not a sys.web bug
+
+------- Additional Comments From baenapablo@hotmail.com  2004-04-28 12:38 -------
+Yes, you're right. This is a smaller test case:
+
+
+using System;
+using System.Data;
+using ByteFX.Data.MySqlClient;
+
+public class Test
+{
+
+	
+    public static void Main () {
+		string connectionString = "server=localhost;database=roca;user
+id=roca;password=rocatest;";
+
+		MySqlConnection dbcon;
+		dbcon = new MySqlConnection(connectionString);
+		dbcon.Open();
+
+	    string sql = "SELECT numero, nombre FROM clietest";
+
+		MySqlDataAdapter adapter = new MySqlDataAdapter(sql, dbcon);
+		DataSet dataset = new DataSet ();
+		adapter.Fill (dataset);
+	
+		Console.WriteLine (dataset.GetXml ());
+
+    }
+
+}
+
+
+the database:
+
+CREATE TABLE clietest (
+  numero int(11) NOT NULL default '0',
+  nombre varchar(25) NOT NULL default ''
+) TYPE=MyISAM;
+
+
+INSERT INTO clietest VALUES (12412312,'fdsfsdfsdfs');
+INSERT INTO clietest VALUES (34534534,'xcvxcvxcvxv');
+INSERT INTO clietest VALUES (1413413,'dsvcvxcv');
+
+
+-----------------------------------------------------
+
+the output is:
+
+<NewDataSet>
+  <Table>
+    <numero>12412312</numero>
+    <nombre>fdsfsdfsdfs</nombre>
+  </Table>
+</NewDataSet>
+