drill-issues mailing list archives

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

    [ 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

View raw message