[Mono-bugs] [Bug 76164][Nor] New - select count(*) from pub.TableName

[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=76164

--- shadow/76164	2005-09-20 10:25:12.000000000 -0400
+++ shadow/76164.tmp.23730	2005-09-20 10:25:12.000000000 -0400
@@ -0,0 +1,48 @@
+Bug#: 76164
+Product: Mono: Class Libraries
+Version: 1.1
+OS: Red Hat 7.1
+OS Details: Fedora Core
+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: select count(*) from pub.TableName
+
+Description of Problem:
+Following methods return incorrect result when sql query contains 
+pub.TableName':
+1) command.ExecuteScalar, sql="select count(*) from pub.EdTableName"
+2) command.ExecuteReader and odbcDataAdapter.Fill, sql=sql="select * from 
+pub.EdTableName"
+
+
+Steps to reproduce the problem:
+Create database in 'pub.' schema, fill with data and run following code:
+
+Dim connStr As String = "DSN=xxx;UID=xx;PWD=xx"
+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:
+Always nothing.
+
+Expected Results:
+Noumber of rows in table.
+
+Additional Information:
+Without 'pub.' prefix in table name the resuls are correct.