Comment On Representative Table

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?

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: 

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.

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

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

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?

Needs a 'FileNotFound'

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

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.

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.

Chaos
Discord
Confusion
Bureaucracy
The Aftermath

...are all missing

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.

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.

TRWTF is using
select * from

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.

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

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

And they forgot Wyoming...

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.

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.

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.

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

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

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.

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

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

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. :)

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

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.

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)