ankitsultana commented on code in PR #10627:
URL: https://github.com/apache/pinot/pull/10627#discussion_r1169357001
##########
pinot-query-runtime/src/test/resources/queries/FromExpressions.json:
##########
@@ -136,6 +136,11 @@
"description": "sub-query to semi-join syntax with star results, using
IN clause",
"sql": "SELECT * FROM {tbl1} WHERE num IN (SELECT num FROM {tbl2})"
},
+ {
+ "psql": "7.2.1.3",
+ "description": "sub-query to multiple anti semi-join queries with star
results, using NOT IN clause",
+ "sql": "SELECT * FROM {tbl1} WHERE (num > -10 and num < 10) AND (name
NOT IN (SELECT val FROM {tbl2} WHERE num = 3)) AND (name NOT IN (SELECT val
from {tbl2} WHERE num = 4))"
Review Comment:
Done. Can you check again?
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]