You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2014/12/12 08:12:47 UTC
[2/4] incubator-calcite git commit: Add a test case
Add a test case
Project: http://git-wip-us.apache.org/repos/asf/incubator-calcite/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/67492c81
Tree: http://git-wip-us.apache.org/repos/asf/incubator-calcite/tree/67492c81
Diff: http://git-wip-us.apache.org/repos/asf/incubator-calcite/diff/67492c81
Branch: refs/heads/master
Commit: 67492c813d51eff659616b356bce5ff759718a61
Parents: e5a08c4
Author: Julian Hyde <jh...@apache.org>
Authored: Thu Dec 11 14:49:37 2014 -0800
Committer: Julian Hyde <jh...@apache.org>
Committed: Thu Dec 11 14:49:37 2014 -0800
----------------------------------------------------------------------
core/src/test/resources/sql/misc.oq | 14 ++++++++++++++
1 file changed, 14 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-calcite/blob/67492c81/core/src/test/resources/sql/misc.oq
----------------------------------------------------------------------
diff --git a/core/src/test/resources/sql/misc.oq b/core/src/test/resources/sql/misc.oq
index 62eaa24..ae1b2ea 100644
--- a/core/src/test/resources/sql/misc.oq
+++ b/core/src/test/resources/sql/misc.oq
@@ -103,6 +103,20 @@ select * from (select * from "hr"."emps" order by "empid") where (0=1);
!ok
+# [DRILL-1842] Tableau, again
+select count(distinct "salary") as c
+from "hr"."emps"
+join "hr"."depts" on "emps"."deptno" = "depts"."deptno"
+having count(1) > 0;
++---+
+| C |
++---+
+| 3 |
++---+
+(1 row)
+
+!ok
+
# [CALCITE-340] SqlToRelConverter fails with complex join condition
select e."deptno", d."deptno"
from "hr"."emps" as e