Improved plan due to [CALCITE-1601] fix
Project: http://git-wip-us.apache.org/repos/asf/calcite/repo Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/4a3df4ef Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/4a3df4ef Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/4a3df4ef Branch: refs/heads/master Commit: 4a3df4ef9746760b17c639c6b5be609a31adcd5c Parents: 952214a Author: Julian Hyde <[email protected]> Authored: Thu Mar 2 16:44:07 2017 -0800 Committer: Julian Hyde <[email protected]> Committed: Fri Mar 3 10:13:29 2017 -0800 ---------------------------------------------------------------------- druid/src/test/java/org/apache/calcite/test/DruidAdapterIT.java | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/calcite/blob/4a3df4ef/druid/src/test/java/org/apache/calcite/test/DruidAdapterIT.java ---------------------------------------------------------------------- diff --git a/druid/src/test/java/org/apache/calcite/test/DruidAdapterIT.java b/druid/src/test/java/org/apache/calcite/test/DruidAdapterIT.java index 974cae9..15cf7e0 100644 --- a/druid/src/test/java/org/apache/calcite/test/DruidAdapterIT.java +++ b/druid/src/test/java/org/apache/calcite/test/DruidAdapterIT.java @@ -1334,11 +1334,11 @@ public class DruidAdapterIT { + "and extract(month from \"timestamp\") in (4, 6)\n"; final String explain = "EnumerableInterpreter\n" + " BindableAggregate(group=[{}], C=[COUNT()])\n" - + " BindableFilter(condition=[AND(>=(/INT(Reinterpret($0), 86400000), 1997-01-01), <(/INT(Reinterpret($0), 86400000), 1998-01-01), >=(/INT(Reinterpret($0), 86400000), 1997-04-01), <(/INT(Reinterpret($0), 86400000), 1997-05-01))])\n" + + " BindableFilter(condition=[AND(>=(/INT(Reinterpret($0), 86400000), 1997-01-01), <(/INT(Reinterpret($0), 86400000), 1998-01-01), OR(AND(>=(/INT(Reinterpret($0), 86400000), 1997-04-01), <(/INT(Reinterpret($0), 86400000), 1997-05-01)), AND(>=(/INT(Reinterpret($0), 86400000), 1997-06-01), <(/INT(Reinterpret($0), 86400000), 1997-07-01))))])\n" + " DruidQuery(table=[[foodmart, foodmart]], intervals=[[1900-01-09T00:00:00.000/2992-01-10T00:00:00.000]])"; sql(sql) .explainContains(explain) - .returnsUnordered("C=6588"); + .returnsUnordered("C=13500"); } @Test public void testFilterSwapped() {
