calcite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jh...@apache.org
Subject [06/13] calcite git commit: Test case for [PHOENIX-2767], non-constant in IN
Date Fri, 22 Apr 2016 08:07:35 GMT
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 <jhyde@apache.org>
Authored: Tue Mar 22 14:17:59 2016 -0700
Committer: Julian Hyde <jhyde@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


Mime
View raw message