• A concerned party (unregistered)

    Seriously though...I just got off the phone with Jan and she hasn't gotten her check yet.

  • Joe (unregistered)

    Some 'states' tables could include Wash, D.C. and U.S. territories, for example.

  • Seriously, Leo? (unregistered) in reply to Leo

    Some people have no ability to recognize humor.

  • KB (unregistered) in reply to RHuckster

    I wouldn't be surprised if that was some backdoor timebomb feature a job-worried designer put in and then forgot to remove as he faded from the project.

  • Mike (unregistered)

    If the States table is supposed to actually store USPS two-letter postal codes--a reasonable guess--you need more rows.

    The USPS defines 59 unique two-letter codes for "states", including codes for the District of Columbia (DC) and Palau.

    They also define three codes for six military "states". The postal code "AE" maps to four different military "states": Armed Forces Africa, Armed Forces Canada, Armed Forces Europe, and Armed Forces Middle East.

    So, if you're modeling real-world data, US postal codes aren't unique unless you can guarantee you'll never use a military address.

  • ClaudeSuck.de (unregistered) in reply to Zapp Brannigan
    Zapp Brannigan:
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    In the end, we all die alone.

    ... with the eyes wide open

  • Josh Ribakoff (unregistered) in reply to RHuckster

    Obama was referring to states of a country other than the United States,

    http://www.snopes.com/politics/obama/57states.asp

  • (cs) in reply to CB
    CB:
    For the first 2 screen shots, what is the program being used to view the databases?
    MS SQL server management studio for the 1st one
  • nona (unregistered)

    Perhaps Obama just included Micronesia, the Marshall Islands, Palau, Puerto Rico, Guam, Marinara and the Virgin Islands - oh wait, they can't vote. My mistake.

  • T (unregistered)

    Everyone knows that the world ends in 2012.

  • TheyAreEverywhere (unregistered) in reply to Leo

    Seriously? Even on TheDailyWTF, you 'wingers can't just let it be for a few minutes? Loser.

  • Mike (unregistered) in reply to Leo

    I came late to this party, when I stumbled on this while searching for a different database WTF. But those short names are clearly US Postal Service state codes. Any database professional in the USA should know there are 60, two-letter "state" codes, and that doesn't include the armed forces.

    https://www.usps.com/send/official-abbreviations.htm

  • Jazz (unregistered)

    Now that it's 2013, I want to know what happened to Suzy T's system...

  • 🤷 (unregistered)

    I once discovered a "Time" table in our system. It had two columns, "Hour" and "Minute", and it was populated with every hour from 0 to 23 and with every minute from 0 to 59, for each hour. It even got referenced a few times in the codebase. I tried figuring out what the hell it does, but the SQL was so mangled up I didn't want to spent too much time on it and figured it was best if I just left it alone. I still don't know what the original developer had in mind, though.

Leave a comment on “The Year Table, Row 51, and other Database Oddities”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article