|
If this is how you write your SQL, I don't want to work there
Last post 02-19-2013 10:24 PM by Kittemon. 61 replies.
-
-
-
-
-
dkf


- Joined on 04-24-2008
- Manchester, UK
- Posts 158
|
Re: If this is how you write your SQL, I don't want to work there
phynol:TTD? Must be a new fad.
Maybe they're looking for someone really into Transport Tycoon Deluxe.
|
|
-
-
Hatshepsut


- Joined on 07-26-2007
- Posts 149
|
Re: If this is how you write your SQL, I don't want to work there
ubersoldat:At least it's a funny way of filtering candidates
No it's not.
|
|
-
-
Shoreline


- Joined on 11-14-2012
- Posts 46
|
Re: If this is how you write your SQL, I don't want to work there
dhromed:"salary ASC" is a nice touch.
Yeah but they left out "team player", "goal oriented" and "hit the ground running".
Sorry, the president's daughter is in another castle.
|
|
-
-
LoremIpsumDolorSitAmet


- Joined on 10-15-2012
- London
- Posts 34
|
Re: If this is how you write your SQL, I don't want to work there
So if I have an excellent personality they'll pay me anything I want? I might just move to Munich for that.
|
|
-
-
Severity One


- Joined on 12-04-2008
- Malta
- Posts 346
|
Re: If this is how you write your SQL, I don't want to work there
AND 'tech.zend_framework' LIKE 'pro%'
My Zend skills are "problematic to say the least",so that makes me a perfect match for this job. Right?
|
|
-
-
Zecc


- Joined on 06-12-2007
- and hasn't left since.
- Posts 1,676
|
Re: If this is how you write your SQL, I don't want to work there
Severity One: AND 'tech.zend_framework' LIKE 'pro%'
My Zend skills are "problematic to say the least",so that makes me a perfect match for this job. Right?
I was going to say I 'promised not to touch it ever again'. Btw, there is a bug on line 23. It should be: $applicant = <<<EOD
If mixed metaphors were illegal, I'd be having an indigestion. typeof NaN == 'number' var ò_ó, ಠ⁔ಠ, ᄒᆺᄒ, ᅙᅳᅙ, ᖛᨓᖜ, ꖴᅩꖴ, ఠᨋఠ; // Naming your variables is serious business
|
|
-
-
TGV


- Joined on 10-09-2005
- Posts 552
|
Re: If this is how you write your SQL, I don't want to work there
Shoreline: dhromed:"salary ASC" is a nice touch.
Yeah but they left out "team player", "goal oriented" and "hit the ground running".
You must have overlooked "personality DESC". Didn't you take SQL-for-job-sites 101? Personality DESC sorts like this: - team player - senior - quality oriented
- professional
- obstinate - nerdy - management fad sensitive
- intelligent
- hit the ground running - highly intelligent
- goal oriented
|
|
-
-
TGV


- Joined on 10-09-2005
- Posts 552
|
Re: If this is how you write your SQL, I don't want to work there
ubersoldat:At least it's a funny way of filtering candidates
If you want to work with nerdy German hermaphrodites...
|
|
-
-
dhromed


- Joined on 04-13-2005
- Dutchland
- Posts 10,087
|
Re: If this is how you write your SQL, I don't want to work there
TGV:If you want to work with nerdy German hermaphrodites... Why? What's wrong with that?
 boomzilla: I think the obvious answer is for everyone to just stop programming.
|
|
-
-
SeekerOfThings


- Joined on 12-07-2012
- Posts 2
|
Re: If this is how you write your SQL, I don't want to work there
So... My '3 minutes' of work experience should put me in the running? I actually did 9 years, but those days are long behind me now.
|
|
-
-
daveime


- Joined on 08-28-2009
- Posts 31
|
Re: If this is how you write your SQL, I don't want to work there
dhromed:"salary ASC" is a nice touch.
Yes, because nothing is more amenable to storing values such as "I don't know", "Flexible", "> 40k", "Will work for peanuts" than a LONGINT
The real WTF is that it takes 60 seconds to post a message on this board and then the error message asks YOU who the site administrator is, because apparently the site administrator doesn't know.
|
|
-
-
dhromed


- Joined on 04-13-2005
- Dutchland
- Posts 10,087
|
Re: If this is how you write your SQL, I don't want to work there
daveime:Yes, because nothing is more amenable to storing values such as "I don't know", "Flexible", "> 40k", "Will work for peanuts" than a LONGINT The joke is that apparently they want to pay as little as humanly possible, but nice try.
 boomzilla: I think the obvious answer is for everyone to just stop programming.
