Comment On The Mod Out System

When Gary was first hired at an aircraft component repair company, one of his first duties was to add functionality to their Oracle 11i based application that would "automatically add mods" to the system. [expand full text]
« PrevPage 1 | Page 2 | Page 3Next »

Re: The Mod Out System

2009-04-23 11:03 • by James (unregistered)
F-t,p,o,s,t

In the interests of safety

2009-04-23 11:03 • by rpjs (unregistered)
We need a full list of every single aviation company that uses Gary's company for its maintenance, so we know who not to fly with.

(except of course I'm sure all the others have similar WTFs too)

Re: In the interests of safety

2009-04-23 11:07 • by Rhywden (unregistered)
257719 in reply to 257718
I dare say that you'd have to have an IQ in the single digits to come up with such an braindead idea...

Re: The Mod Out System

2009-04-23 11:12 • by John Whittet (unregistered)
Wait, that table contains every possible permutation of mods? *facepalm*

Re: The Mod Out System

2009-04-23 11:13 • by Better order another petabyte of disk (unregistered)
ALL mods? I don't remember my combinatorics too well but isn't the number of combinations of 45 things like way up there, like 2^45? Better order some more disks.

Re: The Mod Out System

2009-04-23 11:16 • by Josh (unregistered)
Every problem can be solved with a lookup table. Or so some developers seem to think...

Re: The Mod Out System

2009-04-23 11:17 • by Kermos
W,T,F|W,T,F
W,F,T|W,T,F
T,F,W|W,T,F
T,W,F|W,T,F
F,W,T|W,T,F
F,T,W|W,T,F

No...

2009-04-23 11:20 • by way2trivial (unregistered)
257726 in reply to 257721
it contains every combination used thus far.

if someone trys to enter a combo that hasn't been used before- it gets rejected.. and then a request was made to one of 3 people to add a permutation to the list

Re: The Mod Out System

2009-04-23 11:22 • by blah (unregistered)
Hey Mark, would you mind adding a mod for the comment I'm about to write? Oh, and try not to botch the spelling.

Re: The Mod Out System

2009-04-23 11:28 • by KenK (unregistered)
This is genius. If you get paid by the hour to enter those rows you would have several decades of work ahead of you.

Re: The Mod Out System

2009-04-23 11:30 • by MM (unregistered)
'What a great first assignment!'

Famous last words

Re: The Mod Out System

2009-04-23 11:31 • by Bami (unregistered)
257775 in reply to 257722
Bob:
ALL mods? I don't remember my combinatorics too well but isn't the number of combinations of 45 things like way up there, like 2^45? Better order some more disks.
Depends if it's inclusive or not (if you can repeat the same mod twice).

If not, you'd be looking at 45!, which is somewhere along the 10^56 range (45*44*43*42 etc).

If it's inclusive, you just do 45^45, which is along the 10^74 range. Thats combinations, not even data for all those possible combinations, or combinations with less then 45 things.

Re: The Mod Out System

2009-04-23 11:40 • by ubersoldat
You know, in many articles I just try to find some excuse for a fellow developer coming with the article's WTF. But some are just inexcusable. Not many times I do whisper and facepalm at the same time, but today, right now... my goooooooogles!!! where are they?!?

Re: The Mod Out System

2009-04-23 11:43 • by Jim T (unregistered)
This is the first time I've actually said "oh my god" out loud to one of these stories.

And it was completely involuntary.

Re: The Mod Out System

2009-04-23 11:44 • by Ken B (unregistered)
257816 in reply to 257794
ubersoldat:
Not many times I do whisper and facepalm at the same time, but today, right now... my goooooooogles!!! where are they?!?
Why, over at www.goooooooogle.com, of course!

Re: The Mod Out System

2009-04-23 11:44 • by brazzy
257817 in reply to 257722
Better order another petabyte of disk:
ALL mods? I don't remember my combinatorics too well but isn't the number of combinations of 45 things like way up there, like 2^45? Better order some more disks.

Well, those "mods" describe a sequence of work steps, and the set of sequences that are technically possible is most likely a very small subset of the simple permutations of the numbers, further constrained by working rules and habits.

So in practice, it's not nearly as bad as in theory. Still, this ranks pretty high on the "how loud I actually shouted WTF" scale.

Re: The Mod Out System

2009-04-23 11:45 • by SomeCoder (unregistered)
I think you can file this one under "Should have realized"

As in, when the original developer was priming the system with a few hundred rows of mods, didn't he stop and realize "There's got to be a better way.... nah!"

*FACEPALM*

Re: The Mod Out System

2009-04-23 11:48 • by m0ffx (unregistered)
Oh. My. Mod.

Re: The Mod Out System

2009-04-23 11:49 • by galgorah
257824 in reply to 257722
2^ 45 = 35,184,372,088,832
45! = 1.1962222086548019456196316149566e+56
45 ^ 45 = 2.4806364445134114549464918239541e+74

I hope they never try and do select * from all_mods.

Re: The Mod Out System

2009-04-23 11:50 • by Jon (unregistered)
This one actually made me say "No!" out loud.

What's missing, however, is the second tard who usually comes in and thinks "I could write a spiffy little PL/SQL function that would finish out the table."

Re: The Mod Out System

2009-04-23 11:51 • by KT (unregistered)
257828 in reply to 257775
Bami:
Bob:
ALL mods? I don't remember my combinatorics too well but isn't the number of combinations of 45 things like way up there, like 2^45? Better order some more disks.
Depends if it's inclusive or not (if you can repeat the same mod twice).

If not, you'd be looking at 45!, which is somewhere along the 10^56 range (45*44*43*42 etc).

If it's inclusive, you just do 45^45, which is along the 10^74 range. Thats combinations, not even data for all those possible combinations, or combinations with less then 45 things.


Given that:

"Because the company specialized in a fairly specific type of components (multimedia), the steps to perform the work were fairly consistent"

There is probably only a small subset that are considered 'valid' sequences of steps. Exceptions would be required to be approved by someone who knows that this won't result in the fiery death of hundreds of airline travelers.

Re: The Mod Out System

2009-04-23 11:52 • by SPAM King (unregistered)
What the previous poster was trying to say, in its mechanical way, is that it is time for Alex to move to recaptcha.

Re: The Mod Out System

2009-04-23 11:55 • by monkeyPushButton (unregistered)
After the crap I've been dealing with this morning, it's nice to read something and say, "Wow, it's not that bad here."

Of course I was reading this at lunch and nearly lost my appetite.

Re: The Mod Out System

2009-04-23 11:57 • by emurphy
As we deal with mods, so we must frame those mods.

(What?)

Re: The Mod Out System

2009-04-23 11:57 • by ashmud (unregistered)
So what happens when someone tries to enter an en-dash instead of a hyphen for a range?

Re: The Mod Out System

2009-04-23 11:57 • by DLJessup (unregistered)
257849 in reply to 257775
Bob is correct, there are 2^45 possible combinations of 45 things here. If you look at the example, the steps are entered in increasing numeric order; for example, you can have 1,2 but not 2,1. Therefore, either step 1 is in the combination or it isn't, either step 2 is in the combination or it isn't, either step 3 is in the combination or it isn't, etc. Thus each possible step doubles the number of combinations, giving us 2^45 - 1 possible combinations. (The - 1 is because the combination of no steps isn't valid.)

