[CALCITE-1167] OVERLAPS should swap operands if second is earlier than first

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.17.0
• Labels: newbie
• Assignee: Julian Hyde
• Reporter: Serhii Harnyk
• Created: 24/Mar/16 13:03
• Updated: 20/Jul/18 08:18
• Resolved: 13/Jul/18 22:55

Description

If second date in interval is earlier than first OVERLAPS doesn't swap them.

Example:

select 1 from "TEST"."tdt" where (date '1999-12-01' , date '2001-12-31' ) overlaps ( date '2001-01-01' , date '2002-11-11' );

+------------+
|   EXPR$0   |
+------------+
| 1          |
| 1          |
| 1          |
| 1          |
+------------+

select 1 from "TEST"."tdt" where ( date '2001-12-31', date '1999-12-01' ) overlaps ( date '2001-01-01' , date '2002-11-11' );
+------------+
|   EXPR$0   |
+------------+

Issue Links

• blocks: DRILL-4399 query using OVERLAPS function executes and returns 0 rows