You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2019/08/01 12:27:54 UTC
[GitHub] [calcite] rubenada commented on a change in pull request #1322:
[CALCITE-3198] ReduceExpressionsRule.FILTER_INSTANCE does not reduce
'NOT(x=a AND x=b)'
rubenada commented on a change in pull request #1322: [CALCITE-3198] ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)'
URL: https://github.com/apache/calcite/pull/1322#discussion_r307680016
##########
File path: core/src/main/java/org/apache/calcite/rex/RexSimplify.java
##########
@@ -1624,6 +1630,47 @@ private RexNode simplifyOrs(List<RexNode> terms, RexUnknownAs unknownAs) {
continue;
}
}
+ break;
+ case NOT_EQUALS:
+ final Comparison notEqualsComparison =
+ Comparison.of(term, node -> RexUtil.isReferenceOrAccess(node, false));
+ if (notEqualsComparison != null) {
+ // We are dealing with a X<>A term, check if we saw before another NOT_EQUALS involving X
+ final RexNode prevNotEquals = notEqualsComparisonMap.get(notEqualsComparison.ref);
+ if (prevNotEquals == null) {
+ // This is the first NOT_EQUALS involving X, put it in the map
+ notEqualsComparisonMap.put(notEqualsComparison.ref, term);
+ } else {
+ // There is already in the map another NOT_EQUALS involving X:
+ // - if it is already an IS_NOT_NULL: it was already simplified, ignore this term
+ // - if it is not an IS_NOT_NULL (i.e. it is a NOT_EQUALS): check comparison values
+ if (prevNotEquals.getKind() != SqlKind.IS_NOT_NULL) {
+ final Comparable comparable1 = notEqualsComparison.literal.getValue();
+ //noinspection ConstantConditions
+ final Comparable comparable2 = Comparison.of(
+ prevNotEquals, node -> RexUtil.isReferenceOrAccess(node, false))
+ .literal.getValue();
+ //noinspection unchecked
+ if (comparable1.compareTo(comparable2) != 0) {
+ // We found: X <> A OR X <> B
+ if (unknownAs == RexUnknownAs.TRUE || !term.getType().isNullable()) {
Review comment:
Ok, thanks for the explanation. I have updated the PR trying to achieve what you describe.
@kgyrtkirk , when you have some time, could you please take another look? Thanks
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services