Re: The Mod Out System

2009-04-23 11:59 • by monkeyPushButton (unregistered)
257859 in reply to 257828
KT:


There is probably only a small subset that are considered 'valid' sequences of steps. Exceptions would be required to be approved by someone who knows that this won't result in the fiery death of hundreds of airline travelers.
Either way, it's still a WTF. If only certain exceptions are valid, then asking for a way to bypass approval is WTF and if that is not the case, the original code is WTF.

Re: The Mod Out System

2009-04-23 12:10 • by Jack (unregistered)
rong1982:
搬家搬家 搬家公司在職進修 婚紗 新娘秘書 汽車旅館 彩妝造型 新娘秘書 票貼 室內設計 室內設計 外遇 抓姦 應收帳款 徵信 徵信社 外遇 徵信 徵信社 外遇 植牙 牙齒矯正 坐月子 宜蘭民宿 婚禮佈置 宜蘭民宿推薦 催眠 派報 太陽能熱水器 Shade sail nike shoes 關鍵字廣告 租屋 搬家 搬家 買房子 花蓮民宿 花蓮民宿 花店 租房子 xo醬 房屋貸款 搬家公司 減肥 減重 床墊 創業加盟 團體服 學英文 英文 補習班 勞工體檢 資源回收 生日禮物 團體服 團體制服 班服 塑膠 日立家電 飾品批發 MBA 在职研究生 在职博士 电动隔膜泵 自吸泵 化工泵 离心泵 磁力泵 螺杆泵 水泵 隔膜泵 气动隔膜泵 婚禮佈置 婚禮佈置 婚禮佈置 酒店經紀 酒店經紀 班服配件 團體服配件 團體服 班服 團體服 班服 團體


