From 910347aef28f662a1f183936624f6f193d87ee6d Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 20 Dec 2016 09:15:55 -0500 Subject: [PATCH] Bump "table compression" flag to Oracle 10.1 - Fixed bug where the "COMPRESSION" keyword was used in the ALL_TABLES query on Oracle 9.2; even though Oracle docs state table compression was introduced in 9i, the actual column is not present until 10.1. Change-Id: Iebfa59bfcfdff859169df349a5426137ab006e67 Fixes: #3875 --- doc/build/changelog/changelog_11.rst | 9 +++++++++ lib/sqlalchemy/dialects/oracle/base.py | 2 +- 2 files changed, 10 insertions(+), 1 deletion(-) diff --git a/doc/build/changelog/changelog_11.rst b/doc/build/changelog/changelog_11.rst index 27417a6792..2314a621d2 100644 --- a/doc/build/changelog/changelog_11.rst +++ b/doc/build/changelog/changelog_11.rst @@ -21,6 +21,15 @@ .. changelog:: :version: 1.1.5 + .. change:: 3875 + :tags: bug, oracle + :tickets: 3875 + + Fixed bug where the "COMPRESSION" keyword was used in the ALL_TABLES + query on Oracle 9.2; even though Oracle docs state table compression + was introduced in 9i, the actual column is not present until + 10.1. + .. change:: 3874 :tags: bug, orm :tickets: 3874 diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py index 87e1004107..e4e5d7ac1a 100644 --- a/lib/sqlalchemy/dialects/oracle/base.py +++ b/lib/sqlalchemy/dialects/oracle/base.py @@ -1026,7 +1026,7 @@ class OracleDialect(default.DefaultDialect): @property def _supports_table_compression(self): return self.server_version_info and \ - self.server_version_info >= (9, 2, ) + self.server_version_info >= (10, 1, ) @property def _supports_table_compress_for(self): -- 2.47.2