|
|
-
-
boomzilla


- Joined on 12-11-2007
- NOVA
- Posts 3,768
|
Re: If this is how you write your SQL, I don't want to work there
dhromed:
TGV:
If you want to work with nerdy German hermaphrodites...
Why? What's wrong with that?
It's just disconcerting if you were expecting Polish lesbians.
|
|
-
-
dhromed


- Joined on 04-13-2005
- Dutchland
- Posts 10,087
|
Re: If this is how you write your SQL, I don't want to work there
boomzilla:
It's just disconcerting if you were expecting Polish lesbians. "I've been had!" "Yes, but not the way you think."
 boomzilla: I think the obvious answer is for everyone to just stop programming.
|
|
-
-
Sutherlands


- Joined on 07-24-2008
- Posts 1,419
|
Re: If this is how you write your SQL, I don't want to work there
I wouldn't work there because of the PHP and the iMac. What's so horrendous about the SQL?
|
|
-
-
balazs


- Joined on 02-13-2013
- Posts 5
|
Re: If this is how you write your SQL, I don't want to work there
I have 11 years experience in jqQuery (WHAT?), so I don't fit.
|
|
-
-
blakeyrat


- Joined on 10-29-2008
- Posts 8,602
|
Re: If this is how you write your SQL, I don't want to work there
ubersoldat:At least it's a funny way of filtering candidates
No. They were trying to make it funny. It is just sad and depressing.
What does "personality descending" imply? They want someone condescending? They want a robot? I don't get it.
 <- I couldn't make my shit work, so here's a Godzilla head. "There is no such thing as a diet." - Lorne Kates
|
|
-
-
joe.edwards


- Joined on 08-14-2006
- Dallas, TX
- Posts 1,135
|
Re: If this is how you write your SQL, I don't want to work there
blakeyrat:What does "personality descending" imply? They want someone condescending? They want a robot? I don't get it.
order by foo desc usually implies you want to sort by foo largest value to smallest value, so someone with a high personality stat.
I spend most of my life pressing buttons to make the pattern of lights change however I want.
|
|
-
-
boomzilla


- Joined on 12-11-2007
- NOVA
- Posts 3,768
|
Re: If this is how you write your SQL, I don't want to work there
joe.edwards:
blakeyrat:
What does "personality descending" imply? They want someone condescending? They want a robot? I don't get it.
order by foo desc usually implies you want to sort by foo largest value to smallest value, so someone with a high personality stat.
I think they just want someone willing to bring their own office furniture.
|
|
-
-
Shoreline


- Joined on 11-14-2012
- Posts 46
|
Re: If this is how you write your SQL, I don't want to work there
It's their way of saying "personality is not a dump stat".
As for "salary ASC", what happened to being valued based on correlation with your requested salary?
Sorry, the president's daughter is in another castle.
|
|
-
-
blakeyrat


- Joined on 10-29-2008
- Posts 8,602
|
Re: If this is how you write your SQL, I don't want to work there
joe.edwards:order by foo desc usually implies you want to sort by foo largest value to smallest value, so someone with a high personality stat.
... meaning? I'm sorry is "personality" something that can be measured from low to high now? What the fuck is this shit.
Would you guys say I have a "high" personality or a "low" one?
 <- I couldn't make my shit work, so here's a Godzilla head. "There is no such thing as a diet." - Lorne Kates
|
|
-
-
dhromed


- Joined on 04-13-2005
- Dutchland
- Posts 10,087
|
Re: If this is how you write your SQL, I don't want to work there
blakeyrat:Would you guys say I have a "high" personality or a "low" one? Nobody here has a high CHR stat. Well, except for me.
 boomzilla: I think the obvious answer is for everyone to just stop programming.
|
|
-
-
blakeyrat


- Joined on 10-29-2008
- Posts 8,602
|
Re: If this is how you write your SQL, I don't want to work there
dhromed:Nobody here has a high CHR stat.
Charisma can be measured low to high, I'd be ok with that. What we're talking about is personality, where the concept makes no goddamned sense.
 <- I couldn't make my shit work, so here's a Godzilla head. "There is no such thing as a diet." - Lorne Kates
|
|
-
-
-
RHuckster


- Joined on 06-08-2008
- Posts 759
|
Re: If this is how you write your SQL, I don't want to work there
These guys are laughing until they hire a person whose Zend Framework skills have the value, "Prohibited from Using at Current Job"
|
|
-
-
Sutherlands


