[ https://issues.apache.org/jira/browse/DRILL-5246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Rogers updated DRILL-5246: ------------------------------- Description: 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: {code} org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: >From line 1, column 43 to line 1, column 46: Illegal use of 'NULL' SQL Query >null {code} was: 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. > 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: > {code} > org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: > From line 1, column 43 to line 1, column 46: Illegal use of 'NULL' SQL Query > null > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)