[Mono-bugs] [Bug 76110][Nor] New - Database actions fail when table is in "pub.TableName" schema

[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 spek at impaq.com.pl.

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

--- shadow/76110	2005-09-15 04:13:37.000000000 -0400
+++ shadow/76110.tmp.5374	2005-09-15 04:13:37.000000000 -0400
@@ -0,0 +1,53 @@
+Bug#: 76110
+Product: Mono: Class Libraries
+Version: 1.1
+OS: Red Hat 7.1
+OS Details: Fedora Core 3
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: spek at impaq.com.pl               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Database actions fail when table is in "pub.TableName" schema
+
+Description of Problem:
+Following methods return incorrect result when sql query contains 
+pub.TableName':
+1) command.ExecuteScalar, sql="select count(*) from pub.TableName"
+2) command.ExecuteReader and odbcDataAdapter.Fill, sql=sql="select * from 
+pub.TableName"
+
+Steps to reproduce the problem:
+Create database in 'pub.' schema. For sample table see #75944.
+Execute program:
+Dim connStr As String = "DSN=xxx;UID=xx;PWD="
+Dim sqlStr As String = "select count(*) from pub.EdTableName"
+
+Dim conn As IDbConnection = New OdbcConnection(connStr)
+conn.Open()
+Dim command As IDbCommand = conn.CreateCommand()
+command.CommandText = sqlStr
+
+Dim result As Object = command.ExecuteScalar()
+Console.WriteLine("ExecuteScalar, result: " & result)
+
+
+Actual Results:
+I receiving different results when program runs and when I executing sql 
+in SQL Explorer
+
+Expected Results:
+Results have to be the same
+
+How often does this happen? 
+Very often, especially when table contains at least 10000 records
+
+Additional Information:
+Without 'pub.' prefix in table name the resuls are correct. So when I 
+performing db actions on table when access is directly results are OK.