Skip to content

ODBC: SYS TYPES filtering #35342

@bpintea

Description

@bpintea

The ODBC info function mapping on this query takes one filtering parameter: the DataType (identifier).
This parameter can be 0 (ODBC's SQL_ALL_TYPES), in which case all types supported by the data source / driver should be returned. This maps well on the currently available functionality.
However, it can take other values too, indicating one specific data type (ex. 4 for INTEGER), in which case the driver needs to return the matching types only (ex. 12 returning the rows for KEYWORD, TEXT, IP).

Currently, there is no way of specifying any filtering with SYS TYPES. The proposition of this issue is to add this functionality (on the lines of SYS TYPES TYPE 12 or equivalent).

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions