[Mono-devel-list] Difference behaviour between Mono and .NET

[Ben Maurer]

On Thu, 2005-08-04 at 09:38 +0700, Ernas M. Jamil wrote:
> I found there is difference behaviour between Mono and .NET on handling dataset
> that filled from joined query and does not have spesific primary key.
> 
> Here is my test case:
> 
> --------------------------------------
> String connectionString = null;
> MySqlConnection con;
> 
> try
> {
> 	connectionString =
> 		"Server=localhost;" +
> 		"Database=mysql;" +
> 		"User ID=user;" +
> 		"Password=password";
> 	con = new MySqlConnection(connectionString);
> 	MySqlDataAdapter myadapter = new MySqlDataAdapter("SELECT t0.* FROM
> user t0, db t1 WHERE t0.user = t1.user;",con);
> 
> 	con.Open ();
> 	DataTable dt = new DataTable();
> 	int count = myadapter.Fill(dt);
> 	Console.WriteLine("here count {0}",count);
> 	Console.WriteLine("here count {0}",dt.Rows.Count);
> 	con.Close();
> }
> catch (Exception e)
> {
> 	Console.WriteLine("exception {0}",e);
> 
> }
> --------------------------------------
> 
> On Mono, I got output from test program:
> 
> here count 11
> here count 6
> 
> But on .NET both lines has same number.
> 
> Anyone has idea what wrong with that, or I should filed that as bug ?

Sounds like a bug. Could you file it on bugzilla? What would be really
helpful is if you could reproduce it without a database connection. If
you are unable to do that, however, you should provide easy to follow
instructions on how to set up your database.

-- Ben