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

bugzilla-daemon at bugzilla.ximian.com bugzilla-daemon at bugzilla.ximian.com
Tue Sep 20 10:25:12 EDT 2005

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.


--- 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   
+Priority: Normal
+Component: Sys.Data
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: spek at impaq.com.pl               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+Summary: select count(*) from pub.TableName
+Description of Problem:
+Following methods return incorrect result when sql query contains 
+1) command.ExecuteScalar, sql="select count(*) from pub.EdTableName"
+2) command.ExecuteReader and odbcDataAdapter.Fill, sql=sql="select * from 
+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)
+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.

More information about the mono-bugs mailing list