DonnyZone commented on a change in pull request #1849: CALCITE-3815: Add missing SQL standard aggregate functions: EVERY, SO… URL: https://github.com/apache/calcite/pull/1849#discussion_r389444988
########## File path: site/_docs/reference.md ########## @@ -1766,12 +1766,15 @@ and `LISTAGG`). | COUNT( [ ALL | DISTINCT ] value [, value ]*) | Returns the number of input rows for which *value* is not null (wholly not null if *value* is composite) | COUNT(*) | Returns the number of input rows | FUSION(multiset) | Returns the multiset union of *multiset* across all input values +| INTERSECTION(multiset) | Returns the multiset intersection of *multiset* across all input values | APPROX_COUNT_DISTINCT(value [, value ]*) | Returns the approximate number of distinct values of *value*; the database is allowed to use an approximation but is not required to | AVG( [ ALL | DISTINCT ] numeric) | Returns the average (arithmetic mean) of *numeric* across all input values | SUM( [ ALL | DISTINCT ] numeric) | Returns the sum of *numeric* across all input values | MAX( [ ALL | DISTINCT ] value) | Returns the maximum value of *value* across all input values | MIN( [ ALL | DISTINCT ] value) | Returns the minimum value of *value* across all input values | ANY_VALUE( [ ALL | DISTINCT ] value) | Returns one of the values of *value* across all input values; this is NOT specified in the SQL standard +| SOME( [ condition ] ) | Returns true if any expression is true. If no rows are selected, the result is NULL Review comment: > If no rows are selected, the result is NULL Is this an expected behavior? ---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services
