Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6547

Result type inferred for STDDEV_SAMP is incorrect

    XMLWordPrintableJSON

Details

    Description

      STDDEV_SAMP can return NULL even if the input is non-null and non-empty - it returns NULL when the input set has only one element. E.g. see the Oracle documentation: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/VAR_SAMP.html

      Attachments

        Issue Links

          Activity

            People

              mbudiu Mihai Budiu
              mbudiu Mihai Budiu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: