drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Rogers (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5246) NULL not supported in VALUES clause
Date Thu, 09 Feb 2017 00:49:41 GMT
Paul Rogers created DRILL-5246:
----------------------------------

             Summary: NULL not supported in VALUES clause
                 Key: DRILL-5246
                 URL: https://issues.apache.org/jira/browse/DRILL-5246
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.9.0
            Reporter: Paul Rogers


The following is valid in DRILL:

{code}
SELECT * FROM (VALUES ( TRUE, FALSE ))
SELECT * FROM (VALUES ( TRUE ), (FALSE))
{code}

But, the following is not:
{code}
SELECT * FROM (VALUES ( TRUE, NULL, FALSE ))
SELECT * FROM (VALUES ( TRUE ), (FALSE), (NULL))
{code}

Internally, a bare "null" may be an issue since Drill does not have a null type. So, the first
example might be a problem (a column for which the only value is Null, but we don't know a
null of which type.) But, the second example should be fine: we know that the type is boolean.

While Drill's error reporting in the web UI is not clear, it seems that I'm getting a syntax
error when using Null.




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message