Same rows, different SUM

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

Everyone knows not to store money as a double precision . One can hope. The rule is so well drilled that it has stopped being interesting, and it is also not where the trouble usually starts. The float is already in the schema before anyone weighs in on it: a measurement column someone later sums for a report, telemetry that drifts into a finance dashboard, a third-party feed ingested as double…

Read on boringsql.com ↗