Skip to content

db.sql.Connection() catalog and schema args surprisingly do not apply to metadata calls like cursor.tables #39

Open
@benfleis

Description

@benfleis

Observation // Concern
catalog and schema initial values can be set when creating Connection. These values are not applied in subsequent cursor metadata calls: catalogs(), schemas(), and tables(). These functions are unaware of that previous setting.

Current documentation states:

:param catalog: An optional initial catalog to use. Requires DBR version 9.0+
:param schema: An optional initial schema to use. Requires DBR version 9.0+

Where both the scope and duration of application is unstated. It currently only applies to executed statement when opening the session. Metadata calls are entirely ignorant of this setting, which surprised at least one user, who expected the catalog setting to carry through in those calls.

Ask
Define and document scope of these parameters. Consider whether they should be applied, possibly as default values, to metadata calls.

Metadata

Metadata

Assignees

No one assigned

    Labels

    documentationImprovements or additions to documentation

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions