You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by mm...@apache.org on 2018/07/20 17:41:56 UTC
[43/53] [abbrv] calcite git commit: [CALCITE-1167] OVERLAPS should
match even if operands are in (high, low) order
[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 <jh...@apache.org>
Authored: Thu Aug 3 21:16:14 2017 -0700
Committer: Julian Hyde <jh...@apache.org>
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