drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Serge Harnyk (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4409) projecting literal will result in an empty resultset
Date Wed, 16 Mar 2016 17:53:33 GMT

    [ 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)

Mime
View raw message