#sqlstoredproce — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlstoredproce, aggregated by home.social.
-
Why does this SQL stored procedure break when you add a column?
Why does this SQL stored procedure break when you add a column. The SQL code uses SELECT * in a procedure. In SQL the result shape changes on schema change. In SQL procedures that call it crash.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlstoredproce...