- The Index() construct can be created inline with a Table

definition, using strings as column names, as an alternative
to the creation of the index outside of the Table.

1 files changed, 37 insertions, 0 deletions

diff --git a/test/sql/test_constraints.py b/test/sql/test_constraints.py
index fb07bf437..4bacbd271 100644
--- a/test/sql/test_constraints.py
+++ b/test/sql/test_constraints.py
@@ -217,6 +217,43 @@ class ConstraintTest(TestBase, AssertsExecutionResults, AssertsCompiledSQL):
             dialect=dialect
         )
 
+    def test_index_declartion_inline(self):
+        t1 = Table('t1', metadata, 
+            Column('x', Integer),
+            Column('y', Integer),
+            Index('foo', 'x', 'y')
+        )
+        self.assert_compile(
+            schema.CreateIndex(list(t1.indexes)[0]), 
+            "CREATE INDEX foo ON t1 (x, y)"
+        )
+
+    def test_index_asserts_cols_standalone(self):
+        t1 = Table('t1', metadata, 
+            Column('x', Integer)
+        )
+        t2 = Table('t2', metadata,
+            Column('y', Integer)
+        )
+        assert_raises_message(
+            exc.ArgumentError,
+            "Column 't2.y' is not part of table 't1'.",
+            Index,
+            "bar", t1.c.x, t2.c.y
+        )
+
+    def test_index_asserts_cols_inline(self):
+        t1 = Table('t1', metadata, 
+            Column('x', Integer)
+        )
+        assert_raises_message(
+            exc.ArgumentError,
+            "Index 'bar' is against table 't1', and "
+            "cannot be associated with table 't2'.",
+            Table, 't2', metadata,
+                Column('y', Integer),
+                Index('bar', t1.c.x)
+        )
 
 class ConstraintCompilationTest(TestBase, AssertsCompiledSQL):