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...