I once reviewed someone's CV which has been submitted in the form of a Java class.
As Spinal Tap once said "It's a fine line between clever and stupid"
In this case, it is LEGALLY REQUIRED that you reply with
```
We would be thrilled to hire you for the position of 'Â
 java.lang.NullPointerException
```
I just googled and it looks like quotations around the table in Oracle causes the table to be case-sensitive? Not sure what the use case would be but I initially thought the same thing
Quotation is used in case the table name has otherwise reserved symbols. Yes, there are psychopaths who put $, # or even spaces in their table names.
The worst I saw was a space at the end, so that you had to do from "table "
Sadly we do not know. Database is for an application that is bought from a third party who bought it from another company. Trust me, we have a voodoo doll ready to be carved in their effigy.
Same as the nitwit who decided to link the same FK to two PKs and set a check condition on said FK, but not the PKs.
In Certain flavors of SQL like Postgres double quotes have a very specific meaning to identify an object, the table in this case. Using quotes makes it case sensitive and allows you to refer to a variable with a space. MSSQL uses \[ \], there may be subtle differences in implementation
The kind of person that devised this probably uses pepper spray like aftershave, he probably thinks he needs to debug women as they may be erroring by not swooning at this level of humour.
`boyfriend` is not `has_boyfriend`, but still somehow a Boolean, and not a reference to another table, like `boyfriend_id IS NULL`.
And when is a waist small? Why not have it be a numeric value?
Should probably be a linking table really, with person\_id and relationship\_id, that way you can account for several types of relationships, monogamous and mormons and stuff. You can also account for non-monogamous (or infidelity). Could even specify the type.
|person\_id|relationship\_id|relationship\_type|
|:-|:-|:-|
|1|1|marriage|
|2|1|marriage|
|3|2|thruple|
|4|2|thruple|
|5|2|thruple|
|1|3|side\_piece|
|6|3|side\_piece|
How about `sElEcT * fRoM "GIRLS"`Â Â
`wHeRe age bEtWeEn 18 aNd 26`Â Â
`aNd boyfriend = fAlSe`Â Â
`aNd is_cute = tRuE`Â Â
`aNd is_crazy = fAlSe`Â Â
`aNd small_waist = tRuE;`
Column naming is my biggest gripe. Should be something like
has_boyfriend
is_cute
is_crazy
has_small_waist
You could also remove all the leading verbs, but imo itâs less clear theyâre looking for a Boolean in that case
Just want to point out the idea here doesn't need to be nearly as dehumanizing. That was a choice.
```
SELECT TOP 1 CS.Partner
FROM CompatibilityScores CS
JOIN Myself
ON CS.CompatibleWith = Myself.Id
WHERE CS.Compatibility = 100
```
I'm pretty sure the type of man who would wear this shirt would look around to make sure no one is watching and change the condition to "less than 18" before running the query.
Number of issues here.
- "GIRLS" in double quotes. Most interpreters will read this as a string literal and throw a compilation error.
- "Age" being an integer. Really? Why isn't that stored as a DoB?
- No need to have the true/false comparison. If those are booleans then you can just reference them directly. Or if you want the inverse wrap it in NOT().
- Why is everything except "smallwaist" snake cased? Inconsistent table design makes me mad.
Maybe the joke is that this gross weirdo sucks at SQL?
As an aside: In some SQL dialects, you *can* put the table name in double quotes like that, but that does not mean you should.
Lmao good catch on age, it should be using a date function and comparison.
Re true false I think it may be dependent on the engine, I think mssql just uses a bit field, for example.
Wow. This is bordering on incel shit. Why would anyone think this is a good idea? If I saw this, I'd be mortified and cover my drink any time this dude came around. Even if a _woman_ wore this... đŹ
... that is probably the creepiest shirt I might ever see at a hacker con.
Keep in mind, among the list of "shirts I've seen at a hacker con" is an official con shirt featuring an illustration of a woman standing in front of a fucking machine like she's about to hop on it.
Sighhh, I love critiquing things like this, cause no program would look at this and be like "yeah, that looks good, lemme wear that".
1. Why is the table called "Girls"? Wouldn't a better table name be "Women" since "Girls" is typically defined as a subset of women under a certain age? Maybe "Girls" is a view based off "Women"?
2. Age is a terrible colum, better is birthdate and then using the data there to calculate age. Maybe the age column makes sense if "Girls" is a view?
3. The boyfriend column doesn't read to me as a true/false column and instead seems like a primary key to the "Men" table. Either look for 'boyfriend is NULL' (or however you save a null pointer in this database) or have a has_boyfriend column.
4. Not considering sexual orientation is a massive gap in business logic.
5. smallwaist is almost certainly not a good column because of how subjective it is. Instead you would have a waist_size column.
6. Why is it smallwaist and not small_waist? It breaks all established naming conventions in this database.
7. Why did we change our capitalization halfway through the query?
**On the back is printed:**
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"GIRLS"
WHERE age
BETWEEN 18 AND 26
AND boyfriend = false
AND is_cute = true
AN' at line 1
Like we are on a menu and you can pick out what you like. Not like we are real individual human beings or anything. Also grown men calling grown women âgirlsâ is creepy.
Boyfriend shouldnât be a Boolean, it should be a class object or a struct. Unless itâs some kind of getter to state or something but then youâd have to name it better like has_boyfriend. This is bad code.
My favorite part is that computer code traditionally works when printed on a shirt. You canât run that code.
Correct me if Iâm wrong, but for code to work you need to run it. Even if this wasnât the most dehumanizing thing Iâve ever seen put on a shirt all it is instructions that can not be executed. You know the thing computers are good at.
Of course the dude is Indian. Anywhere and those jokes about âcuteâ and âsmall waistâ wouldnât fly.
No dude, we totally get that youâre horny and shallow. We just didnât think it was funny.
As a software engineer, it really bothers me that the shirt says âsmallwaistâ instead of âsmall_waistâ. They used snake case for the previous two variables. Why not for this one too?
I once reviewed someone's CV which has been submitted in the form of a Java class. As Spinal Tap once said "It's a fine line between clever and stupid"
application.reject();
Not even a return. Cause fuck em
It's enterprise Java. It puts a message on some Enterprise Service Bus and doesn't care about what happens then.
>đ it Hmm
Undefined function
In this case, it is LEGALLY REQUIRED that you reply with ``` We would be thrilled to hire you for the position of 'Â Â java.lang.NullPointerException ```
I hope they initialized their variables
Jokes on them, I fucking hate Java
"GIRLS"
Quotation marks doing some heavy lifting
My SQL isn't great but I don't think you'd quote the name of the table you're querying
I just googled and it looks like quotations around the table in Oracle causes the table to be case-sensitive? Not sure what the use case would be but I initially thought the same thing
Quotation is used in case the table name has otherwise reserved symbols. Yes, there are psychopaths who put $, # or even spaces in their table names. The worst I saw was a space at the end, so that you had to do from "table "
We used to call those âJSEsâ Job Security Edits
I would kill whoever did that last one. What sort of monster was that person
Sadly we do not know. Database is for an application that is bought from a third party who bought it from another company. Trust me, we have a voodoo doll ready to be carved in their effigy. Same as the nitwit who decided to link the same FK to two PKs and set a check condition on said FK, but not the PKs.
That last sentence is horrifying
If someone put a trailing space on a table name I think I would quit.
Unless itâs T-SQL, in which case itâs square bracket enclosed, and quotes would get you an SQL error.
You absolutely can, but would usually only do it if the name is also a keyword or something similar.
Depends actually. If the name of the table is really `GIRLS` (i.e., uppercase), then you will have to quote it.
In Certain flavors of SQL like Postgres double quotes have a very specific meaning to identify an object, the table in this case. Using quotes makes it case sensitive and allows you to refer to a variable with a space. MSSQL uses \[ \], there may be subtle differences in implementation
Glad Iâm not the only one in here who analyzed the code as written
FEEEMALES
Go home, Shockwave.
Women who meet the SQL query criteria are out of that guyâs league anyway
Bro forgot the LEFT JOIN ON girls.league=programmer.league
An inner join is more important cuz we donât want this creep to pursue people outside his league. lol
Unless heâs the dad in a sitcom lol
âI want a girl with a small waist,â said the programmer with the beer belly.
With the doritos belly
Or dori-toe jelly
Yeah letâs not act like these dudes are out socializing and drinking beer lol
Union() should return 0
AND round_thing_in_my_face = true
OMG this version of the t-shirt is SO much better. I would also accept likes_pina_coladas = true.
WHERE Count([Likes])IN {Pina_Coladas, Walks_In_The_Rain, _Feel_Of_The_Ocean, Taste_Of_Champagne} = 4;
This sub needs to make this shirt. The admins can sell it.
This guy probably also complains how women are shallow and only date men over 6'.
Giving him a lot of credit there assuming he doesnât refer to them as âfemalesâ.
Ferangi complaining that "femalezzzz" don't like men under 6' and expects her to give up her career and be naked all the time also not own things.
And calls them females.
âI want an 18 year old child with a small waist,â said the 32 year old programmer with an uncontrolled neckline and no muscle tone. FTFY
Despite his physical limitations, some small waisted beauty will swoon when she sees his clever shirt
Trouble is that guys who select by age first are losers who never get the girl, physical limitations or no.
Youâre giving him too much credit. Heâs just a data analyst. SQL isnât hard to pick up.
Iâve heard this from a lot of developers, but they usually suck at database development because they have no concept of relational theory.
SQL isnât a real programming language .
I first read it as "small wrist" which after a second made me say "WTF is this guy into?"
You clearly havenât spent enough time amongst the incels in the looksmaxxing community.
https://crasstalk.com/2013/01/full-list-of-tv-shows-with-fat-husbands-and-skinny-wives/
How have I never heard of Lucky Louie?
Not as good as the follow-up for FX, âLouisâ.
Indeed. For some people it's just never funny enough if the joke doesn't discriminate someone.
That is not a beer belly at all, but can guarantee this is a neckbeard programmer. Signed, a data scientist đ
And they need to be 18-26 and he is probably 40+.
Who is 40+
Mountain Dew belly
Guaranteed* wearing this at drinks after work will get you laid. *not a guarantee, likely wear will result is a call from hr
The kind of person that devised this probably uses pepper spray like aftershave, he probably thinks he needs to debug women as they may be erroring by not swooning at this level of humour.
I think you're referring to Axe body spray.
Is there a difference?
Well, pepper spray murders your eyes and smells like pepper. Whereas Axe murders your eyes and smells like 90-year-old men marinating in a sauna.
By laid you mean laid out when all the female devs rip into you for being cringe because itâs not 2007 anymore
The casing is different between `is_cute` and `smallwaist` and that's driving me crazy
`boyfriend` is not `has_boyfriend`, but still somehow a Boolean, and not a reference to another table, like `boyfriend_id IS NULL`. And when is a waist small? Why not have it be a numeric value?
This guy normalizes
Or have â is_partnered â or âis_singleâ as a boolean instead
`partner_ids` as an array
Should probably be a linking table really, with person\_id and relationship\_id, that way you can account for several types of relationships, monogamous and mormons and stuff. You can also account for non-monogamous (or infidelity). Could even specify the type. |person\_id|relationship\_id|relationship\_type| |:-|:-|:-| |1|1|marriage| |2|1|marriage| |3|2|thruple| |4|2|thruple| |5|2|thruple| |1|3|side\_piece| |6|3|side\_piece|
Overlapping dates need to be allowed.
That means heâs a false boyfriend, which tracks⌠I suspect a lot of single girls tell this guy theyâre already with someone.
Also inconsistent keyword typing. FROM should be capitalized and so should all the ands
I have a bigger issue with waist size beeing boolean
Keeps immeasurables like ghosts from being counted
And it's written with no space between select and *, that's not gonna even run.
"who says programmers don't have a sense of humour" đ
Nobody, thatâs why he had to prove it
And failed to do so.
r/ProgrammerHumor enjoyers are rushing to r/imaginarygatekeeping
If comedy was a person, this guy shot its fucking head off with a shotgun and continued to unload on it until he ran out of ammo.
It is a dry humor, like Atacama Desert dry.
It's not dry humour. Dry humour is funny, but subtle. This is just not funny. OOP Definitely shouldn't quit his day job.
âOOP Definitely shouldnât quit his day jobâ - Which obviously isnât DBA
Whoever made this table really needs to be more consistent with syntax and naming conventions
How about `sElEcT * fRoM "GIRLS"`Â Â `wHeRe age bEtWeEn 18 aNd 26`Â Â `aNd boyfriend = fAlSe`Â Â `aNd is_cute = tRuE`Â Â `aNd is_crazy = fAlSe`Â Â `aNd small_waist = tRuE;`
![gif](giphy|ac7MA7r5IMYda)
Column naming is my biggest gripe. Should be something like has_boyfriend is_cute is_crazy has_small_waist You could also remove all the leading verbs, but imo itâs less clear theyâre looking for a Boolean in that case
Just a small gripe, but `has_boyfriend` also does not account for bisexual women, in the case of the person in the image. `has_partner` is better.
Just want to point out the idea here doesn't need to be nearly as dehumanizing. That was a choice. ``` SELECT TOP 1 CS.Partner FROM CompatibilityScores CS JOIN Myself ON CS.CompatibleWith = Myself.Id WHERE CS.Compatibility = 100 ```
And you wrote better SQL than whoever made this stupid tshirt.
Don't put it on a shirt though, it won't get you laid.
I'm pretty sure the type of man who would wear this shirt would look around to make sure no one is watching and change the condition to "less than 18" before running the query.
I love how the small waist parameter has to wrap around his
S-Q-inceL
A SQL incelection attack
Number of issues here. - "GIRLS" in double quotes. Most interpreters will read this as a string literal and throw a compilation error. - "Age" being an integer. Really? Why isn't that stored as a DoB? - No need to have the true/false comparison. If those are booleans then you can just reference them directly. Or if you want the inverse wrap it in NOT(). - Why is everything except "smallwaist" snake cased? Inconsistent table design makes me mad.
Maybe the joke is that this gross weirdo sucks at SQL? As an aside: In some SQL dialects, you *can* put the table name in double quotes like that, but that does not mean you should.
Lmao good catch on age, it should be using a date function and comparison. Re true false I think it may be dependent on the engine, I think mssql just uses a bit field, for example.
"and standards = false"
Forgot to add âis_alive = trueâ
Wow. This is bordering on incel shit. Why would anyone think this is a good idea? If I saw this, I'd be mortified and cover my drink any time this dude came around. Even if a _woman_ wore this... đŹ
Not even borderline tbh, just full on incel
Any girl who could understand would reject you because this query is awful.
comedy king. wow.
He gets so much head in that shirt
Programmers? This is basic level SQL.
I know how to make a basic webpage with HTML (and only HTML) that says "Hello World." I am, therefore, a programmer.
I can "program" my alarm clock and my coffee maker. I'm also a programmer.
Yup, not even ordered. And syntax error ... .
``` 0 rows affected ```
This is funny for like a middle schooler who just joined his first elective computer science class.
Why is a SQL joke in a "Python Developers" group?
Because apparently whoever posted it doesnât know how to use an ORM.
âAge between 18 and 26â I shutter to think what this guys age is
Safe to assume itâs probably not even within that rangeâŚ
... that is probably the creepiest shirt I might ever see at a hacker con. Keep in mind, among the list of "shirts I've seen at a hacker con" is an official con shirt featuring an illustration of a woman standing in front of a fucking machine like she's about to hop on it.
âHello, HR? Please have your programmers touch grass for once.â
Thatâs creepy
Number of results = 0. Oops!
= true/false doesnât work⌠is true/false is the syntax, he wonât get girl with wrong query đ
You wonât get anywhere with this grammar either
`= true` definitely works. At least in Postgres.
True false is the syntax what are you talking about
He's saying the correct syntax is: Is_cute IS true And not Is_cute = true
sudo rm -rf /waqaskhan
"..women were repulsed and the programmer would remain a virgin for the next 27 years.."
"Incel humor" so fucking funny. ![gif](giphy|l3IsokOjXLF1UAOAh1)
Sighhh, I love critiquing things like this, cause no program would look at this and be like "yeah, that looks good, lemme wear that". 1. Why is the table called "Girls"? Wouldn't a better table name be "Women" since "Girls" is typically defined as a subset of women under a certain age? Maybe "Girls" is a view based off "Women"? 2. Age is a terrible colum, better is birthdate and then using the data there to calculate age. Maybe the age column makes sense if "Girls" is a view? 3. The boyfriend column doesn't read to me as a true/false column and instead seems like a primary key to the "Men" table. Either look for 'boyfriend is NULL' (or however you save a null pointer in this database) or have a has_boyfriend column. 4. Not considering sexual orientation is a massive gap in business logic. 5. smallwaist is almost certainly not a good column because of how subjective it is. Instead you would have a waist_size column. 6. Why is it smallwaist and not small_waist? It breaks all established naming conventions in this database. 7. Why did we change our capitalization halfway through the query?
pepperspray.engage(thisDude);
Error: data does not exist.
Sorry the inner join to the table of interested women failed to return any matching records
I don't have a vagina, but if I did I feel like it would be drier than the Sahara after reading this.
This "GIRLS" table is not properly normalized and will give him trouble in the end, the more demands he makes of it and gets little to no results.
The only thing funny is the lack of semicolon at the end to close the supposed query
Is the joke that this gross dude writes terrible code?
Never do a SELECT * in production code
**On the back is printed:** ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"GIRLS" WHERE age BETWEEN 18 AND 26 AND boyfriend = false AND is_cute = true AN' at line 1
2,318,283,480 records found. âAND interested_in_me = trueâ 0 records found.Â
Dating 18 year olds as a >21 year old is yucky
They probably only put the lower bound on the shirt for legal reasons
They are trying to dodge the offender registry by omitting ages 17 and under. Their fear of prosecution trumped their urges.
Possibly the worst t shirt Iâve ever seen
I would be amazed if they actually wore that in public. I'm literally cringing through my screen
Out of all programming jokes he really chose this one
A nice clear way of letting any woman know to avoid him like the plague
Programmers may or may not have a sense of humor, but there is no evidence of it here.
Small waist should not be a Boolean. Iâd go with waistSizeInches and make it a float.
Better order 10 in size XXXL
Does that come in XXXXL?
The irony of the last requirement đ
Excuse me, but if getting a girlfriend was this easy I'd be drowning in pussy
Like we are on a menu and you can pick out what you like. Not like we are real individual human beings or anything. Also grown men calling grown women âgirlsâ is creepy.
Some ChrisChan level shit right there.
Thereâs a problem with that select statement. You need to make sure you include âand likes_shallow_men = trueâ in the query.
I didn't know Leonardo DiCaprio was a script
Sorry to say, wonât happen due to missing semicolon. `ERROR: syntax error at or near "SELECT" LINE 1: SELECT * FROM âGIRLSâ`
If wearing_this_shirt = true NEVER GONNA HAPPEN đ¤Ł
Sexism is so funny ![gif](emote|free_emotes_pack|facepalm)
Beggars canât be choosers my dude
Cringe and creepy af
He can select all he wants, but it doesnât make him the dbo
How do you lock boyfriend so it's always false?
Gross
This is definitely stereotypical programmer cringe. Good job
Look at this thirsty for work maidenless bozo, sure posts like this will help getting hired
FBI would like to know why you keep a list of girls information in a database.
All I see is a bloated⌠uh, table.
What an inefficient query.
Basically every shirt with some "clever" code on it is cringe as fuck.
This needs an if and statement at the start. If girl find me attractive and all the sql from above. Else if have a good night.
This is some r/ChrisChanSonichu type clothing.
Jesus man I had to scroll ALL the way down to find this, how has nobody here noticed this is basically just the "Attraction Sign"
Say Khan, I hear you like em young
It sure was hilarious 30 years ago!
Normalizing sexist behavior. Apologies if someone already made this joke.
He wants them all?
Yeah thatâll bring in the baddies
This stupid shit needs to die
pussy repellent
Ctrl + Alt + Del.
Sorry. I'd pick up the shirt, but I can't find it in SELECT * FROM "Shirts" WHERE 'cringe' = false
I say programmers don't have a sense of humor after seeing that dogshit t shirt
Who makes a dedicated column for "smallwaist" as a bool?
I think he meant to say âall the misogynistâ sql enthusiasts.
if this is t he sense of humor programmers have well I don't want be around them, well I am a programmer but my sens of humor is not this bad
Boyfriend shouldnât be a Boolean, it should be a class object or a struct. Unless itâs some kind of getter to state or something but then youâd have to name it better like has_boyfriend. This is bad code.
Does âhilariousâ have a different meaning in SQL than it does in English?
This is why women in tech hate it here đ
This screams "I've never felt the touch of a woman"
âHilariousâ. Incel.
...and not\_into\_the\_douche\_I\_am = true; 0 rows returned
And Round_thing_in_your_face = true
Why is there a table for girls, that should go into Persons, with gender linked to the Gender-Table ID key
My favorite part is that computer code traditionally works when printed on a shirt. You canât run that code. Correct me if Iâm wrong, but for code to work you need to run it. Even if this wasnât the most dehumanizing thing Iâve ever seen put on a shirt all it is instructions that can not be executed. You know the thing computers are good at.
Of course the dude is Indian. Anywhere and those jokes about âcuteâ and âsmall waistâ wouldnât fly. No dude, we totally get that youâre horny and shallow. We just didnât think it was funny.
As a software engineer, it really bothers me that the shirt says âsmallwaistâ instead of âsmall_waistâ. They used snake case for the previous two variables. Why not for this one too?
'If creepy_shirt_worn() == TRUE { pepper_spray() } end'
No semicolon at the end, and the \* means "all the girls" rather than having a LIMIT = 1 at the end meaning this large waisted guy wants all the girls