- Joined on 07-24-2008
- Posts 1,419
|
Re: If this is how you write your SQL, I don't want to work there
blakeyrat:Would you guys say I have a "high" personality or a "low" one?
Definitely low.
|
|
-
-
verisimilidude


- Joined on 06-25-2010
- Posts 7
|
Re: If this is how you write your SQL, I don't want to work there
They are posting on Spanish Monster for a job in Germany. I'll bet they are looking for refugees from the Spanish economy who don't know how expensive Munich is. If the 'personality' attribute has two values (acceptable, not_acceptable) they will take the cheapest / most desperate.
|
|
-
-
Lorne Kates


- Joined on 01-19-2010
- Markham, ON
- Posts 1,509
|
Re: If this is how you write your SQL, I don't want to work there
RHuckster:These guys are laughing until they hire a person whose Zend Framework skills have the value, "Prohibited from Using at Current Job" Mine is "probiotic"
 <%= Eval("sig_owner") ?>! <asp:Label runat="server" id="lblGetYourOwn" Text="Get your own!" />
|
|
-
-
boomzilla


- Joined on 12-11-2007
- NOVA
- Posts 3,768
|
Re: If this is how you write your SQL, I don't want to work there
Lorne Kates:
RHuckster:
These guys are laughing until they hire a person whose Zend Framework skills have the value, "Prohibited from Using at Current Job"
Mine is "probiotic"
pronged purple dildo
|
|
-
-
DCRoss


- Joined on 07-25-2009
- Tronna
- Posts 92
|
Re: If this is how you write your SQL, I don't want to work there
verisimilidude:If the 'personality' attribute has two values (acceptable, not_acceptable) they will take the cheapest / most desperate.
Of course. That's why their query sorts the applicants by salary, in ascending order.
|
|
-
-
mihi


- Joined on 05-10-2008
- Posts 92
|
Re: If this is how you write your SQL, I don't want to work there
What strikes me most is that the return value of interview is not checked (and in case it throws an exception, the exception is not caught and another candidate tried) :D
|
|
-
-
MiffTheFox


