- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
That's what makes it so brilliant! If you discover a major design flaw, instead of fixing it, just document it.
Remember, once it's documented, it's no longer a bug, it's now a feature.
Admin
"That table doubles as orders, employee info, and scratch space. All of the IDs between 1 and 199 are reserved for employees, 200-499 for product codes, and then everything up to 30000 for customer orders."
So what's the problem? Who could possibly imagine a company with over 199 employees or that sells more than 300 products? Those are clearly such absurdly large numbers that they may as well be infinity.
(Note: Not a troll, just sarcasm.)
Admin
My day at work today has involved tracking down problems relating to an overflow in a VB6 integer. A decade ago, someone said, "How could they possibly ever exceed 32,768 contract revisions?" if they even thought about it at all. We exceeded it on Tuesday.
Admin
Yeah, this is a real WTF.
And likewise... WHY the FUCK people code things like that? It's made to blow up sooner or later, with major rework, lots of frustration and endless hate.
Everytime I see aberrations like this I think of 'Hostel' movie, Chinese torture techniques... that sort of pleasant thing.
Captcha: praesent... a greek one, it is!
Admin
That's easy to do in VB6 without realizing it, since just plain "integer" is 16-bit signed.
Admin
Admin
Mebbe the original programmer threw it together for a specific project set to run for a limited period of time. Then a bunch of pointy-haired middle-management types saw it, & said, "Hey cool! I wanna use it for my projects, too! It's all set up & ready to go, & I don't need to spend my budget money to create something like it!" And despite repeated requests & providing detailed justifications, the original programmer was never given the time or resources to make it work properly.
Not that something like that hasn't happened in the real world. Nope, things like that never happen.
Admin
And, I didn't claim to be. BTW, judging by the name you used, you're belong to the same bucket as the other two.
Admin
Sorry, I'm not following: did I say that, in given siguation, I was an "einstein" or "einsteins"? I don't think your analogy is in place.
Admin
Google Orkut? I thought Google's programmers were geniuses. I guess they're human. So, I could probably replace almost any one of you.
Admin
I think that basically means people who think the same as everyone else think shit
Admin
Admin
Admin
Admin
Admin
It appears that Mahognay wants to mate with you.
Admin
BTW- Insulting my intelligence doesn't bother me. I know what really dumb motherfuckers look like, and I don't see any around here.
Admin
Admin
Admin
Copy table to ordersYYYYMMDD, empty orders, start over. Repeat every 30,000 sales.
They should totally hire me! Don't ask me what to do on 12012, we'll all be flying around in spaceships by then, dude. We'll fix that problem when we need stardates!
Captcha: modo
This is a do branch that works on a monthly basis. Perfect! Now I can make my doomsday clocks even more obscure!
Admin
Me too!
Admin
They could do like the last place I worked and just start re-using order numbers when they got too long for Sales to memorize. By the time I left, they were cycling through order numbers every 6 months. It made it difficult to interface with the shipping system that expected to uniquely identify orders by order number (gasp!).
Admin
Oh fuck off, course it's fucking well not! (blows kisses)
Admin
Admin
You can't know what kind of constraints the programmer has, so it is unfair to judge. Who knows, it could have been a requirement defined by his manager. I know I have put similar constraints on my team before, for no other reason than to see how creative they can be in solving a problem.
Admin
i was going to, but i remembered before starting the spree that i have to finally go to bed. added the video to favorites and postponed the spree until tomorrow procrastrination time
Admin
Admin
It's a simple upgrade to VB 2010 where it magically turns into a 32-bit signed. Recompile and you're done.
Admin
I feel sorry for you. Everyone knows that struggle begets creativity. You must not be in a work environment that is very conducive to problem solving.
I place obstacles in front of my team so they are inspired to greatness. And by all accounts, they are very appreciative of my efforts.
Admin
From the tale, the programmer was an old-timer. That means he grew up in a time where computer memory was so limited that anything creative you could to do to save space was a Good Thing. The poor old fucker was obviously complete shit at learning new stuff and should have been shuffled off into janitorial and/or doorman duties many ages before.
Admin
Okay, please explain a newbie why the hell couldn't he just change the sql to: DELETE FROM tbl14a_fx004B WHERE id >= 50000
You know, untill they fix the application (Yeah, right)
Admin
What a moron! You Sir, are TRWTF!
Admin
trwtf: not opening external links in new tab.
Admin
Admin
The table was called "tbl" in the first prototype build. Then tbl1, tbl2, 1bl3 ... tbl14.
At that point management introduced changes out of the requirements specification . So for the new requirements then made tbl14a and tbl14b for the old ones.
They developed both in parallel waiting for management to made up their mind but they found the new requirements broke the former specification and they had to fix it ... hence bl14a_fx.
They finally decided to go ahead and made some more iterations producing tbl14a_fx001, tbl14a_fx002, tbl14a_fx003 and tbl14a_fx004. The desesperation showed up in the development team started to show up as you can see in the expected hundrends range numbering for new versions.
But management introduced again changes out of the requirements specification producing bl14a_fx004A and bl14a_fx004B ...
In fact the table name is a combination of the developers' computing diogenes sindrome and varios unplaned management changes.
If development had not stalled most likely the name woudl be now: bl14a_fx004B_002v1_4_5_22A2_prod.
Admin
Admin
And you are an overpaid whiner. The truly passionate in our business take such challenges with aplomb.
Admin
pfff why didn't he just increase the column size to 10 digits what a time waster
Admin
another geoffrey huh? i guess I will have to use my full name
Admin
You are undoubtedly wrong. Such table names are designed to be machine readable rather than human readable. This style of doing things harks back to the day when programmers had to memorize actual manuals rather than modern "programming" that consists of just searching on google and using fancy IDEs.
Part of the table name might even have meaning to the application, eg perhaps in the case of tbl14a_fx002, 0xf0214a might be an address offset into an array in the application.
Admin
Admin
Opening links in a new tab, as a default behavior, is abad choice.
Every browser has a simple and easy way to force a link to open in a new tab. No browser has a simple and easy way to force a link to open in the current tab. Unless you have a compelling reason to keep both windows open at the same time (like you've just popped up a documentation page that contains information useful to someone viewing the main page), you should let all links open in the current window by default.
The user should decide if they want a link to open in a new tab or not.
Admin
And the difference is?
Admin
missed chance: the article should have been titled 'the doomsday clock'.
Admin
Admin
As a management style, no doubt yours works in the academic sphere, where the projects being generated are not being paid for by an impatient customer, and difficult problems are generated artificially as training exercises. However, in the real world of commercial realities, I'm afraid your approach may result in your business losing any competitive edge it may ever have had.
Admin
Am I seriously the ONLY person who read this who thought, "What exactly IS the 'very bottom' of a network drive?"
Admin
Seems like it's time for a FixOutOfNumersV2.sql
DELETE FROM tbl14a_fx004B WHERE id >= 40000;
Should buy him a year.
Admin
Admin
I had a 60-something coworker ask me what techno music was, so I brought in the SBmail DVDs, gathered the team in the computer lab, and we all watched in delight as I showed him the Techno SBmail - he was still quite confused, but it was entertaining :D