Skip to content

Existing table detection is case sensitive even in case insensitive databases #237

@augusto-herrmann

Description

@augusto-herrmann

In create_table_from_query_using_pandas, when checking if a table exists, the table's name is checked if it is in the list of tables in the destination schema:

if destination.table not in inspector.get_table_names(schema=destination.schema):

If source and destination have different casing, and the destination database is case insensitive (MS SQL Server), then the existing table should be reported as being present, even if the case doesn't match.

Metadata

Metadata

Labels

bugSomething isn't working

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions