[Mono-bugs] [Bug 76372][Nor] New - Sqlite program hangs when using parameters

[bugzilla-daemon at bugzilla.ximian.com]

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 nazgul at omega.pl.

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: mono-bugs at ximian.com                            
+ReportedBy: nazgul at omega.pl               
+QAContact: mono-bugs at ximian.com
+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: