#sqlmerge — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlmerge, aggregated by home.social.
-
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...
-
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...