• (cs) in reply to Reminds me of...
    Reminds me of...:
    The SQL Server database table of "States" that would have our normal 50, but had a few interesting ones like "Jamaica" and even "North Korea", but it wasn't a complete list of countries too (like 70 entries altogether)...very odd....

    Did it have Ruritania?

  • (cs) in reply to Hugh
    Hugh:
    iwoas:
    It may be a batch file called select.bat preceded by prompt mysql$g.
    Wouldn't the '*' then be interpreted as all files in the directory (you'd need to escape it to pass it as a parameter)
    The Windows command shell doesn't expand wildcards, that's left up to the program itself. There are standard API calls for processing fileglobs, which virtually every program utilises if it expects to be called with such parameters. 
    C:\Temp>type select.bat
@echo off

echo 1: %1
echo 2: %2
echo 3: %3
echo 4: %4

C:\Temp>select * from foo
1: *
2: from
3: foo
4:
  • ben (unregistered) in reply to Toolbag
    You may not remember these old times, when the French tore down monarchy and decided to stand for a "Republic" thing. Well, they also decided to change days and months for almost 14 years.

    And, even though it serves just about no purpose unless you read old Marxist literature and need to know when the 18th Brumaire of Napoleon III was, there is support for the Revolutionary Calendar in many date libraries today. Just like most computing languages allow for the fact that different jurisdictions switched to the Gregorian calendar at different times. Even creating new months is not a case for stuffing random values into a database table.

  • (cs)

    This a... just... fucking insane.

    I can't say if my eyes are bleeding... I don't feel no more.

  • Jesper (unregistered)

    The REAL WTF is that you have a table called "month"?

    Why the hell would you need a table for that? For if someone invents a new month someday, so that you can easily add it? Or for when January is going to be renamed to something else?

  • Trevor D'Arcy-Evans (unregistered)

    Needs a 'FileNotFound'

  • (cs) in reply to Trevor D'Arcy-Evans

    All these nageshes are getting tiresome. Also "ain't" is cockney (native Londoner) pronunciation, not Indian IN ANY POSSIBLE WAY. So pls just stop it

  • Geoff (unregistered) in reply to Codd

    If the table was structure in an application or something sure but this is a SQL database table. In order to imply a numeric value from the Sequence in the table you will lose the ability to join it directly. The cost of having a function/procedure/cursor called from queries to figure out that number is going to grossly exceed the cost of storing it; at least for something with a pretty finite number of values like "month" and in almost all other situations as well.

  • Nagesh (unregistered) in reply to token_woman
    token_woman:
    All these nageshes are getting tiresome. Also "ain't" is cockney (native Londoner) pronunciation, not Indian IN ANY POSSIBLE WAY. So pls just stop it

    You ain't right to be so bad about people of Hyderabad.

  • (cs) in reply to Nagesh

    Chaos Discord Confusion Bureaucracy The Aftermath

    ...are all missing

  • (cs) in reply to token_woman
    token_woman:
    All these nageshes are getting tiresome. Also "ain't" is cockney (native Londoner) pronunciation, not Indian IN ANY POSSIBLE WAY. So pls just stop it

    Alex should take one fatwa and ban all unregistered Nagesh user names. That will take teach him a lesson.

  • Paula Bean (unregistered) in reply to TroelsL
    TroelsL:
    Toolbag:
    TroelsL:
    Why on Earth would you even have a MONTH table anyway? In case "they" decide to change them?
    In fact, they can change.

    You may not remember these old times, when the French tore down monarchy and decided to stand for a "Republic" thing. Well, they also decided to change days and months for almost 14 years.

    Weeks were ten days long, months were 3 weeks long, and added 6 days to make it even with Earth rotation.

    You may check "Republican Calendar" on wikipedia and laugh about how we French are lame, I grant you this right.

    However, never assume months are granted :)

    Wow.. you just blew my mind. I will never rely on DateTime again - in case they change that, I'll have to redo all my code.

    Did you also know that 0 is relatively new invention? I better create a NUMBERS table in case they invent new ones of those as well.

    ;)

    If you really don't understand the value of a numbers table, you should probably leave the database stuff to the professionals.

  • Decius (unregistered)

    TRWTF is using select * from

  • Scrummy (unregistered)

    Had this team used Agile development, you'd never see data like this in the database. At the end of every sprint, a team goes through a retrospective. Junk records in the data table would surely be uncovered at that time.

  • Jack Foluney (unregistered)

    You know it's sad when those fucking values actually have a purpose and deleting them would fuck up something else.

  • big picture thinker (unregistered)

    Why would they allow users to submit any information that would affect column names??

    And they forgot Wyoming...

  • Evan (unregistered) in reply to TroelsL
    TroelsL:
    Did you also know that 0 is relatively new invention? I better create a NUMBERS table in case they invent new ones of those as well.

    ;)

    They have, a lot. I mean, first there was zero, then negative numbers, then fractions, then irrationals, transcendals, imaginarys and complex, surreals, hyperreals, ...

    I mean, imagine if you were writing a program that dealt with numbers back when they were coming up with imaginary numbers. (If they had computers then, I mean. Would have been way harder to develop without imaginary numbers though. (By my understanding this is actually true.)) If you planned ahead, all you'd have to do is add a bunch more rows to your NUMBERS table.

  • (cs) in reply to Scrummy
    Scrummy:
    Had this team used Agile development, you'd never see data like this in the database. At the end of every sprint, a team goes through a retrospective. Junk records in the data table would surely be uncovered at that time.

    We are all using Agile, but no project manager is able to define Agile goal.

  • (cs) in reply to iToad
    iToad:
    Is the spiffy ASCII art formatting a feature of MySQL or -God help us-, was it embeddeded within each record in the table, so it would print out like this when queried?

    Disclamer: I don't know anything about MySQL.

    It's a feature of MySQL. Only in interactive mode.

  • (cs) in reply to Dragnslcr
    Dragnslcr:
    It's also missing Smarch.

    Edit: Damn, beat me by under a minute.

    Came here for Smarch reference ... leaving satisfied.

    /Lousy weather in Smarch ...

  • Nickster (unregistered) in reply to Codd

    [quote user="Codd"][quote user="AN AMAZING CODER"][quote user="Codd"]Please note I said "The numbering is implied by the sequence of the entries as stored in the table." That isn't going to change randomly every time you do a month lookup.[/quote]

    If you're not in fact trolling, you need to revisit relational model. A table (relation) is a set of unordered tuples.

  • Dotan Cohen (unregistered) in reply to myName
    myName:
    Like so many that are presented as WTFs, there's not enough background to know whether it's a really bad solution to a good problem or a really good solution to a bad problem.

    How about if there was a table which held everything that the users had entered for "Month"?

    This is obviously not user-entered data. The string "penis" is not represented.

  • Amy (unregistered)

    OMG.. Thanks ya'll :) I just spit my coffee all over my monitor.. It needed cleaning anyway, and now it smells like coffee. :P

  • Bo the crusty old DBA (unregistered) in reply to Scrummy
    Scrummy:
    Had this team used Agile development, you'd never see data like this in the database. At the end of every sprint, a team goes through a retrospective. Junk records in the data table would surely be uncovered at that time.

    Naaahhh - had they been agile, they would have added a new month per sprint (adding more than one month would not be need to fulfill requirements for this sprint), so you would end up with:

    January February March ... December Next January Next February .. Next again January

    etc, until they ran out of product backlog, or their customer got fed up

  • NotACoder (unregistered)

    Data rot.

    Looking forward to the days when this becomes so prevalent, that when data rot, or "PLAQUE" as it shall be known as, is such a serious problem that we instantly excise any table, host, network, or country that displays such, from the rest of the network, and then nuke it to prevent it's plaque from spreading.

    I think we need to start with the database that this table came from. :)

  • Jeff Grigg (unregistered)

    What? Where's the "File Not Found" entry?!?

  • notme (unregistered) in reply to TGV
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.

    Technically it is, since Sun Microsystems has bought MySQL AB and Oracle has subsequently bought Sun...

    What we have here is... Oracle MySQL.

  • Yann (unregistered)

    That table is auto populated from user entries in a field. Then the content of the table is used to present choices for the field in a dropdown list.

    It has been a common practice in Ms Access.

    (of course, it had been better to first populate the table with consistent values and disable the auto-update feature)

Leave a comment on “Representative Table”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article