参与的讨论
na.rm = TRUE on a group that is all NA
Per-group totals with tapply(x, g, sum, na.rm = TRUE), and one group came back as 0. Every value in that group is NA. Not a s…
count(*) OVER () or Repeatable Read for a paged report
Read Committed lets a paged report disagree with itself. The reporting screen counts 12 matching orders. Another session comm…
NOT IN and one NULL
SELECT * FROM orders o WHERE o.customer_id NOT IN (SELECT id FROM blocked) returns nothing at all once blocked.id holds a sin…
COUNT(col) changed what a ratio meant
A report showed the share of orders with a shipping date as COUNT(shipped_at) * 1.0 / COUNT(*). It was right for a while. The…
Should a Rego allow rule default to false?
{"approved": false} and {} get the same answer from allow if input.approved == true. The answer is undefined, not false. The…
