2007-07-31 Nagappan A <anagappan@novell.com>

	* OdbcDataReaderTest.cs (Bug82135Test): ODBC SQLExecDirect
	error. Delete where no-data-found fails. Fixes bug # 82135.


svn path=/trunk/mcs/; revision=83056

1 files changed, 19 insertions, 0 deletions

diff --git a/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs b/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
index ee907cefb2c..c18c230a681 100644
--- a/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
+++ b/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
@@ -95,6 +95,25 @@ namespace MonoTests.System.Data
 		}
 		
 		[Test]
+		public void Bug82135Test ()
+		{
+			IDbConnection conn = new OdbcConnection (
+						ConnectionManager.Singleton.ConnectionString);
+			try {
+				ConnectionManager.Singleton.OpenConnection ();
+				OdbcCommand cmd = new OdbcCommand ("create table odbcnodatatest (ID int not null, Val1 text)",
+								   (OdbcConnection) conn);
+				cmd.ExecuteNonQuery ();
+				cmd = new OdbcCommand ("delete from odbcnodatatest", (OdbcConnection) conn);
+				Assert.AreEqual (0, cmd.ExecuteNonQuery ());
+				cmd = new OdbcCommand ("drop table odbcnodatatest", (OdbcConnection) conn);
+				cmd.ExecuteNonQuery ();
+			}finally {
+				conn.Close ();
+			}
+		}
+		
+		[Test]
 		public void FindZeroInToStringTest ()
 		{
 			IDbConnection conn = ConnectionManager.Singleton.Connection;