[Mono-bugs] [Bug 71492][Nor] New - OdbcDataAdapter fails on sub queries

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Wed, 19 Jan 2005 17:54:45 -0500 (EST)

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 dmcgowan@meiosys.com.


--- shadow/71492	2005-01-19 17:54:45.000000000 -0500
+++ shadow/71492.tmp.5431	2005-01-19 17:54:45.000000000 -0500
@@ -0,0 +1,47 @@
+Bug#: 71492
+Product: Mono: Runtime
+Version: 1.0
+OS Details: SuSe 9.1
+Status: NEW   
+Priority: Normal
+Component: misc
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: dmcgowan@meiosys.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+Summary: OdbcDataAdapter fails on sub queries
+Please fill in this template when reporting a bug, unless you know what 
+you are doing.
+Description of Problem:
+Steps to reproduce the problem:
+1. Create a query like "SELECT * FROM tablename WHERE id NOT IN (1,2,3);
+2. Try this using a the OdbcDataAdapter.
+3. It will return a table with no rows!
+Actual Results:
+A table with no rows.
+Expected Results:
+A table with rows.
+How often does this happen? 
+Additional Information:
+I've worked around this by using the ByteFX adapter but for various 
+reasons we want to use the OdbcDataAdapter. The ByteFX workaround I 
+discovered today creates an issue in another part of our system that I'm 
+trying to track down now.