diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-12-26 22:41:44 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-12-26 22:41:44 +0000 |
| commit | bc5ad4e8afcdda269e0ec0d1c2fc40da13d2b999 (patch) | |
| tree | 9604e460a5d5cd330a45ac68911ceaf3f9bc22a2 /test/dialect/test_oracle.py | |
| parent | aa6f068a92cd7f62479b8555bf114053a5be31d6 (diff) | |
| download | sqlalchemy-bc5ad4e8afcdda269e0ec0d1c2fc40da13d2b999.tar.gz | |
merged r6570 from 0.5 branch, dont reflect IOT tables [ticket:1637]
Diffstat (limited to 'test/dialect/test_oracle.py')
| -rw-r--r-- | test/dialect/test_oracle.py | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/test/dialect/test_oracle.py b/test/dialect/test_oracle.py index 62721c399..98fce1655 100644 --- a/test/dialect/test_oracle.py +++ b/test/dialect/test_oracle.py @@ -527,6 +527,34 @@ class TypesTest(TestBase, AssertsCompiledSQL): t.drop(engine) +class DontReflectIOTTest(TestBase): + """test that index overflow tables aren't included in table_names.""" + + def setup(self): + testing.db.execute(""" + CREATE TABLE admin_docindex( + token char(20), + doc_id NUMBER, + token_frequency NUMBER, + token_offsets VARCHAR2(2000), + CONSTRAINT pk_admin_docindex PRIMARY KEY (token, doc_id)) + ORGANIZATION INDEX + TABLESPACE users + PCTTHRESHOLD 20 + OVERFLOW TABLESPACE users + """) + + def teardown(self): + testing.db.execute("drop table admin_docindex") + + def test_reflect_all(self): + m = MetaData(testing.db) + m.reflect() + eq_( + set(t.name for t in m.tables.values()), + set(['admin_docindex']) + ) + class BufferedColumnTest(TestBase, AssertsCompiledSQL): __only_on__ = 'oracle' |
