- sqlite dialect properly generates CREATE INDEX for a table

that is in an alternate schema.  [ticket:1439]

1 files changed, 13 insertions, 1 deletions

diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py
index 2d5cb1805..7fced60d9 100644
--- a/test/dialect/test_sqlite.py
+++ b/test/dialect/test_sqlite.py
@@ -69,7 +69,7 @@ class TestTypes(TestBase, AssertsExecutionResults):
 
             bindproc = t.dialect_impl(dialect).bind_processor(dialect)
             assert not bindproc or isinstance(bindproc(u"some string"), unicode)
-        
+
     def test_type_reflection(self):
         # (ask_for, roundtripped_as_if_different)
         specs = [( String(), String(), ),
@@ -324,6 +324,18 @@ class DialectTest(TestBase, AssertsExecutionResults):
             isolation_level="FOO")
 
 
+    def test_create_index_with_schema(self):
+        """Test creation of index with explicit schema"""
+
+        meta = MetaData(testing.db)
+        t = Table('foo', meta, Column('bar', String, index=True), schema='main')
+
+        try:
+            meta.create_all()
+        finally:
+            meta.drop_all()
+
+
 class SQLTest(TestBase, AssertsCompiledSQL):
     """Tests SQLite-dialect specific compilation."""