[CALCITE-1167] OVERLAPS should match even if operands are in (high, low) order
Already works (probably fixed in [CALCITE-715]), but added a test case. Project: http://git-wip-us.apache.org/repos/asf/calcite/repo Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/4402f919 Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/4402f919 Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/4402f919 Branch: refs/heads/site Commit: 4402f9194291def0de7263a57889572df339fdb7 Parents: 93b8349 Author: Julian Hyde <[email protected]> Authored: Thu Aug 3 21:16:14 2017 -0700 Committer: Julian Hyde <[email protected]> Committed: Fri Jul 13 14:21:43 2018 -0700 ---------------------------------------------------------------------- core/src/test/resources/sql/misc.iq | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/calcite/blob/4402f919/core/src/test/resources/sql/misc.iq ---------------------------------------------------------------------- diff --git a/core/src/test/resources/sql/misc.iq b/core/src/test/resources/sql/misc.iq index 22d1422..cdbde5d 100644 --- a/core/src/test/resources/sql/misc.iq +++ b/core/src/test/resources/sql/misc.iq @@ -2158,4 +2158,27 @@ where false; !ok +!set outputformat csv + +# [CALCITE-1167] OVERLAPS should match even if operands are in (high, low) order +values ((date '1999-12-01', date '2001-12-31') overlaps (date '2001-01-01' , date '2002-11-11')); +EXPR$0 +true +!ok + +values ((date '2001-12-31', date '1999-12-01') overlaps (date '2001-01-01' , date '2002-11-11')); +EXPR$0 +true +!ok + +values ((date '2001-12-31', date '1999-12-01') overlaps (date '2002-11-11', date '2001-01-01')); +EXPR$0 +true +!ok + +values ((date '2001-12-31', date '1999-12-01') overlaps (date '2002-01-01', date '2002-11-11')); +EXPR$0 +false +!ok + # End misc.iq
