search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.96k stars 3.79k forks source link

sql: distributed float aggregations don't satisfy the precision requirements #56446

Open yuzefovich opened 3 years ago

yuzefovich commented 3 years ago

56348 has several examples in which the computations of aggregate functions in the distributed environment produce the floating-point result that doesn't match the expected one in the 15 significant digits (which is what Postgres supports). Interestingly, this occurs on the statistics aggregates the code for which was ported over from PG. Further investigation is needed into why this occurs, and at the moment we updated the logic test checker to look only at 14 significant digits.

Jira issue: CRDB-2940

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!