Representative Table

  • Steven 2012-05-23 09:03
    Duh. Everybody knows OCTOBER and NOVEMBER should be capitalized...
    (zeroth?)
  • blip 2012-05-23 09:03
    <bill> Would you mind telling me in which month you were born?
    <al> NO
    <bill> We don't appear to have that value in our database - I'll add it.

  • tjb 2012-05-23 09:03
    select * from month where month = 'frist'
  • potNPan 2012-05-23 09:05
    +-------------+
    | month |
    +-------------+
    | NULL |
    | FRIST? |
    | SCEOND |
    | 4 |
    | T |
    | C |
    | A |
    | 8 |
    | 15 |
    | L |
    | 16 |
    | P |
    | D |
    | S |
    | 23 |
    | 42 |
    | YES |
    | |
    | 0 |
    +-------------+
  • TGV 2012-05-23 09:06
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.
  • No Name 2012-05-23 09:10
    Sure, "DELETE FROM month" should fix the problem
  • bob 2012-05-23 09:11
    holy hell
  • RuBen 2012-05-23 09:12
    Well i can finally say I'm born T-32-198L
  • chooks 2012-05-23 09:14
    It's missing FILE_NOT_FOUND.
  • David 2012-05-23 09:14
    Data validation, DO YOU SPEAK IT?!
  • Peyote `Simon` Joints 2012-05-23 09:15
    Actually, I was born on the 11st of NULL, 2147483647 BC. This table looks fine.
  • Giq 2012-05-23 09:15
    "File Not found" is well known, valid month name, but is missing there.
  • ¯\(°_o)/¯ I DUNNO LOL 2012-05-23 09:24
    Not only is it missing FILE_NOT_FOUND, as previously mentioned, it is also missing the months of true, false, True, False, TRUE, and FALSE.

    And also FAIL FAIL, FAIL FAIL, FAIL FAIL.
  • XXXXX 2012-05-23 09:24
    Peyote `Simon` Joints:
    Actually, I was born on the 11st of NULL, 2147483647 BC. This table looks fine.

    It's just this kind of carelessness that shows why we should have a table of milliseconds->readable date strings.
    -------------------------------------------------------------
    00000000000000000000000000000000 | 1970-JAN-01 00:00:00.00000
    00000000000000000000000000000001 | 1970-JAN-01 00:00:00.00001
    00000000000000000000000000000002 | 1970-JAN-01 00:00:00.00002
    etc.
    etc.
    etc.
    ------------------------------------------------------------
  • North Bus 2012-05-23 09:24
    RuBen:
    Well i can finally say I'm born T-32-198L
    My goodness, what a coincidence. I just tried using a T-32-198L in a project, last week. It exploded, however.
  • Zemm 2012-05-23 09:25
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.
  • GWO 2012-05-23 09:29
    The real WTF is saying "none are", and not "none is". None takes singular verb forms.

    Captcha: luptatum - The greatest werewolf jazz pianist of all time.
  • Nagesh 2012-05-23 09:33
    Probably is ain't being worse then meking code for luner calendar. When Pakistani entering burth month, often time is using Rahab or Shaban rather then May or June. Intarnationalization ain't being something to forgot.
  • dark Yuris 2012-05-23 09:34
    if month is purely informational and business logic does not depend on it - this is acceptable
  • renewest 2012-05-23 09:37
    GWO:
    The real WTF is saying "none are", and not "none is". None takes singular verb forms.

    Captcha: luptatum - The greatest werewolf jazz pianist of all time.


    According to this source it's a little more complicated than that.

    Summary: None can be singular or plural, unless it quantifies a singular or mass noun. Don’t believe anyone who says none has to be singular because it’s a contraction of not one. Both none of the meals is and none of the meals are are okay, and both none is and none are are okay. *None of the stuff are is ungrammatical, though.
  • TroelsL 2012-05-23 09:40
    Why on Earth would you even have a MONTH table anyway? In case "they" decide to change them?
  • ZPedro 2012-05-23 09:45
    Oh my God, it's full of WTFs…

    It's "only" "missing": brillant, FILE_NOT_FOUND, septembruary, kajillion, and NOTIONAL_MONTH_AFTER_DECEMBER_FOR_INVENTORY_RECONCILIATION.
  • justsomedudette 2012-05-23 09:48
    dark Yuris:
    if month is purely informational and business logic does not depend on it - this is acceptable
    To whom? Just because it doesn't break something doesn't make it right.
  • Kolja 2012-05-23 09:52
    maybe the inventor of this table even came from the future and saw that they already invented the months NULL, T, C and so on and it was decided to write NOVEMBER always entirely uppercase, then the software is just future save.
  • Gyxi 2012-05-23 09:56
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
  • Fishcake 2012-05-23 09:57
    So.....is TRWTF that it took 0.04 sec to run the query?
  • Silent D 2012-05-23 10:02
    It's also missing rows for YES and YESVEMBER.
  • anon 2012-05-23 10:04
    Fishcake:
    So.....is TRWTF that it took 0.04 sec to run the query?


    Well, to be fair, someone else was running "select * from YEAR" at the same time. You really don't want to know what that table looks like, but suffice to say it slows the DB down just a little bit.
  • random generic guy 2012-05-23 10:04
    You forgot Smarch

    captcha: tego
    I'm thirsty, shall we to tego?
  • Dragnslcr 2012-05-23 10:04
    It's also missing Smarch.

    Edit: Damn, beat me by under a minute.
  • kbiel 2012-05-23 10:05
    TRWTF is that even with an extra 16 months, they probably still missed most production deadlines.
  • Jan Doggen 2012-05-23 10:07
    Let me guess:
    - The backdoor password is 3TCA12L4PDS7
    - The answer to the secret question is NO
  • Mcoder 2012-05-23 10:10
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Is it NULL or is it the string 'NULL'?

    Also, is that the empty string or are there some blank spaces for padding?
  • An Old Hacker 2012-05-23 10:13
    Zemm:
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.


    Win.
  • ufmace 2012-05-23 10:14
    NULL has always been my favorite month of the year! The NULL rising over the horizon early in the morning, the scent of the NULL in the air, why it just can't be beat!
  • An Old Hacker 2012-05-23 10:15
    anon:
    Fishcake:
    So.....is TRWTF that it took 0.04 sec to run the query?


    Well, to be fair, someone else was running "select * from YEAR" at the same time. You really don't want to know what that table looks like, but suffice to say it slows the DB down just a little bit.


    And... the runner-up.
  • techpaul 2012-05-23 10:17
    Sorry missing Floopuary...

    See Dilbert for January 8th 2003 !!!

    This has been a known month for so long you think they would have remembered that one
  • RichP 2012-05-23 10:28
    Fishcake:
    So.....is TRWTF that it took 0.04 sec to run the query?


    The table was not cached in memory, so it took 0.01 sec to execute.

    MySQL then took 0.03 seconds to try to determine WTF happened to corrupt the month table so horribly.
  • Brian 2012-05-23 10:34
    Feature Request 985823: Please add month: Febtobuary
  • iwoas 2012-05-23 10:38
    It may be a batch file called select.bat preceded by prompt mysql$g.
  • SB 2012-05-23 10:48
    Having a look up table for commonly used data is a good idea, but yeah there is some legacy data in there that needs a cleanse.

    You could export this to xml and then load it in the cache of the application.
  • Toolbag 2012-05-23 10:54
    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 :)

  • Coyne 2012-05-23 10:59
    XXXXX:
    Peyote `Simon` Joints:
    Actually, I was born on the 11st of NULL, 2147483647 BC. This table looks fine.

    It's just this kind of carelessness that shows why we should have a table of milliseconds->readable date strings.
    -------------------------------------------------------------
    00000000000000000000000000000000 | 1970-JAN-01 00:00:00.00000
    00000000000000000000000000000001 | 1970-JAN-01 00:00:00.00001
    00000000000000000000000000000002 | 1970-JAN-01 00:00:00.00002
    etc.
    etc.
    etc.
    ------------------------------------------------------------


    Not fine grained enough...it needs to be nanoseconds, these days. Be sure to provide for expansion to picoseconds (at least).
  • Matteo 2012-05-23 11:00
    TRWTF is that it's missing OCTEMBER clearly.

    Captcha: luptatum: latin derivation of wolf. maybe.
  • Beorn 2012-05-23 11:01
    It misses Apples.
  • Jeremy 2012-05-23 11:04
    XXXXX:
    Peyote `Simon` Joints:
    Actually, I was born on the 11st of NULL, 2147483647 BC. This table looks fine.

    It's just this kind of carelessness that shows why we should have a table of milliseconds->readable date strings.
    -------------------------------------------------------------
    00000000000000000000000000000000 | 1970-JAN-01 00:00:00.00000
    00000000000000000000000000000001 | 1970-JAN-01 00:00:00.00001
    00000000000000000000000000000002 | 1970-JAN-01 00:00:00.00002
    etc.
    etc.
    etc.
    ------------------------------------------------------------
    Not a good idea. For one thing, who is going to pay people to type in all that data? For another thing, any project that large is bound to have some errors. I suggest whittling this down to just whole seconds, which would reduce the effort considerably. If you really need milliseconds somewhere, you can always interpolate.

    And, while I haven't bothered to write the code, my highly experienced programmer instincts suggest there might be an opportunity for recursion in there somewhere.
  • Coyne 2012-05-23 11:07
    Up with anarchy! Define your own month! I happen to like month "Puce", personally.

  • iToad 2012-05-23 11:08
    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.
  • Vortico 2012-05-23 11:10
    They would have been better off using RegEx.
  • Weps 2012-05-23 11:11
    28 rows in set (0.04 sec)

    wow....
  • C-Octothorpe 2012-05-23 11:13
    iwoas:
    It may be a batch file called select.bat preceded by prompt mysql$g.
    Right, and when the police question me, I'll tell them you "tripped" in front of the bus. It's possible, right?
  • Dave 2012-05-23 11:28
    Steven:
    Duh. Everybody knows OCTOBER and NOVEMBER should be capitalized...
    (zeroth?)


    Thirty days hath Octember
    April, June, and no wonder...
  • Sociopath 2012-05-23 11:29
    David:
    Data validation, DO YOU SPEAK IT?!


    Do you read the SQL standard?

    There's this passage ... Ezekiel 25:17 ...

    The path of the righteous DBA is beset on all sides by the iniquities of the selfish and the tyranny of evil programmers.

    Blessed is he who, in the name of security and best practices, shepherds the weak through the valley of darkness, for he is truly his data's keeper and the finder of lost queries.

    And I will strike down upon thee with great vengeance and furious anger those who would attempt to exploit and destroy my data!

    And you will know my name is the DBA when I lay my vengeance upon thee!
  • wonk 2012-05-23 11:32
    They must have a customer in Turkmenistan:

    http://en.wikipedia.org/wiki/Renaming_of_Turkmen_months_and_days_of_week,_2002
  • Silfax 2012-05-23 11:50
    Zemm:
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.


    I thought that mysql was Oracle these days.

    Either way the table is missing Octobuary.
  • D-Coder 2012-05-23 12:07
    Somehow they spelled "February" correctly. +1!

    So their score is now -283.
  • cellocgw 2012-05-23 12:10
    XXXXX:
    Peyote `Simon` Joints:
    Actually, I was born on the 11st of NULL, 2147483647 BC. This table looks fine.

    It's just this kind of carelessness that shows why we should have a table of milliseconds->readable date strings.
    -------------------------------------------------------------
    00000000000000000000000000000000 | 1970-JAN-01 00:00:00.00000
    00000000000000000000000000000001 | 1970-JAN-01 00:00:00.00001
    00000000000000000000000000000002 | 1970-JAN-01 00:00:00.00002
    etc.
    etc.
    etc.
    ------------------------------------------------------------

    Hey, I use the 1904 date system, you insensitive clod!
  • Nagesh 2012-05-23 12:17
    Silfax:
    Zemm:
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.


    I thought that mysql was Oracle these days.

    Either way the table is missing Octobuary.

    COrect: Java & MySQL are being owned by Oracle. I ain't think it's a good idea of DB company to be ownership of temporary free DB.
  • Luc M 2012-05-23 12:18
    Movember is missing too.
  • Christoph 2012-05-23 12:24
    Floopuary is missing too!

    http://dilbert.com/strips/comic/2003-01-08/
  • myName 2012-05-23 12:35
    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"?
  • Tasty 2012-05-23 12:50
    GWO:
    The real WTF is saying "none are", and not "none is". None takes singular verb forms.

    Captcha: luptatum - The greatest werewolf jazz pianist of all time.


    I say "none are", since none literally means not one. Also, I think "none is" sounds too much like "one is". I guess this is the same reason "an apple" exists to break up the phonemes.
  • danielpauldavis 2012-05-23 12:50
    GWO:
    The real WTF is saying "none are", and not "none is". None takes singular verb forms.

    Captcha: luptatum - The greatest werewolf jazz pianist of all time.


    Except the greatest jazz pianist of all time was Keith Jarrett, and he was born in Null (or was that NO?)
  • more please 2012-05-23 13:05
    Can we see some more from this project ?
  • dogmatic 2012-05-23 13:08
    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"?


    I too would love to get more context, but just for additional laughs. There's no way in hell that this is not a huge wtf. And why would you let users enter just anything for a month field? Are you holding a contest?
  • Ken B. 2012-05-23 13:11
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
  • Codd 2012-05-23 13:13
    Ken B.:
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
    There is no need to store a redundant number. The numbering is implied by the sequence of the entries as stored in the table.
  • Reminds me of... 2012-05-23 13:18
    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....
  • Ken B. 2012-05-23 13:19
    Codd:
    Ken B.:
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
    There is no need to store a redundant number. The numbering is implied by the sequence of the entries as stored in the table.
    Unfortunately, when the next French revolution comes along, and you need to delete the now-banned month "L", your numbering scheme goes out the window. Though, I suppose, you could keep the row, and change it to "MONTH_NOT_FOUND".
  • dogmatic 2012-05-23 13:31
    Codd:
    Ken B.:
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
    There is no need to store a redundant number. The numbering is implied by the sequence of the entries as stored in the table.


    Errr no thanks. I'll stick to having my 'redundant' id column thank you very much.
  • Matt Westwood 2012-05-23 13:43
    You got OCTOBER and December, we need Hexuary and BINGUST as well to cater for a few other number types.
  • Jay 2012-05-23 13:54
    I see the problem. it's missing Intercalaris. http://www.ortelius.de/kalender/rom_en.php

    I hate Akismet.
  • Nagesh 2012-05-23 14:24
    Monsoon month is missing for Indian compatibility
  • David 2012-05-23 14:28
    Zemm:
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.


    you do know that MySQL is a 100% Oracle subsidiary?
  • bad_management 2012-05-23 14:46
    David:
    Data validation, DO YOU SPEAK IT?!


    Data validation ain't no country I ever heard of.
  • AN AMAZING CODER 2012-05-23 14:48
    Codd:
    Ken B.:
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
    There is no need to store a redundant number. The numbering is implied by the sequence of the entries as stored in the table.


    I know you're just trolling, but you can't guarantee the ordering of results without an ORDER BY.
  • Gunslinger 2012-05-23 14:50
    North Bus:
    RuBen:
    Well i can finally say I'm born T-32-198L
    My goodness, what a coincidence. I just tried using a T-32-198L in a project, last week. It exploded, however.


    I'm glad to hear of your success. Keep it up.
  • Gunslinger 2012-05-23 14:51
    dark Yuris:
    if month is purely informational and business logic does not depend on it - this is acceptable


    WTF!?!?
  • Jack 2012-05-23 14:54
    dogmatic:
    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"?


    I too would love to get more context, but just for additional laughs. There's no way in hell that this is not a huge wtf. And why would you let users enter just anything for a month field? Are you holding a contest?

    I don't know what the difference is between a "good problem" and a "bad problem", but this is most certainly not a good solution to any real (non-contrived) problem.
  • Nagesh 2012-05-23 15:06
    Nagesh (fake):
    Monsoon month is missing for Indian compatibility


    Monsoon is season only. Not Month, madarchod.
  • Nagesh 2012-05-23 15:06
    Today I was reading this interested blog.

    https://msmvps.com/blogs/jon_skeet/archive/2009/11/02/omg-ponies-aka-humanity-epic-fail.aspx

  • Nagesh 2012-05-23 15:19
    Nagesh (haker schoolboy):
    Nagesh (fake):
    Monsoon month is missing for Indian compatibility


    Monsoon is season only. Not Month, madarchod.

    Your ain't karma to be using that word for anyone anytime. Did ur mother ain't love you?
  • Codd 2012-05-23 15:26
    AN AMAZING CODER:
    Codd:
    Ken B.:
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
    There is no need to store a redundant number. The numbering is implied by the sequence of the entries as stored in the table.
    I know you're just trolling, but you can't guarantee the ordering of results without an ORDER BY.
    Oh dear, I can see you weren't paying attention. ORDER BY affects how the data is displayed. 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.
  • Nagesh 2012-05-23 15:26
    Nagesh(fake):
    Nagesh:
    Nagesh (fake):
    Monsoon month is missing for Indian compatibility


    Monsoon is season only. Not Month, madarchod.

    Your ain't karma to be using that word for anyone anytime. Did ur mother ain't love you?


    Stop copy using words in message you not know meaning of, madarchod!
  • MadtM 2012-05-23 15:47
    GWO:
    Captcha: luptatum - The greatest werewolf jazz pianist of all time.


    Made me howl for Art.
  • AGray 2012-05-23 15:52
    At least it's not a set of key/value pairs...

    CAPTCHA: minim - a palindrome describing what the noted table both is and isn't.
  • OccupyWallStreet 2012-05-23 16:01
    Nagesh:
    Silfax:
    Zemm:
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.


    I thought that mysql was Oracle these days.

    Either way the table is missing Octobuary.

    COrect: Java & MySQL are being owned by Oracle. I ain't think it's a good idea of DB company to be ownership of temporary free DB.


    There are other free DBs that are better (postgres) than mysql. If you're absolutely in love though, just use the GPL version.
  • Nagesh 2012-05-23 16:03
    Nagesh (giant idiot):
    Nagesh:
    Nagesh (giant idiot):
    Nagesh:
    Monsoon month is missing for Indian compatibility


    Monsoon is season only. Not Month, madarchod.

    Your ain't karma to be using that word for anyone anytime. Did ur mother ain't love you?


    Stop copy using words in message I not know meaning of, madarchod!

    FTFY.
  • mfah 2012-05-23 16:39
    This is obviously all wrong. Hard-coding magic strings in a database table like this is something that should never be done. It should contain the path of an XML file instead, which can then be opened and read from to get the correct month name.
  • TroelsL 2012-05-23 17:10
    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.

    ;)
  • Miguel 2012-05-23 18:16
    Jan Doggen:
    Let me guess:
    - The backdoor password is 3TCA12L4PDS7
    - The answer to the secret question is NO
    Uh Oh
  • Dr. Frewimple 2012-05-23 18:18
    GWO:
    The real WTF is saying "none are", and not "none is". None takes singular verb forms.
    More than one of them could be the case, and "none" can take plural verb forms.
    When none is a subject, the agreement is often plural (are, for instance). None of us are perfect, says the Reverend Dr. Chasuble in Oscar Wilde's The Importance of Being Earnest. Wilde was not intending to portray Dr. Chasuble as incapable of speaking correct English. The myth that none takes only singular agreement on the verb lives on despite many refutations. Serious handbooks of grammar and style don't represent it as ungrammatical. (Of course, the idiots Strunk and White do in their clueless book The Elements of Style; but they get almost everything wrong.)
    (source: Geoff Pullum at languagelog. Pullum is a renowned linguist, co-author of the Cambride Grammar of the English Language.)
  • Hugh 2012-05-23 18:21
    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)
  • Geiger Good DBA 2012-05-23 18:34
    AN AMAZING CODER:
    Codd:
    Ken B.:
    Gyxi:
    That could make sense in some cases I guess if you want to use it for joining and do not want a 'magic number' in your database. Is Month=1 January or February. A 'Month'-table could tell you.
    Not when the table consists of a single column.
    There is no need to store a redundant number. The numbering is implied by the sequence of the entries as stored in the table.


    I know you're just trolling, but you can't guarantee the ordering of results without an ORDER BY.


    Easy ORDER BY TABLE ORDER (they all come up blue when I save them in notepad++ so that must be valid)
  • Defiler 2012-05-23 19:00
    The real WTF is why wasn't this table base-64 encoded for security reasons.

    -The 'Why can't I pass a pointer through a socket?' Bloviator
  • Mike 2012-05-23 19:02
    An Old Hacker:
    Zemm:
    TGV:
    Judging by the fact that both NULL and the empty string occur, I infer it's not Oracle. At least something is sane.


    Judging by the mysql> prompt I'd say it's not Oracle also.


    Win.


    Errr, and who owns MySQL ? Right...
  • Jim 2012-05-23 19:18
    And so by the same logic MySQL is the same thing as Java?
  • BruceT 2012-05-23 21:00
    One of the first Daily WTF that actually made me laugh out loud as soon as I saw it, without even reading the accompanying "story" ... thanks for brightening up my day! :)
  • lolwtf 2012-05-23 21:14
    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 script actually ignores its parameters and just does this hardcoded query. Or maybe it doesn't even do a query and just prints this hardcoded table.
  • geenius 2012-05-23 21:20
    Steven:
    Duh. Everybody knows OCTOBER and NOVEMBER should be capitalized...
    (zeroth?)

    So set the collation to case-insensitive and there'll never be a problem. Duh.:-)
  • Coyne 2012-05-23 21:27
    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?
  • nomdeplume 2012-05-24 03:08
    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 2012-05-24 04:20
    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.

  • toshir0 2012-05-24 05:33
    This a... just... fucking insane.

    I can't say if my eyes are bleeding... I don't feel no more.
  • Jesper 2012-05-24 05:52
    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 2012-05-24 06:46
    Needs a 'FileNotFound'
  • token_woman 2012-05-24 09:13
    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 2012-05-24 09:34
    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 2012-05-24 10:48
    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.
  • callcopse 2012-05-24 11:25
    Chaos
    Discord
    Confusion
    Bureaucracy
    The Aftermath

    ...are all missing
  • Nagesh 2012-05-24 11:56
    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 2012-05-24 12:14
    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 2012-05-24 13:30
    TRWTF is using
    select * from
  • Scrummy 2012-05-24 16:17
    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 2012-05-24 16:37
    You know it's sad when those fucking values actually have a purpose and deleting them would fuck up something else.
  • big picture thinker 2012-05-24 17:23
    Why would they allow users to submit any information that would affect column names??

    And they forgot Wyoming...
  • Evan 2012-05-24 18:12
    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.
  • Nagesh 2012-05-25 07:01
    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.
  • tirerim 2012-05-25 12:11
    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.
  • redundantman 2012-05-25 12:44
    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 2012-05-27 09:26
    [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 2012-05-28 02:14
    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 2012-05-28 11:18
    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 2012-05-29 04:20
    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 2012-05-30 16:48
    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 2012-05-31 04:43
    What?
    Where's the "File Not Found" entry?!?
  • notme 2012-05-31 09:19
    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 2012-06-01 06:09
    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)