[DERBY-5466] Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.12.1.1
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Assignee: Scott Lewis
• Reporter: Lukas Eder
• Created: 16/Oct/11 11:59
• Updated: 25/Mar/18 18:17
• Resolved: 30/Aug/15 14:28

Description

Any of these RDBMS support the SQL standard statistics functions STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP:

• DB2 (only STDDEV, VARIANE)
• H2
• HSQLDB
• Ingres
• MySQL
• Oracle
• Postgres
• SQL Server (named STDEVP, STDEV, VARP, VAR)
• Sybase ASE
• Sybase SQL Anywhere

These don't:

• Derby
• SQLite

This would be a useful addition for Derby, I think.

An even larger example list of possible statistics aggregate functions is listed in the Postgres documentation:
http://www.postgresql.org/docs/9.0/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE

Issue Links

• is related to: DERBY-6991 GROUP_CONCAT / LISTAGG
• is related to: DERBY-6830 Add user documentation for var_pop(), var_samp(), stddev_pop(), and stddev_samp()
• relates to: DERBY-672 Re-enable user defined aggregates