diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2023-02-06 13:54:56 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2023-02-06 16:06:11 -0500 |
| commit | 662d6e24526bfd9d358b8a9e1906fb29bf93ef30 (patch) | |
| tree | cd473a0b48312f599ec7a7d65ef43cd617420a41 /lib/sqlalchemy/dialects/sqlite/base.py | |
| parent | ce7922dfd001a0e9fc0914ec217c950acc5e0e5f (diff) | |
| download | sqlalchemy-662d6e24526bfd9d358b8a9e1906fb29bf93ef30.tar.gz | |
add error code 1049 for mysql has_table
Fixed regression caused by issue :ticket:`9058` which adjusted the MySQL
dialect's ``has_table()`` to again use "DESCRIBE", where the specific error
code raised by MySQL version 8 when using a non-existent schema name was
unexpected and failed to be interpreted as a boolean result.
Fixed the SQLite dialect's ``has_table()`` function to correctly report
False for queries that include a non-None schema name for a schema that
doesn't exist; previously, a database error was raised.
Fixes: #9251
Change-Id: I5ef9cf0887865c3c521d88bca0ba18954a108241
Diffstat (limited to 'lib/sqlalchemy/dialects/sqlite/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/sqlite/base.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index e46443a74..fcabf5bb8 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -2152,6 +2152,11 @@ class SQLiteDialect(default.DefaultDialect): def has_table(self, connection, table_name, schema=None, **kw): self._ensure_has_table_connection(connection) + if schema is not None and schema not in self.get_schema_names( + connection, **kw + ): + return False + info = self._get_table_pragma( connection, "table_info", table_name, schema=schema ) |