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

["Scott Lewis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14637903#comment-14637903 ] 

Scott Lewis commented on DERBY-5466:
------------------------------------

I have implementations of these four functions:   stddev_pop, stddev_samp, var_pop, and var_samp via an implementation of a derby user-defined aggregates 

https://db.apache.org/derby/docs/10.10/devguide/cdevspecialuda.html

How best to contribute these classes?   Do I attach to this bug?   Or do something else?   I assume the license should be Apache 2...what are the requirements for the copyright header in source?   I'm willing to do anything that's needed...i.e. I'm happy to just contribute everything outright. 

And one other question:  what package should these classes be in?...or perhaps it doesn't matter because they will end up in some other package.

Thanks,

Scott

> Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP
> -----------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5466
>                 URL: https://issues.apache.org/jira/browse/DERBY-5466
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.8.1.2
>            Reporter: Lukas Eder
>            Priority: Minor
>              Labels: derby_triage10_10
>
> 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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)