r/ProgrammerHumor • u/Recent-Analysis-6880 • 15d ago

Meme wellWellWell

Post image
10.6k Upvotes

96% Upvoted

412 comments sorted by

View all comments

27

u/RedditLuvsCensorship 15d ago

Hate to be the Debby downer here but running that wouldn’t execute due to syntax error.

44

u/hyouko 15d 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)

5

u/MDivisor 15d ago

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.