[
https://issues.apache.org/jira/browse/DRILL-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197798#comment-15197798
]
Serge Harnyk commented on DRILL-4409:
-------------------------------------
PostgreSQL JDBC Driver returns 1111 metadata code for literal parts of query,
which seems java.sql.Types.OTHER. PostgreSQL itself doesnt treat literals as
VARCHAR or another string type.
For example, MySQL driver returns 12 metadata code, which seems
java.sql.Types.VARCHAR.
When Drill faces java.sql.Types.OTHER it skips work with cell:
org/apache/drill/exec/store/jdbc/JdbcRecordReader.java, line 190
I think Taras cant reproduced this bug on Oracle for same reason.
> projecting literal will result in an empty resultset
> ----------------------------------------------------
>
> Key: DRILL-4409
> URL: https://issues.apache.org/jira/browse/DRILL-4409
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JDBC
> Affects Versions: 1.5.0
> Reporter: N Campbell
> Assignee: Serge Harnyk
>
> A query which projects a literal as shown against a Postgres table will
> result in an empty result set being returned.
> select 'BB' from postgres.public.tversion
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
