[Mono-bugs] [Bug 79170][Blo] Changed - 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 fxjrlists at yahoo.com.br.

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

--- shadow/79170	2006-08-25 20:11:52.000000000 -0400
+++ shadow/79170.tmp.10641	2006-08-26 18:26:13.000000000 -0400
@@ -73,6 +73,43 @@
 columns as the first table.  I will modify the test case to reflect that.
 
 ------- Additional Comments From mike.hull at coversant.net  2006-08-25 20:11 -------
 Created an attachment (id=17512)
 Simplified Test Case
 
+
+------- Additional Comments From fxjrlists at yahoo.com.br  2006-08-26 18:26 -------
+
+Hi Mike.
+
+I run your tests here. It seems LoadDataRow is getting confused with
+multiple resultsets. Or maybe Npgsql is making it so. :)
+
+I modified corlib do show me what value it was trying to convert to
+boolean and it seems that it was trying to convert the value from
+second resultset:
+
+Unhandled Exception: System.FormatException: Value is not equivalent
+to either TrueString or FalseString. teste  <=== This is what I added
+to be shown
+
+
+This is the data I have for testing:
+npgsql_tests=> select * from tbl_table1;
+ table1id | bool1
+----------+-------
+      101 | t
+      102 | f
+(2 rows)
+
+npgsql_tests=> select * from tbl_table2;
+ table2id | string1
+----------+---------
+      101 | teste
+      102 | teste2
+
+
+Note that teste is the first row of second resultset.
+
+I will have a look to see what can be happening.
+
+