drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2313) Query fails when one of the operands is a DATE literal without an explicit cast
Date Wed, 25 Feb 2015 20:06:04 GMT
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)

Mime
View raw message