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

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

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

--- 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: 
+OS Details: SuSe 9.1
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: misc
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: dmcgowan@meiosys.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+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? 
+
+100%
+
+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.