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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