- Joined on 07-02-2008
- Posts 969
|
Re: If this is how you write your SQL, I don't want to work there
$teamMember->setupWorkEnviroment( $this-
>addDevices('iMac')
->addDevice('iOS')-
Who the fuck formats their code like this?
[Sanity Not Available until further notice. The trolls have won.]
|
|
-
-
Nagesh


- Joined on 01-31-2011
- Hyderabad, India
- Posts 888
|
Re: If this is how you write your SQL, I don't want to work there
MiffTheFox:$teamMember->setupWorkEnviroment( $this-
>addDevices('iMac')
->addDevice('iOS')-
Who the fuck formats their code like this? German Developer I think.
|
|
-
-
veggen


- Joined on 05-07-2010
- Posts 63
|
Re: If this is how you write your SQL, I don't want to work there
I dunno, I like the ad. Also, not sure if you guys are actually being pedantic dickweeds with all the "omg, joke SQL is not real SQL" or if that's some kind of a meta joke I don't get. :shrug:
|
|
-
-
blakeyrat


- Joined on 10-29-2008
- Posts 8,602
|
Re: If this is how you write your SQL, I don't want to work there
veggen:or if that's some kind of a meta joke I don't get.
All my posts are meta-jokes you don't get. Especially this one.
 <- I couldn't make my shit work, so here's a Godzilla head. "There is no such thing as a diet." - Lorne Kates
|
|
-
-
esoterik


- Joined on 11-10-2010
- Posts 167
|
Re: If this is how you write your SQL, I don't want to work there
MiffTheFox:$teamMember->setupWorkEnviroment( $this-
>addDevices('iMac')
->addDevice('iOS')-
Who the fuck formats their code like this?
German hermaphrodites apparently!
This is the best thing Go has ever produced:[quote user="morbiuswilters"][quote user="Ben L."]Since when is a lowercase type's lowercase field public?[/quote] Fucking hell.[/quote]
|
|
-
-
dhromed


- Joined on 04-13-2005
- Dutchland
- Posts 10,087
|
Re: If this is how you write your SQL, I don't want to work there
veggen:I dunno, I like the ad. Nobody likes you.
 boomzilla: I think the obvious answer is for everyone to just stop programming.
|
|
-
-
boh


- Joined on 03-05-2007
- Posts 76
|
Re: If this is how you write your SQL, I don't want to work there
I like how they want someone to work in Munich, but they rule out everyone who is fluent in German.
|
|
-
-
balazs


- Joined on 02-13-2013
- Posts 5
|
Re: If this is how you write your SQL, I don't want to work there
boh:I like how they want someone to work in Munich, but they rule out everyone who is fluent in German.
It is dangerous to know too much in Munich.
|
|
-
-
dkf


- Joined on 04-24-2008
- Manchester, UK
- Posts 158
|
Re: If this is how you write your SQL, I don't want to work there
Sutherlands:What's so horrendous about the SQL?
The worst part is definitely the single quotes around what I guess are meant to be field references, turning them into simple string values. The query is going to do the wrong thing and the creators of it appear to have no concept of why. (Also, it seems odd that there's no constraint on PHPdev knowing PHP, but that's perhaps done at the view level. Bah! Who am I kidding? Views? What's that? </cynic>)
|
|
-
-
LoremIpsumDolorSitAmet


- Joined on 10-15-2012
- London
- Posts 34
|
Re: If this is how you write your SQL, I don't want to work there
Good observation - I didn't spot those quotes in the SQL at first. Also, I have an issue with the first line. Can you actually redefine $this in PHP? Maybe they're in the global scope? It's been a while.
|
|
-
-
Severity One


- Joined on 12-04-2008
- Malta
- Posts 346
|
Re: If this is how you write your SQL, I don't want to work there
boh:I like how they want someone to work in Munich, but they rule out everyone who is fluent in German.
That means they don't want to hire Germans, which is, let's face it, perfectly understandable.
|
|
-
-
no laughing matter


- Joined on 10-10-2011
- Posts 6
|
Re: If this is how you write your SQL, I don't want to work there
Lorne Kates:
'Profanities will follow whenever you mention that framework!'
Let's see:
- $applicant = << SELECT * ... LIMIT 1
They want to interview only one applicant!
- JOIN 'knows_concept' .... AND 'concept.OOP' = true
If we forget about the apostrophes for a moment, this would mean they have modelled knowledge both as a relation / table and as separate columns for each knowledge. Normalization WTF!?!
- 'tech.jQquery' - wait what?
- $this->interview(applicant) - What about the results of the interview? Or are they using dirty side-effects here?
- ->addDevices('iMac')
->addDevive('iOS') Both plural and singular form? 'iOS' is a device now?
|
|
-
-
Weng


- Joined on 03-15-2008
- Posts 1,490
|
Re: If this is how you write your SQL, I don't want to work there
dkf: Sutherlands:What's so horrendous about the SQL?
The worst part is definitely the single quotes around what I guess are meant to be field references, turning them into simple string values. The query is going to do the wrong thing and the creators of it appear to have no concept of why. (Also, it seems odd that there's no constraint on PHPdev knowing PHP, but that's perhaps done at the view level. Bah! Who am I kidding? Views? What's that? </cynic>)
Subtle! I'm interviewing a SQL developer candidate this afternoon, and will be printing this out for the puzzles-n-stuff part of the interview. Better than my usual "tack our production database schema to the wall and print a stored procedure listing, and if the candidate doesn't attempt to flee, they aren't qualified" technique, anyway.
|
|
-
-
MiffTheFox


- Joined on 07-02-2008
- Posts 969
|
Re: If this is how you write your SQL, I don't want to work there
no laughing matter:- ->addDevices('iMac')
->addDevive('iOS') Both plural and singular form? 'iOS' is a device now?
addDevice really means addOperatingSystem. They made the mistake in naming it addDevice instead and now it's too late to change it. When they wanted to add a function for actually adding a device they had to call it addDevices.
[Sanity Not Available until further notice. The trolls have won.]
|
|
-
-
DCRoss


- Joined on 07-25-2009
- Tronna
- Posts 92
|
Re: If this is how you write your SQL, I don't want to work there
MiffTheFox:addDevice really means addOperatingSystem. They made the mistake in naming it addDevice instead and now it's too late to change it. When they wanted to add a function for actually adding a device they had to call it addDevices. Just wait until you see the other functions: newAddDevices, newRealAddDevices, realAddDevices, devicesRealAddNew and realNewAddDevicesAndWeMeanItThisTime.
|
|
-
-
dkf


- Joined on 04-24-2008
- Manchester, UK
- Posts 158
|
Re: If this is how you write your SQL, I don't want to work there
DCRoss:Just wait until you see the other functions: newAddDevices, newRealAddDevices, realAddDevices, devicesRealAddNew and realNewAddDevicesAndWeMeanItThisTime.
Nawww, it'd be addDevicesEx and addDevices2Ex. And, given that it's PHP, devices_addEx_2, and exAdd_device_s.
|
|
|
|
|