What's wrong with this SQL REPLACE deleting related rows?
What's wrong with this SQL REPLACE deleting related rows. The SQL code uses REPLACE instead of INSERT ON DUPLICATE. In MySQL REPLACE deletes then inserts, firing deletes on child tables. In SQL this cascades to data loss.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengine...
What's wrong with this SQL dividing integers?
What's wrong with this SQL dividing integers losing decimals. The SQL code divides two integer columns. In SQL integer division truncates to integer. In SQL analytics this undercounts rates and percentages.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqldivision #sqlinte...
How to Use Temporary Tables to Replace Slow Subqueries
Materialize once. Query fast.
What's wrong with this SQL connection using wrong charset?
What's wrong with this SQL connection using wrong charset. The SQL code connects without specifying charset. In MySQL wrong default corrupts Unicode. In SQL you get mojibake in the database.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcharset #sqlutf8 #sq...
What's wrong with this SQL INSERT ON DUPLICATE overwriting everything?
What's wrong with this SQL INSERT ON DUPLICATE overwriting everything. The SQL code uses ON DUPLICATE KEY UPDATE with VALUES(). In SQL on duplicate it overwrites even columns you did not mean to change. In SQL upserts this corrupts data.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics...
What's wrong with this SQL DISTINCT hiding duplicate inserts?
What's wrong with this SQL DISTINCT hiding duplicate inserts. The SQL code uses DISTINCT to dedupe. In SQL DISTINCT masks the fact that duplicates were written. In SQL the root cause stays and grows.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqldistinct...
Why does this SQL cache stampede?
Why does this SQL cache stampede under load. The SQL layer recomputes values on expiry without a lock, so every request hits the database. In SQL services this melts the backend.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcachestampede #sqlcacherefresh #sqldatabaseload #sqlperfo...
How to Stop DISTINCT From Hiding Data Problems
DISTINCT can mask duplicate writes.
Why does this SQL retry backoff melt servers?
Why does this SQL retry backoff melt servers during outages. The SQL job retries on a fixed schedule without jitter, so all workers stampede at once. In SQL pipelines this keeps the outage alive.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlretrybackoff #sqlthunderingh...
Why does this SQL MERGE overwrite when it should not?
Why does this SQL MERGE overwrite when it should not. The SQL code uses MERGE with a WHEN MATCHED that always runs. In SQL the logic can overwrite rows you intended to skip. In SQL sync jobs this corrupts data.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlmerge...
