db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Lewis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5466) Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP
Date Wed, 22 Jul 2015 23:22:06 GMT

    [ 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)

Mime
View raw message