this post was submitted on 09 Dec 2023
1187 points (97.4% liked)

Programmer Humor

19331 readers
20 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
1187
It's that time of the year again! (files.mastodon.social)
submitted 10 months ago by masimatutu@nerdica.net to c/programmer_humor@programming.dev
58 comments fedilink hide all child comments
 

files.mastodon.social/media_at…

you are viewing a single comment's thread
view the rest of the comments
[–] Moops@lemmy.world 17 points 10 months ago* (last edited 10 months ago) (2 children)

At the very least I'd try to clean up that fuzzy condition on behavior to anticipate any bad or inconsistent data entry.

WHERE UPPER(TRIM(behavior)) = 'NICE'

Depending on the possible values in behavior, adding a wildcard or two might be useful but would need to know more about that field to be certain. Personally I'd rather see if there was a methodology using code values or existing indicators instead of a string, but that's often just wishful thinking.

Edit: Also, why dafuq we doing a select all? What is this, intro to compsci? List out the values you need, ya heathen ;)

(This is my favorite Xmas meme lol)

[–] mp04610@lemm.ee 12 points 10 months ago

behavior is an ENUM.

[–] moroni@lemmy.ca 4 points 10 months ago

That’s a table scan, right there. Naughty.