Daniel Barclay (Drill) created DRILL-3151:
---------------------------------------------
Summary: ResultMetaData not as specified by JDBC
Key: DRILL-3151
URL: https://issues.apache.org/jira/browse/DRILL-3151
Project: Apache Drill
Issue Type: Bug
Components: Client - JDBC
Reporter: Daniel Barclay (Drill)
Assignee: Daniel Barclay (Drill)
In Drill's JDBC driver, some ResultMetaData methods don't return what JDBC
specifies they should return.
Some cases:
{{getTableName(int)}}:
- (JDBC says: {{table name or "" if not applicable}})
- Drill returns {{null}} (instead of empty string or table name)
- (Drill indicates "not applicable" even when from named table, e.g., for
"{{SELECT * FROM INFORMATION_SCHEMA.CATALOGS}}".)
{{getSchemaName(int)}}:
- (JDBC says: {{schema name or "" if not applicable}})
- Drill returns "{{--UNKNOWN--}}" (instead of empty string or table name)
- (Drill indicates "not applicable" even when from named table, e.g., for
"{{SELECT * FROM INFORMATION_SCHEMA.CATALOGS}}".)
{{getCatalogName(int)}}:
- (JDBC says: {{the name of the catalog for the table in which the given column
appears or "" if not applicable}})
- Drill returns "{{--UNKNOWN--}}" (instead of empty string or table name)
- (Drill indicates "not applicable" even when from named table, e.g., for
"{{SELECT * FROM INFORMATION_SCHEMA.CATALOGS}}".)
{{isSearchable(int)}}:
- (JDBC says: {{Indicates whether the designated column can be used in a where
clause.}})
- Drill returns {{false}}
{{getColumnClassName(int}}:
- (JDBC says: {{the fully-qualified name of the class in the Java programming
language that would be used by the method ResultSet.getObject to retrieve the
value in the specified column. This is the class name used for custom mapping.}}
- Drill returns "{{none}}" (instead of the correct class name)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
