Commits

Mike Bayer  committed 187db36

- changelog + test for pullreq #7, MSSQL dialect for DROP INDEX

  • Participants
  • Parent commits 2f18f9b
  • Branches rel_0_8

Comments (0)

Files changed (2)

File doc/build/changelog/changelog_08.rst

     :version: 0.8.4
 
      .. change::
+        :tags: bug, mssql
+        :versions: 0.9.0b2
+        :pullreq: bitbucket:7
+
+        Fixed bug introduced in 0.8.0 where the ``DROP INDEX``
+        statement for an index in MSSQL would render incorrectly if the
+        index were in an alternate schema; the schemaname/tablename
+        would be reversed.  The format has been also been revised to
+        match current MSSQL documentation.  Courtesy Derek Harland.
+
+     .. change::
         :tags: feature, sql
         :tickets: 1443
         :versions: 0.9.0b1

File test/dialect/mssql/test_compiler.py

             "CREATE INDEX bar ON foo (x > 5)"
         )
 
+    def test_drop_index_w_schema(self):
+        m = MetaData()
+        t1 = Table('foo', m,
+                Column('x', Integer),
+                schema='bar'
+            )
+        self.assert_compile(
+            schema.DropIndex(Index("idx_foo", t1.c.x)),
+            "DROP INDEX idx_foo ON bar.foo"
+        )
+
     def test_index_extra_include_1(self):
         metadata = MetaData()
         tbl = Table('test', metadata,