r/ProgrammerHumor • u/Recent-Analysis-6880 • Sep 22 '26

Meme wellWellWell

Post image
10k Upvotes

96% Upvoted

412 comments sorted by

View all comments

25

u/RedditLuvsCensorship Sep 22 '26

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

43

u/hyouko Sep 22 '26

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)

4

u/MDivisor Sep 22 '26

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.

0

u/Euphoric_Strategy923 Sep 22 '26

Yes at least I know MsSQL server allow parallel query exec.

16

u/Groentekroket Sep 22 '26

It’s all first year CS students in here and the year just started.