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=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: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +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: _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