Ok...wtf is a shade sail?

Re: The Mod Out System

2009-04-23 12:11 • by Code Dependent
What we need on TDWTF is a similar method of selecting from a table of all possible comments. We could just enter a number and it would select the comment and insert it for us.

Of course, we all know what the first entry in the table would be...

Re: The Mod Out System

2009-04-23 12:11 • by snoofle
As someone who used to work with aircraft maintenance logs, I can vouch for the fact that just because some technician LOGS that he did steps 1-10 doesn't mean he didn't SKIP some of them. Sadly, a routine occurrence.

Re: The Mod Out System

2009-04-23 12:13 • by Ditto (unregistered)
257897 in reply to 257815
This is the first time I've actually said "oh my god" out loud to one of these stories.

And it was completely involuntary.


Ditto. I did the same exact thing.

This is... unbelievable.

Re: The Mod Out System

2009-04-23 12:18 • by GDarius (unregistered)
There is probably only a small subset that are considered 'valid' sequences of steps. Exceptions would be required to be approved by someone who knows that this won't result in the fiery death of hundreds of airline travelers.


It's still ridiculous to put together a 30 BILLION row* table instead of parsing input and writing a validating function to make sure that mandatory steps are always present.


*give or take a couple hundred million or so

Re: The Mod Out System

2009-04-23 12:19 • by Erzengel
My lord, I felt physically weak after seeing that. That's the most horrendous thing I've ever seen. It would take, what, 10 lines of code? Instead it's how many thousands of table entries? That's not a WTF, that's a OMG-WTF-Friendly-Fire-Cluster-Bomb. Someone needs to take away the degrees those 3 have so that they will never be able to work in the industry again.

Re: The Mod Out System

2009-04-23 12:19 • by D-Coder
OMFG.

No. No. NO. No. No!

Re: The Mod Out System

2009-04-23 12:21 • by Jess Me (unregistered)
257901 in reply to 257849
DLJessup:
Bob is correct, there are 2^45 possible combinations of 45 things here. If you look at the example, the steps are entered in increasing numeric order

So you've been able to deduce the full business requirements after viewing 17 examples? (Well 16 and a half but we won't quibble.) Without ever even talking to a single user?

Guys like you make the baby Jesus cry, and planes fall burning from the sky. (Which the baby Jesus is mysteriously unable or unwilling to prevent. Hmmm...)

Re: The Mod Out System

2009-04-23 12:25 • by Bluesman (unregistered)
257903 in reply to 257896
snoofle:
As someone who used to work with aircraft maintenance logs, I can vouch for the fact that just because some technician LOGS that he did steps 1-10 doesn't mean he didn't SKIP some of them. Sadly, a routine occurrence.



Ah, but then we can use the following, much smaller table:

- All Done
- Some Done
- None Done
- Only God Knows

Re: The Mod Out System

2009-04-23 12:31 • by JdFalcon04 (unregistered)
257907 in reply to 257849
DLJessup:
Bob is correct, there are 2^45 possible combinations of 45 things here. If you look at the example, the steps are entered in increasing numeric order; for example, you can have 1,2 but not 2,1. Therefore, either step 1 is in the combination or it isn't, either step 2 is in the combination or it isn't, either step 3 is in the combination or it isn't, etc. Thus each possible step doubles the number of combinations, giving us 2^45 - 1 possible combinations. (The - 1 is because the combination of no steps isn't valid.)


