https://bugzilla.novell.com/show_bug.cgi?id=385029
Summary: Multple errors using Mysql Connector and DbCommandBuilder Product: Mono: Class Libraries Version: 1.9.0 Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: Sys.Data AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] QAContact: mono-bugs@lists.ximian.com Found By: --- This is a simple test program. It should work, but throws multiple exceptions. It requires a MySql database, you can change the connection string as needed. Initial setup: create table Mono (Num int primary key, word char(10) default 'pickle' not null, syn char(10) ); insert into Mono Values (0, "hello", NULL); The first test finds two bugs when performing updates. The second test finds a bug where default values are not used. Everything works with .NET. using System; using System.Data; using System.Data.SqlClient; using System.Data.Common; using MySql.Data.MySqlClient; static class TestMonoDB { static string connectionString = "Server=10.0.0.1;Database=monotest;user id=Mono;password=Mono;"; static void test1() { using (MySqlConnection db = new MySqlConnection(connectionString)) { db.Open(); string sql = "Select * From Mono;"; DataSet ds = new DataSet(); MySqlCommand cmd = new MySqlCommand(sql); cmd.Connection = db; MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds); MySqlCommandBuilder builder = new MySqlCommandBuilder(da); DataRow row = ds.Tables[0].Rows[0]; row[1] = "bam"; builder.DataAdapter.Update(new DataRow[] { row } ); db.Close(); } } static void test2() { using (MySqlConnection db = new MySqlConnection(connectionString)) { db.Open(); string sql = "Select * From Mono;"; DataSet ds = new DataSet(); MySqlCommand cmd = new MySqlCommand(sql); cmd.Connection = db; MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds); MySqlCommandBuilder builder = new MySqlCommandBuilder(da); DataRow row = ds.Tables[0].NewRow(); ds.Tables[0].Rows.Add(row); row[0] = 99; builder.DataAdapter.Update(new DataRow[] { row } ); Console.WriteLine("hello" + row[1]); db.Close(); } } static void Main() { try { test1(); } catch (Exception e) { Console.WriteLine("test1 failed: " + e); } try { test2(); } catch (Exception e) { Console.WriteLine("test2 failed: " + e); } } } -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. _______________________________________________ mono-bugs maillist - mono-bugs@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-bugs