#sqlpartition — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlpartition, aggregated by home.social.
-
Why does this SQL partition skip data?
Why does this SQL partition skip data in reporting. The SQL query filters on a partition boundary with the wrong timezone, so rows land in the wrong partition. In SQL analytics this miscounts totals.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlpartition #sqltimezonebug #sqlr...