Return-Path: 
 <issues-return-30187-apmail-drill-issues-archive=drill.apache.org@drill.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id CE69819913
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Thu, 24 Mar 2016 16:44:25 +0000 (UTC)
Received: (qmail 12683 invoked by uid 500); 24 Mar 2016 16:44:25 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 12617 invoked by uid 500); 24 Mar 2016 16:44:25 -0000
Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.apache.org>
List-Post: <mailto:issues@drill.apache.org>
List-Id: <issues.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list issues@drill.apache.org
Received: (qmail 12596 invoked by uid 99); 24 Mar 2016 16:44:25 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Mar 2016 16:44:25 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 781962C1F5A
	for <issues@drill.apache.org>; Thu, 24 Mar 2016 16:44:25 +0000 (UTC)
Date: Thu, 24 Mar 2016 16:44:25 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12952230.1458600007000.42651.1458837865489@Atlassian.JIRA>
In-Reply-To: <JIRA.12952230.1458600007000@Atlassian.JIRA>
References: <JIRA.12952230.1458600007000@Atlassian.JIRA>
 <JIRA.12952230.1458600007103@arcas>
Subject: [jira] [Commented] (DRILL-4525) Query with BETWEEN clause on Date
 and Timestamp values fails with Validation Error
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


    [ https://issues.apache.org/jira/browse/DRILL-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15210527#comment-15210527 ] 

ASF GitHub Bot commented on DRILL-4525:
---------------------------------------

Github user jacques-n commented on the pull request:

    https://github.com/apache/drill/pull/439#issuecomment-200918110
  
    Got it. We should open a discussion on this on the Calcite list. We shouldn't have to jump through hoops to change the implementation. Maybe the overridden operator table should be available in the parsing context. Or?


> Query with BETWEEN clause on Date and Timestamp values fails with Validation Error
> ----------------------------------------------------------------------------------
>
>                 Key: DRILL-4525
>                 URL: https://issues.apache.org/jira/browse/DRILL-4525
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Abhishek Girish
>            Assignee: Sean Hsuan-Yi Chu
>            Priority: Critical
>
> Query: (simplified variant of TPC-DS Query37)
> {code}
> SELECT
>        *
> FROM   
>        date_dim
> WHERE   
>        d_date BETWEEN Cast('1999-03-06' AS DATE) AND      (
>                   Cast('1999-03-06' AS DATE) + INTERVAL '60' day)
> LIMIT 10;
> {code}
> Error:
> {code}
> Error: VALIDATION ERROR: From line 6, column 8 to line 7, column 64: Cannot apply 'BETWEEN ASYMMETRIC' to arguments of type '<ANY> BETWEEN ASYMMETRIC <DATE> AND <TIMESTAMP(0)>'. Supported form(s): '<COMPARABLE_TYPE> BETWEEN <COMPARABLE_TYPE> AND <COMPARABLE_TYPE>'
> SQL Query null
> [Error Id: 223fb37c-f561-4a37-9283-871dc6f4d6d0 on abhi2:31010] (state=,code=0)
> {code}
> This is a regression from 1.6.0. 



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