Actually, this isn't totally right. Because a user is entering this manually, you have to be able to accept input in ANY legal format. Thus: 1-4,6 = 1-3,4,6 = 1,2,3-4,6 and so on. With a proc they'd all map to 1,2,3,4,6, but with ALL_MODS you need a seperate entry for each

Re: The Mod Out System

2009-04-23 12:39 • by Code Dependent
257910 in reply to 257896
snoofle:
As someone who used to work with aircraft maintenance logs, I can vouch for the fact that just because some technician LOGS that he did steps 1-10 doesn't mean he didn't SKIP some of them. Sadly, a routine occurrence.
Aircraft maintenance log. P = "Problem"; S = "Solution"

P: Left inside main tire almost needs replacement.
S: Almost replaced left inside main tire.

P: Test flight OK, except auto-land very rough.
S: Auto-land not installed on this aircraft.

P: Something loose in cockpit.
S: Something tightened in cockpit.

P: Dead bugs on windshield.
S: Live bugs on back-order.

P: Autopilot in altitude-hold mode produces a 200 feet per minute descent.
S: Cannot reproduce problem on ground.

P: Evidence of leak on right main landing gear.
S: Evidence removed.

P: DME volume unbelievably loud.
S: DME volume set to more believable level.

P: Friction locks cause throttle levers to stick.
S: That's what they're for.

P: IFF inoperative.
S: IFF always inoperative in OFF mode.

P: Suspected crack in windshield.
S: Suspect you're right.

P: Number 3 engine missing.
S: Engine found on right wing after brief search.

P: Aircraft handles funny.
S: Aircraft warned to straighten up, fly right, and be serious.

P: Target radar hums.
S: Reprogrammed target radar with lyrics.

P: Mouse in cockpit.
S: Cat installed.

P: Noise coming from under instrument panel. Sounds like a midget pounding on something with a hammer.
S: Took hammer away from midget

Re: The Mod Out System

2009-04-23 12:53 • by Oww (unregistered)
So here I was, eating my Caesar salad, innocently reading the article until I got to the table. At the sight of which, I let out a chuckle and made a piece of crouton shoot out of my nose.

I never thought bread could be so painful.

CAPTHCA: iusto
From the immortal words:
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis ...

Re: The Mod Out System

2009-04-23 12:56 • by Zach Bora (unregistered)
257918 in reply to 257910
[quote user="Code Dependent"][quote user="snoofle"]
P: Noise coming from under instrument panel. Sounds like a midget pounding on something with a hammer.
S: Took hammer away from midget [/quote]

This last one made me LOL. I hadn't laughed like that in awhile.

Re: The Mod Out System

2009-04-23 12:58 • by Dr. Evil (unregistered)
257920 in reply to 257884
Jack:
rong1982:
搬家搬家 搬家公司在職進修 婚紗 新娘秘書 汽車旅館 彩妝造型 新娘秘書 票貼 室內設計 室內設計 外遇 抓姦 應收帳款 徵信 徵信社 外遇 徵信 徵信社 外遇 植牙 牙齒矯正 坐月子 宜蘭民宿 婚禮佈置 宜蘭民宿推薦 催眠 派報 太陽能熱水器 Shade sail nike shoes 關鍵字廣告 租屋 搬家 搬家 買房子 花蓮民宿 花蓮民宿 花店 租房子 xo醬 房屋貸款 搬家公司 減肥 減重 床墊 創業加盟 團體服 學英文 英文 補習班 勞工體檢 資源回收 生日禮物 團體服 團體制服 班服 塑膠 日立家電 飾品批發 MBA 在职研究生 在职博士 电动隔膜泵 自吸泵 化工泵 离心泵 磁力泵 螺杆泵 水泵 隔膜泵 气动隔膜泵 婚禮佈置 婚禮佈置 婚禮佈置 酒店經紀 酒店經紀 班服配件 團體服配件 團體服 班服 團體服 班服 團體


