diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2020-09-12 16:26:28 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@bbpush.zzzcomputing.com> | 2020-09-12 16:26:28 +0000 |
| commit | f53e5fc7cb408f067d18e7f3eabf993bd1887063 (patch) | |
| tree | 99783bd2ca0e15de08ac3eaf3529f0fdf233783e /test/dialect/postgresql/test_compiler.py | |
| parent | 34870a0f6e7052c784eba8ad639cb4d981a2cd41 (diff) | |
| parent | 69502725db4829a84872697fd6569631d2a3c47f (diff) | |
| download | sqlalchemy-f53e5fc7cb408f067d18e7f3eabf993bd1887063.tar.gz | |
Merge "Reflect mssql/postgresql filtered/partial indexes"
Diffstat (limited to 'test/dialect/postgresql/test_compiler.py')
| -rw-r--r-- | test/dialect/postgresql/test_compiler.py | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/test/dialect/postgresql/test_compiler.py b/test/dialect/postgresql/test_compiler.py index ddf03daf1..30541ab06 100644 --- a/test/dialect/postgresql/test_compiler.py +++ b/test/dialect/postgresql/test_compiler.py @@ -454,7 +454,20 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): dialect=postgresql.dialect(), ) + idx3 = Index( + "test_idx2", + tbl.c.data, + postgresql_where="data > 'a' AND data < 'b''s'", + ) + self.assert_compile( + schema.CreateIndex(idx3), + "CREATE INDEX test_idx2 ON testtbl (data) " + "WHERE data > 'a' AND data < 'b''s'", + dialect=postgresql.dialect(), + ) + def test_create_index_with_ops(self): + m = MetaData() tbl = Table( "testtbl", |