The Daily WTF: Curious Perversions in Information Technology
Welcome to TDWTF Forums Sign in | Join | Help
in Search

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.
Page 1 of 2 (62 items) 1 2 Next >
Sort Posts: Previous Next
  • 02-13-2013 3:48 AM

    If this is how you write your SQL, I don't want to work there

    Today I found this job offer in monster.es

    Free Image Hosting at www.ImageShack.us

    At least it's a funny way of filtering candidates

  • 02-13-2013 4:01 AM In reply to

    Re: If this is how you write your SQL, I don't want to work there

    "salary ASC" is a nice touch.


    boomzilla: I think the obvious answer is for everyone to just stop programming.

    Filed under: , , ,
  • 02-13-2013 4:21 AM In reply to

    • phynol
    • Not Ranked
    • Joined on 02-13-2013
    • Posts 1

    Re: If this is how you write your SQL, I don't want to work there

    TTD? Must be a new fad.
  • 02-13-2013 4:31 AM In reply to

    • dkf
    • Top 500 Contributor
    • 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.
  • 02-13-2013 4:49 AM In reply to

    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.
  • 02-13-2013 4:56 AM In reply to

    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.
  • 02-13-2013 5:52 AM In reply to

    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.
  • 02-13-2013 6:20 AM In reply to

    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?

  • 02-13-2013 6:58 AM In reply to

    • Zecc
    • Top 25 Contributor
    • 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
  • 02-13-2013 8:03 AM In reply to

    • TGV
    • Top 75 Contributor
    • 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

  • 02-13-2013 8:51 AM In reply to

    • TGV
    • Top 75 Contributor
    • 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...

  • 02-13-2013 9:07 AM In reply to

    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.

  • 02-13-2013 9:09 AM In reply to

    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.

  • 02-13-2013 9:12 AM In reply to

    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.
  • 02-13-2013 9:18 AM In reply to

    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.

  • 02-13-2013 9:39 AM In reply to

    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.
  • 02-13-2013 9:50 AM In reply to

    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.

    Filed under: , , ,
  • 02-13-2013 9:57 AM In reply to

    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?
  • 02-13-2013 10:09 AM In reply to

    • balazs
    • Not Ranked
    • 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.
  • 02-13-2013 10:09 AM In reply to

    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

  • 02-13-2013 10:17 AM In reply to

    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.
  • 02-13-2013 10:25 AM In reply to

    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.
    Filed under:
  • 02-13-2013 10:32 AM In reply to

    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.
  • 02-13-2013 10:35 AM In reply to

    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

    Filed under:
  • 02-13-2013 10:48 AM In reply to

    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.

  • 02-13-2013 10:58 AM In reply to

    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

  • 02-13-2013 11:03 AM In reply to

    Re: If this is how you write your SQL, I don't want to work there

     We could argue and argue but in the end we end up with how stupid that SQL recruitment ad is, so let's just go make a sandwich.


    boomzilla: I think the obvious answer is for everyone to just stop programming.

    Filed under: , , ,
  • 02-13-2013 11:05 AM In reply to

    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"

  • 02-13-2013 11:08 AM In reply to

    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.
  • 02-13-2013 11:57 AM In reply to

    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.

  • 02-13-2013 12:29 PM In reply to

    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!" />
  • 02-13-2013 1:03 PM In reply to

    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
  • 02-13-2013 2:27 PM In reply to

    • DCRoss
    • Top 500 Contributor
    • 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.

     

     

  • 02-13-2013 3:07 PM In reply to

    • mihi
    • Top 500 Contributor
    • 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
  • 02-13-2013 3:09 PM In reply to

    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.]

    Filed under:
  • 02-13-2013 3:13 PM In reply to

    • Nagesh
    • Top 50 Contributor
    • 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.

     

    Filed under:
  • 02-13-2013 8:11 PM In reply to

    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:
  • 02-13-2013 10:24 PM In reply to

    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

  • 02-13-2013 11:04 PM In reply to

    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]
  • 02-14-2013 3:47 AM In reply to

    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.

  • 02-14-2013 3:57 AM In reply to

    • boh
    • Not Ranked
    • 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.
  • 02-14-2013 4:04 AM In reply to

    • balazs
    • Not Ranked
    • 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.
  • 02-14-2013 4:15 AM In reply to

    • dkf
    • Top 500 Contributor
    • 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>)
  • 02-14-2013 5:05 AM In reply to

    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.
  • 02-14-2013 6:15 AM In reply to

    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.

  • 02-14-2013 7:58 AM In reply to

    Re: If this is how you write your SQL, I don't want to work there

    Lorne Kates:

    Mine is "probiotic"

     '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?

     

  • 02-14-2013 8:09 AM In reply to

    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.

  • 02-14-2013 8:16 AM In reply to

    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.]

  • 02-14-2013 9:50 AM In reply to

    • DCRoss
    • Top 500 Contributor
    • 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.

  • 02-14-2013 10:14 AM In reply to

    • dkf
    • Top 500 Contributor
    • 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.
    Filed under:
Page 1 of 2 (62 items) 1 2 Next >
Powered by Community Server (Non-Commercial Edition), by Telligent Systems