Julian Hyde created CALCITE-1368: ------------------------------------ Summary: Infer predicates for aggregate functions Key: CALCITE-1368 URL: https://issues.apache.org/jira/browse/CALCITE-1368 Project: Calcite Issue Type: Bug Reporter: Julian Hyde Assignee: Julian Hyde
Currently when inferring predicates for Aggregate, Calcite only pulls up existing predicates, and it can only do that for columns that are part of the group key. This feature would infer predicates based on the behavior of aggregate functions and, sometimes, predicates of the arguments to those functions. Examples: * {{count\(*)}} and {{count\(x)}} are always > 0 (if groups are non-empty, and x is not null) * {{count\(*)}} and {{count\(x)}} are always >= 0 * {{sum\(x)}} is >= 0 (if x is >= 0; it's OK if x is sometimes null) * {{min\(x)}} and {{max\(x)}} have the same upper and lower bounds as x -- This message was sent by Atlassian JIRA (v6.3.4#6332)