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 [EMAIL PROTECTED] http://bugzilla.ximian.com/show_bug.cgi?id=76372 --- shadow/76372 2005-10-08 10:57:44.000000000 -0400 +++ shadow/76372.tmp.6811 2005-10-08 10:57:44.000000000 -0400 @@ -0,0 +1,77 @@ +Bug#: 76372 +Product: Mono: Class Libraries +Version: 1.0 +OS: +OS Details: mono 1.1.9 +Status: NEW +Resolution: +Severity: +Priority: Normal +Component: Sys.Data.SqlClient +AssignedTo: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +TargetMilestone: --- +URL: +Cc: +Summary: Sqlite program hangs when using parameters + +Please fill in this template when reporting a bug, unless you know what you +are doing. +Description of Problem: +Program using SqliteClient enters infinite loop + + +Steps to reproduce the problem: +1. Compile following program with +mcs sqlite.cs -r:Mono.Data.SqliteClient.dll -r:System.Data + + using System; + using System.Data; + using Mono.Data.SqliteClient; + + public class Test + { + public static void Main(string[] args) + { + string connectionString = "URI=file://SqliteTest.db"; + SqliteConnection dbcon; + dbcon = new SqliteConnection(connectionString); + dbcon.Open(); + + string sql = "SELECT firstname, lastname FROM employee WHERE +firstname = @parm"; + + SqliteCommand dbcmd = new SqliteCommand(sql, dbcon); + + dbcmd.Parameters.Add ("parm", DbType.String).Value = "Kamil"; + + IDataReader reader = dbcmd.ExecuteReader(); + while(reader.Read()) { + string FirstName = (string) reader[0]; + string LastName = (string) reader[1]; + Console.WriteLine("Name: " + + FirstName + " " + LastName); + } + // clean up + reader.Close(); + reader = null; + dbcmd.Dispose(); + dbcmd = null; + dbcon.Close(); + dbcon = null; + } + } + +2. mono sqlite.exe + +Actual Results: +Hangs + +Expected Results: +clear run + +How often does this happen? +Always + +Additional Information: _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
