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 2016/04/22 10:07:35 UTC
[06/13] calcite git commit: Test case for [PHOENIX-2767],
non-constant in IN
Test case for [PHOENIX-2767], non-constant in IN
Already works in Calcite, does not yet work in Phoenix.
Project: http://git-wip-us.apache.org/repos/asf/calcite/repo
Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/b666f72e
Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/b666f72e
Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/b666f72e
Branch: refs/heads/master
Commit: b666f72ee03587709f0f2dd8fbcb4ae958df6581
Parents: d81133f
Author: Julian Hyde <jh...@apache.org>
Authored: Tue Mar 22 14:17:59 2016 -0700
Committer: Julian Hyde <jh...@apache.org>
Committed: Tue Apr 19 11:11:37 2016 -0700
----------------------------------------------------------------------
core/src/test/resources/sql/subquery.iq | 10 ++++++++++
1 file changed, 10 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/calcite/blob/b666f72e/core/src/test/resources/sql/subquery.iq
----------------------------------------------------------------------
diff --git a/core/src/test/resources/sql/subquery.iq b/core/src/test/resources/sql/subquery.iq
index d4f3a10..d014b57 100644
--- a/core/src/test/resources/sql/subquery.iq
+++ b/core/src/test/resources/sql/subquery.iq
@@ -231,6 +231,16 @@ where (gender, deptno) in (select gender, 10 from emp where gender = 'F');
!use scott
+# [CALCITE-1155] Support columns for IN list
+SELECT empno, ename, mgr FROM "scott".emp WHERE 7782 IN (empno, mgr);
+ EMPNO | ENAME | MGR
+-------+--------+------
+ 7782 | CLARK | 7839
+ 7934 | MILLER | 7782
+(2 rows)
+
+!ok
+
# [CALCITE-694] Scan HAVING clause for sub-queries and IN-lists
SELECT count(*) AS c
FROM "scott".emp