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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.8.1.2
    • 10.12.1.1
    • SQL
    • 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. DERBY.5466.aggtest.patch
          93 kB
          Scott Lewis
        2. DERBY-5466.stats.patch
          9 kB
          Scott Lewis
        3. derby-5466-01-aa-aggregatorClasses.diff
          14 kB
          Richard N. Hillegas
        4. derby-5466-02-aa-bindLogic.diff
          11 kB
          Richard N. Hillegas
        5. derby-5466-02-ab-bindLogic.diff
          18 kB
          Richard N. Hillegas
        6. derby-5466-03-aa-distinctError.diff
          5 kB
          Richard N. Hillegas
        7. var_pop_formulas.txt
          0.4 kB
          Richard N. Hillegas

        Issue Links

          Activity

            People

              scottslewis Scott Lewis
              lukas.eder Lukas Eder
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: