[Mono-bugs] [Bug 79170][Wis] New - DataAdapter + Npgsql + setof refcursor Fails

[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 mike.hull at coversant.net.

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

--- shadow/79170	2006-08-25 18:54:53.000000000 -0400
+++ shadow/79170.tmp.28810	2006-08-25 18:54:53.000000000 -0400
@@ -0,0 +1,64 @@
+Bug#: 79170
+Product: Mono: Class Libraries
+Version: unspecified
+OS: All
+OS Details: Confirmed on Windows & Linux
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Data
+AssignedTo: tsenganal at novell.com                            
+ReportedBy: mike.hull at coversant.net               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: DataAdapter + Npgsql + setof refcursor Fails
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+When using Npgsql to call a stored procedure that returns multiple
+datatables in a similar configuration to the attached example the
+DataAdapter fails to fill the DataSet.
+
+Steps to reproduce the problem:
+1. Compile MultipleDataTables.cs using "gmcs MultipleDataTables.cs
+-r:System.Data -r:Npgsql"
+2. Execute "mono MultipleDataTables.exe create" to create the database and
+insert sample data.
+3. Execute "mono MultipleDataTables.exe test" to run the attached test.
+Press any key to exit.
+4. Execute "mono MultipleDataTables.exe drop" to drop the database.
+
+Actual Results:
+
+Unhandled exception: System.FormatException: Value is not equivalent to
+either TrueString or FalseString.
+  at System.Boolean.Parse (System.String value) [0x00000]
+  at System.Convert.ToBoolean (System.String value, IFormatProvider
+provider) [0x00000]
+  at System.String.System.IConvertible.ToBoolean (IFormatProvider provider)
+[0x00000]
+  at System.Convert.ToBoolean (System.Object value, IFormatProvider
+provider) [0x00000]
+  at System.Convert.ToBoolean (System.Object value) [0x00000]
+  at System.Data.Common.AbstractDataContainer+BitDataContainer.set_Item
+(Int32 index, System.Object value) [0x00000]
+  at
+System.Data.Common.AbstractDataContainer+BitDataContainer.SetItemFromDataRecord
+(Int32 index, IDataRecord record, Int32 field) [0x00000]
+  at System.Data.Common.RecordCache.ReadIDataRecord (Int32 recordIndex,
+IDataRecord record, System.Int32[] mapping, Int32 length) [0x00000]
+  at System.Data.DataTable.LoadDataRow (IDataRecord record, System.Int32[]
+mapping, Int32 length, Boolean fAcceptChanges) [0x00000]
+
+Expected Results:
+This test outputs the xml of the dataset to show the data.
+
+How often does this happen? 
+Every time.
+
+Additional Information: