Skip to content

Support for connectors that cannot rename tables #27568

@prrvchr

Description

@prrvchr

Firebird doesn't support renaming tables.

This prevents me from creating a table using AS SELECT... with the Trino query executor, since it creates a temporary table and then tries to rename it.
However, it is possible to create a table using CREATE TABLE ... (LIKE...) followed by INSERT INTO... SELECT..., and in this case, Trino apparently doesn't use a temporary table and doesn't rename it.

If this is indeed true, then instead of modifying the tests so that they can correctly create the test tables, it might be more sensible to modify the way Trino creates the tables based on the connector's support for table renaming?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions