2007-09-11 Nagappan A <anagappan@novell.com>

[mono.git] / mcs / class / System.Data / Test / ProviderTests / System.Data.Odbc / OdbcDataReaderTest.cs

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 c18c230a681b3567de76488d8d0dda9f08e3358c..b93f57a16a7719fbb4fd0ad666bb6ed724160645 100644 (file)
--- a/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
+++ b/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
@@ -100,7 +100,7 @@ namespace MonoTests.System.Data
                        IDbConnection conn = new OdbcConnection (
                                                ConnectionManager.Singleton.ConnectionString);
                        try {
-                               ConnectionManager.Singleton.OpenConnection ();
+                               conn.Open ();
                                OdbcCommand cmd = new OdbcCommand ("create table odbcnodatatest (ID int not null, Val1 text)",
                                                                   (OdbcConnection) conn);
                                cmd.ExecuteNonQuery ();
@@ -113,6 +113,35 @@ namespace MonoTests.System.Data
                        }
                }
                
+               private static void DoExecuteNonQuery (OdbcConnection conn, string sql) {
+                       OdbcCommand cmd = new OdbcCommand (sql, conn);
+                       cmd.ExecuteNonQuery();
+               }
+  
+               private static void DoExecuteScalar(OdbcConnection conn, string sql) {
+                       OdbcCommand cmd = new OdbcCommand (sql, conn);
+                       cmd.ExecuteScalar();
+               }
+
+               [Test]
+               public void Bug82560Test ()
+               {
+                       IDbConnection conn = new OdbcConnection (
+                                               ConnectionManager.Singleton.ConnectionString);
+                       try {
+                               conn.Open ();
+                               DoExecuteNonQuery ((OdbcConnection) conn, "CREATE TABLE odbc_alias_test" + 
+                                                  "(ifld INT NOT NULL PRIMARY KEY, sfld VARCHAR(20))");
+                               DoExecuteNonQuery ((OdbcConnection) conn, "INSERT INTO odbc_alias_test" +
+                                                  "(ifld, sfld) VALUES (1, '1111')");
+                               DoExecuteScalar ((OdbcConnection) conn, "SELECT A.ifld FROM odbc_alias_test " +
+                                                "A WHERE A.ifld = 1");
+                               DoExecuteNonQuery ((OdbcConnection) conn, "DROP TABLE odbc_alias_test");
+                       }finally {
+                               conn.Close ();
+                       }
+               }
+
                [Test]
                public void FindZeroInToStringTest ()
                {