[
https://issues.apache.org/jira/browse/DRILL-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197564#comment-15197564
]
Laurent Goujon commented on DRILL-4409:
---------------------------------------
Probably the same issue as DRILL-4405 (or related in some way).
According to postgres documentation
(http://www.postgresql.org/docs/current/static/typeconv-overview.html):
bq. If a type is not specified for a string literal, then the placeholder type
unknown is assigned initially, to be resolved in later stages as described
below.
this might cause clashes with Drill which is assuming a different type for the
literal.
> 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)
