vineetgarg02 commented on a change in pull request #1161: [CALCITE-2986] Wrong
results with =ANY subquery
URL: https://github.com/apache/calcite/pull/1161#discussion_r275099150
##########
File path:
core/src/test/java/org/apache/calcite/test/SqlToRelConverterTest.java
##########
@@ -1389,6 +1389,12 @@ public void testJoinUsingDynamicTable() {
sql(sql).expand(false).ok();
}
+ @Test public void testSomeWithEquality() {
+ final String sql = "select empno from emp where deptno = some (\n"
+ + " select deptno from dept)";
+ sql(sql).expand(false).ok();
+ }
+
Review comment:
@chunweilei ANY is alias for SOME, I am not sure if adding same test for ANY
is worthwhile for this patch/request since it doesn't really touch that part of
the code. BTW there is a test which uses =ANY is `some.iq`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