Ok...wtf is a shade sail?


So out of all that, you choose to question Shade sail? I am more curious about "Dr. diaphragm self-priming pump centrifugal chemical pumps."

Re: The Mod Out System

2009-04-23 13:05 • by Bami (unregistered)
257922 in reply to 257849
DLJessup:
Bob is correct

That's no Bob!
(I just copypasted the quote code from the BBCode thing)

Re: The Mod Out System

2009-04-23 13:17 • by hi there (unregistered)
257928 in reply to 257717
James:
F-t,p,o,s,t

FGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstpost

I see

Re: The Mod Out System

2009-04-23 13:17 • by SomeCoder (unregistered)
257929 in reply to 257910
Code Dependent:
Aircraft maintenance log. P = "Problem"; S = "Solution"

P: Left inside main tire almost needs replacement.
S: Almost replaced left inside main tire.

P: Test flight OK, except auto-land very rough.
S: Auto-land not installed on this aircraft.

P: Something loose in cockpit.
S: Something tightened in cockpit.

P: Dead bugs on windshield.
S: Live bugs on back-order.

P: Autopilot in altitude-hold mode produces a 200 feet per minute descent.
S: Cannot reproduce problem on ground.

P: Evidence of leak on right main landing gear.
S: Evidence removed.

P: DME volume unbelievably loud.
S: DME volume set to more believable level.

P: Friction locks cause throttle levers to stick.
S: That's what they're for.

P: IFF inoperative.
S: IFF always inoperative in OFF mode.

P: Suspected crack in windshield.
S: Suspect you're right.

P: Number 3 engine missing.
S: Engine found on right wing after brief search.

P: Aircraft handles funny.
S: Aircraft warned to straighten up, fly right, and be serious.

P: Target radar hums.
S: Reprogrammed target radar with lyrics.

P: Mouse in cockpit.
S: Cat installed.

P: Noise coming from under instrument panel. Sounds like a midget pounding on something with a hammer.
S: Took hammer away from midget


I've seen those before but they are always good for a laugh :)

Re: The Mod Out System

2009-04-23 13:18 • by jmroth

http://www.dailydemotivators.com/wp-content/uploads/2009/04/doublefacepalm2.jpg

Re: The Mod Out System

2009-04-23 13:19 • by jimlangrunner
257931 in reply to 257893
Code Dependent:
What we need on TDWTF is a similar method of selecting from a table of all possible comments. We could just enter a number and it would select the comment and insert it for us.

Of course, we all know what the first entry in the table would be...

What would that be? Does it have anything to do with Irish Girl?

Re: The Mod Out System

2009-04-23 13:42 • by ideot - that's me (unregistered)
257936 in reply to 257931
jimlangrunner:
Code Dependent:
What we need on TDWTF is a similar method of selecting from a table of all possible comments. We could just enter a number and it would select the comment and insert it for us.

Of course, we all know what the first entry in the table would be...

What would that be? Does it have anything to do with Irish Girl?

And a wooden table?

Re: The Mod Out System

2009-04-23 13:44 • by amischiefr
257937 in reply to 257721
John Whittet:
Wait, that table contains every possible permutation of mods? *facepalm*

Hopefully this is because when it was first developed there were strict guidelines on what series of mods were available so as to restrict certain combinations. Hopefully...

Re: The Mod Out System

2009-04-23 13:56 • by Charles400
OH MY GOD!

Back in my younger programmer days, I wrote exactly this (WTF) type of function, but for golf clubs!

3-9 (a set of 3,4,5,6,7,8,9 Irons)
3-9P (set of 3,4,5,6,7,8,9,Pitching wedge)
3-9PS (set of 3,4,5,6,7,8,9,Pitching wedge, Sand wedge)
:
etc.

These table entries were like a low-level design for a bill of materials.

Re: The Mod Out System

2009-04-23 14:38 • by Missed it by that much (unregistered)
257943 in reply to 257898
That would be closer to a (potentially) 35+ TRILLION row* table.

*give or take a couple hundred BILLION or so
« PrevPage 1 | Page 2 | Page 3Next »

Add Comment