diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-04-26 18:31:05 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-04-26 18:31:05 -0400 |
| commit | 893f8de6dfc149903ad1a746441a27458e8eeb22 (patch) | |
| tree | 2fc985379e77f316eeede05b0fb7dee36d0cdb70 /lib/sqlalchemy/dialects/firebird/base.py | |
| parent | 4c87fb761379348475bcea09a1293eb1dddc6544 (diff) | |
| download | sqlalchemy-893f8de6dfc149903ad1a746441a27458e8eeb22.tar.gz | |
- Added a label to the query used within has_table() and
has_sequence() to work with older versions of Firebird
that don't provide labels for result columns. [ticket:1521]
Diffstat (limited to 'lib/sqlalchemy/dialects/firebird/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/firebird/base.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/sqlalchemy/dialects/firebird/base.py b/lib/sqlalchemy/dialects/firebird/base.py index 70318157c..498080039 100644 --- a/lib/sqlalchemy/dialects/firebird/base.py +++ b/lib/sqlalchemy/dialects/firebird/base.py @@ -358,7 +358,7 @@ class FBDialect(default.DefaultDialect): """Return ``True`` if the given table exists, ignoring the `schema`.""" tblqry = """ - SELECT 1 FROM rdb$database + SELECT 1 AS has_table FROM rdb$database WHERE EXISTS (SELECT rdb$relation_name FROM rdb$relations WHERE rdb$relation_name=?) @@ -370,7 +370,7 @@ class FBDialect(default.DefaultDialect): """Return ``True`` if the given sequence (generator) exists.""" genqry = """ - SELECT 1 FROM rdb$database + SELECT 1 AS has_sequence FROM rdb$database WHERE EXISTS (SELECT rdb$generator_name FROM rdb$generators WHERE rdb$generator_name=?) |