[jira] [Created] (DRILL-2313) Query fails when one of the operands is a DATE literal without an explicit cast

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-2313:
--------------------------------------

             Summary: Query fails when one of the operands is a DATE literal without an explicit cast
                 Key: DRILL-2313
                 URL: https://issues.apache.org/jira/browse/DRILL-2313
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 0.8.0
            Reporter: Abhishek Girish
            Assignee: Jinfeng Ni


For operations involving the date datatype, when one of the operands is a DATE literal without a cast, query fails. 

*The following query fails to validate:*
{code:sql}
SELECT
         *
FROM     
         date_dim
         
WHERE    d_date BETWEEN '2002-3-01' AND cast('2002-3-01' AS DATE) 

LIMIT 1;
{code}
Query failed: SqlValidatorException: Cannot apply 'BETWEEN' to arguments of type '<ANY> BETWEEN <CHAR(9)> AND <DATE>'. Supported form(s): '<COMPARABLE_TYPE> BETWEEN <COMPARABLE_TYPE> AND <COMPARABLE_TYPE>'

*The following query executes fine:*
{code:sql}
SELECT
         *
FROM     
         date_dim
         
WHERE    d_date BETWEEN '2002-3-01' AND 
                  '2002-3-01'
LIMIT 1;
{code}

Both the queries execute fine on postgres



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)