Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5466

Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP

    Details

    • 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
    • Urgency:
      Normal

      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

        Attachments

        1. var_pop_formulas.txt
          0.4 kB
          Rick Hillegas
        2. derby-5466-03-aa-distinctError.diff
          5 kB
          Rick Hillegas
        3. derby-5466-02-ab-bindLogic.diff
          18 kB
          Rick Hillegas
        4. derby-5466-02-aa-bindLogic.diff
          11 kB
          Rick Hillegas
        5. derby-5466-01-aa-aggregatorClasses.diff
          14 kB
          Rick Hillegas
        6. DERBY-5466.stats.patch
          9 kB
          Scott Lewis
        7. DERBY.5466.aggtest.patch
          93 kB
          Scott Lewis

          Issue Links

            Activity

              People

              • Assignee:
                scottslewis Scott Lewis
                Reporter:
                lukas.eder Lukas Eder
              • Votes:
                3 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: