Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.37.0
Description
Today aggregates like STDDEV are expanded into computations that use intermediate results with the same type as the input values. Since STDDEV squares values, this precision may prove insufficient. For DECIMAL values a reasonable approach would be to use double the input precision and scale.
This is also related to CALCITE-6322, CALCITE-4924, CALCITE-6324
Attachments
Issue Links
- relates to
-
CALCITE-6516 AVG to SUM+COUNT transformation inserts invalid CAST call
- Open
- links to