[Mono-bugs] [Bug 75220][Wis] New - OdbcDataReader hang

[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 ndo at rockwellcollins.com.

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

--- shadow/75220	2005-06-10 14:56:40.000000000 -0400
+++ shadow/75220.tmp.30478	2005-06-10 14:56:40.000000000 -0400
@@ -0,0 +1,77 @@
+Bug#: 75220
+Product: Mono: Class Libraries
+Version: 1.1
+OS: 
+OS Details: SuSE 9.2
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Data
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: ndo at rockwellcollins.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: OdbcDataReader hang
+
+Please fill in this template when reporting a bug, unless you know what 
+you are doing. 
+Description of Problem: 
+ 
+I've Mono1.1.7 installed. Using MySQL 4.1.11 with UnixODBC-3.51. 
+I've a table setup with compound primary key of two fields. 
+I've have the following query string 
+SELECT DISTINCT tbfontdefaultcategory.FontId FROM tbfontdefaultcategory  
+UNION SELECT DISTINCT tbfontdefaultcategory.SphereFontId FROM 
+tbfontdefaultcategory 
+ 
+the tbfontdefaultcategory.FontId and tbfontdefaultcategory.SphereFontId 
+are not the primary key in this table. 
+ 
+this is the code to exercise the above: 
+string dbConnStr = 
+"DRIVER={mysqlodbc};SERVER=localhost;DATABASE=asxnet;USER=root;OPTION=3;"; 
+string selectCmd = "SELECT DISTINCT tbfontdefaultcategory.FontId FROM 
+tbfontdefaultcategory UNION SELECT DISTINCT 
+tbfontdefaultcategory.SphereFontId FROM tbfontdefaultcategory"; 
+			 
+try 
+{ 
+     Console.WriteLine("Main(1)"); 
+     OdbcConnection conn = new OdbcConnection(dbConnStr); 
+     OdbcCommand cmd = new OdbcCommand(selectCmd, conn); 
+ 
+     conn.Open(); 
+     OdbcDataReader reader = cmd.ExecuteReader(); 
+     while(reader.Read()) 
+     { 
+	int fontIdPos = reader.GetOrdinal("FontId"); 
+	int fontId = !reader.IsDBNull(fontIdPos) ? (int)reader.GetInt32
+(fontIdPos) : -1; 
+     } 
+} 
+catch(Exception e) 
+{ 
+     Console.WriteLine("Main Exception={0}",e.Message); 
+} 
+			 
+The program hang in OdbcDataReader().  
+ 
+ 
+Steps to reproduce the problem: 
+1.  
+2.  
+3.  
+ 
+Actual Results: 
+ 
+ 
+Expected Results: 
+ 
+ 
+How often does this happen?  
+ 
+ 
+Additional Information: