What's wrong with this SQL NULL filter?
What's wrong with this SQL NULL filter in a cleanup job. The SQL code uses = NULL instead of IS NULL, so the filter never matches. In SQL maintenance this leaves stale rows forever.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlnullfilter #sqlisnull #sqlcleanup #sqlmaintenance
Why does this SQL delete skip rows?
Why does this SQL delete skip rows in a cleanup job. The SQL code deletes with LIMIT and OFFSET, so rows shift and some never get deleted. In SQL maintenance this leaves stale data forever.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqldelete #sqloffsetbug #sqlcleanup #sqlmainten...
PrecisionSQL