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 | +------------+
Attachments
Issue Links
- blocks
-
DRILL-4399 query using OVERLAPS function executes and returns 0 rows
-
- Open
-