[
https://issues.apache.org/jira/browse/DRILL-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15214071#comment-15214071
]
Serge Harnyk commented on DRILL-4409:
-------------------------------------
Resume:
1. PostgreSQL returns "unknown" type for literals. It breaks SQL Standart.
2. MySQL and Oracle returns VARCHAR for literals.
3. Nothing to fix in Drill itself, but seems reasonable to add note here:
https://drill.apache.org/docs/jdbc-storage-plugin/
> 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)
