[GitHub] [calcite] NobiGo opened a new pull request #2671: [CALCITE-4924] REGR_SXX and similar aggregate functions return the wrong data type

[GitBox <gi...@apache.org>]

NobiGo opened a new pull request #2671:
URL: https://github.com/apache/calcite/pull/2671


   According to the SQL:2003 standard (ISO/IEC 9075:2003):
   If <binary set function> is specified, then:
          a) The <dependent variable expression> DVE and the <independent variable expression> IVE shall not
   contain a <window function>.
          b) Let DTDVE be the declared type of DVE and let DTIVE be the declared type of IVE.
          c) Case:
                    i) The declared type of REGR_COUNT is an implementation-defined exact numeric type with
   a scale of 0 (zero).
                  ii) Otherwise, the declared type of the result is an implementation-defined approximate numeric
   type. If DTDVE is an approximate numeric type, then the precision of the result is not less than
   the precision of DTDVE. If DTIVE is an approximate numeric type, then the precision of the
   result is not less than the precision of DTIVE.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@calcite.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org