[DRILL-4525] Query with BETWEEN clause on Date and Timestamp values fails with Validation Error

• Type: Improvement
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Bohdan Kazydub
• Reporter: Abhishek Girish
• Reviewer: Vova Vysotskyi
• Created: 21/Mar/16 22:40
• Updated: 18/May/18 18:45
• Resolved: 18/May/18 18:45

Description

Query: (simplified variant of TPC-DS Query37)

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;

Error:

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)

This is a regression from 1.6.0.

Issue Links

• is duplicated by: DRILL-4798 TPCDS query 12 fails to plan
• links to: GitHub Pull Request #1268