summaryrefslogtreecommitdiff
path: root/test/dialect/mssql/test_compiler.py
diff options
context:
space:
mode:
authormike bayer <mike_mp@zzzcomputing.com>2020-09-12 16:26:28 +0000
committerGerrit Code Review <gerrit@bbpush.zzzcomputing.com>2020-09-12 16:26:28 +0000
commitf53e5fc7cb408f067d18e7f3eabf993bd1887063 (patch)
tree99783bd2ca0e15de08ac3eaf3529f0fdf233783e /test/dialect/mssql/test_compiler.py
parent34870a0f6e7052c784eba8ad639cb4d981a2cd41 (diff)
parent69502725db4829a84872697fd6569631d2a3c47f (diff)
downloadsqlalchemy-f53e5fc7cb408f067d18e7f3eabf993bd1887063.tar.gz
Merge "Reflect mssql/postgresql filtered/partial indexes"
Diffstat (limited to 'test/dialect/mssql/test_compiler.py')
-rw-r--r--test/dialect/mssql/test_compiler.py6
1 files changed, 6 insertions, 0 deletions
diff --git a/test/dialect/mssql/test_compiler.py b/test/dialect/mssql/test_compiler.py
index 04580b8fb..c3f12f9d9 100644
--- a/test/dialect/mssql/test_compiler.py
+++ b/test/dialect/mssql/test_compiler.py
@@ -1215,6 +1215,12 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
"CREATE INDEX test_idx_data_1 ON test (data) WHERE data > 1",
)
+ idx = Index("test_idx_data_1", tbl.c.data, mssql_where="data > 1")
+ self.assert_compile(
+ schema.CreateIndex(idx),
+ "CREATE INDEX test_idx_data_1 ON test (data) WHERE data > 1",
+ )
+
def test_index_ordering(self):
metadata = MetaData()
tbl = Table(