- add an additional fix to the MySQL fixes for re: #103.

1 files changed, 9 insertions, 0 deletions

diff --git a/tests/test_mysql.py b/tests/test_mysql.py
index f598d99..16b171c 100644
--- a/tests/test_mysql.py
+++ b/tests/test_mysql.py
@@ -90,6 +90,8 @@ class MySQLOpTest(TestCase):
             'ALTER TABLE t ALTER COLUMN c DROP DEFAULT'
         )
 
+
+
     def test_alter_column_modify_default(self):
         context = op_fixture('mysql')
         # notice we dont need the existing type on this one...
@@ -127,6 +129,13 @@ class MySQLOpTest(TestCase):
             "ALTER TABLE t1 MODIFY c1 INTEGER NOT NULL DEFAULT 'q'"
         )
 
+    def test_alter_column_multi_alter_w_drop_default(self):
+        context = op_fixture('mysql')
+        op.alter_column('t1', 'c1', nullable=False, server_default=None, type_=Integer)
+        context.assert_(
+            "ALTER TABLE t1 MODIFY c1 INTEGER NOT NULL"
+        )
+
     def test_col_alter_type_required(self):
         op_fixture('mysql')
         assert_raises_message(