- Notifications
You must be signed in to change notification settings - Fork 25.6k
Closed
Description
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).