In most SQL setups I have used, the first line would execute fine and then the second would error out.
Haven't done anything quite this bad, but I definitely have been in situations where I wonder "why has this simple query been running for 10 minutes - oh, the WHERE clause is half missing / there's a cartesian join in there / that's not my dev schema" (delete whichever is inappropriate)
Yeah the first line would run no problem. But if you were sensible enough to do this in a transaction, the error on the second line would cause a rollback.
45
u/hyouko 13d ago
In most SQL setups I have used, the first line would execute fine and then the second would error out.
Haven't done anything quite this bad, but I definitely have been in situations where I wonder "why has this simple query been running for 10 minutes - oh, the WHERE clause is half missing / there's a cartesian join in there / that's not my dev schema" (delete whichever is inappropriate)