Author: anagappan
Date: 2007-10-12 04:29:44 -0400 (Fri, 12 Oct 2007)
New Revision: 87372

Modified:
   trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/ChangeLog
   
trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
Log:
2007-10-12  Nagappan A  <[EMAIL PROTECTED]>

        * OdbcDataReaderTest.cs (Bug332400Test): Bug 332400 - ODBC and
          LONGBLOB columns. Thanks to Ernesto Carrea
          <[EMAIL PROTECTED]> for the patch and the test case.



Modified: 
trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/ChangeLog
===================================================================
--- trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/ChangeLog   
2007-10-12 08:24:22 UTC (rev 87371)
+++ trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/ChangeLog   
2007-10-12 08:29:44 UTC (rev 87372)
@@ -1,3 +1,9 @@
+2007-10-12  Nagappan A  <[EMAIL PROTECTED]>
+
+       * OdbcDataReaderTest.cs (Bug332400Test): Bug 332400 - ODBC and
+         LONGBLOB columns. Thanks to Ernesto Carrea
+         <[EMAIL PROTECTED]> for the patch and the test case.
+
 2007-09-11  Nagappan A  <[EMAIL PROTECTED]>
 
        * OdbcCommandBuilderTest.cs (DefaultPropertiesTest): QuotePrefix

Modified: 
trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
===================================================================
--- 
trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
       2007-10-12 08:24:22 UTC (rev 87371)
+++ 
trunk/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs
       2007-10-12 08:29:44 UTC (rev 87372)
@@ -216,6 +216,35 @@
                                ConnectionManager.Singleton.CloseConnection ();
                        }
                }
+               [Test]
+               public void Bug332400Test ()
+               {
+                       IDbConnection conn = 
ConnectionManager.Singleton.Connection;
+                       try {
+                               ConnectionManager.Singleton.OpenConnection ();
+                               System.Data.Odbc.OdbcCommand TempCmd;
+
+                               TempCmd = new 
System.Data.Odbc.OdbcCommand("DROP TABLE IF EXISTS blob_test");
+                               TempCmd.Connection = conn;
+                               TempCmd.ExecuteNonQuery();
+
+                               TempCmd = new 
System.Data.Odbc.OdbcCommand("CREATE TABLE blob_test (id_test INTEGER NOT NULL, 
payload LONGBLOB NOT NULL)");
+                               TempCmd.Connection = conn;
+                               TempCmd.ExecuteNonQuery();
+
+                               TempCmd = new 
System.Data.Odbc.OdbcCommand("INSERT INTO blob_test (id_test, payload) VALUES 
(1, 'test')");
+                               TempCmd.Connection = conn;
+                               TempCmd.ExecuteNonQuery();
+
+                               System.Data.Odbc.OdbcDataAdapter Adaptador = 
new System.Data.Odbc.OdbcDataAdapter();
+                               System.Data.DataSet Lector = new 
System.Data.DataSet();
+
+                               Adaptador.SelectCommand = new 
System.Data.Odbc.OdbcCommand("SELECT * FROM blob_test WHERE id_test=1", conn);
+                               Adaptador.Fill(Lector);
+                       } finally {
+                               ConnectionManager.Singleton.CloseConnection ();
+                       }
+        }
 #if NET_2_0 
                [Test]
                public void GetDataTypeNameTest ()

_______________________________________________
Mono-patches maillist  -  [email protected]
http://lists.ximian.com/mailman/listinfo/mono-patches

Reply via email to