Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ODBC: SYS TYPES filtering #35342

Closed
bpintea opened this issue Nov 7, 2018 · 1 comment
Closed

ODBC: SYS TYPES filtering #35342

bpintea opened this issue Nov 7, 2018 · 1 comment
Labels
:Analytics/SQL SQL querying >enhancement

Comments

@bpintea
Copy link
Contributor

bpintea commented Nov 7, 2018 •
edited

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).
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search-aggs

costin added a commit to costin/elasticsearch that referenced this issue Nov 23, 2018
@costin
SQL: Add filtering to SYS TYPES
ce28627 
Fix elastic#35342
@costin costin mentioned this issue Nov 26, 2018
Merged
costin added a commit that referenced this issue Nov 26, 2018
@costin
SQL: Add filtering to SYS TYPES (#35852)
971299b 
Fix #35342
costin added a commit that referenced this issue Nov 26, 2018
@costin
SQL: Add filtering to SYS TYPES (#35852)
1d633cf 
Fix #35342

(cherry picked from commit cd822b7)
(cherry picked from commit 633a562)
(cherry picked from commit 971299b)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
:Analytics/SQL SQL querying >enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bpintea @elasticmachine