Re:If you move your mouse continually the query may not fail...
by kyberias on Saturday January 04, 2014 @11:50AM
(#7011689)
This is a 11 year old knowledge base article for a bug in a product (Excel 97) that saw the light in 1997, that is 17 years ago. Yes, the second workaround is kind of hilarious, but let's not draw too many far-fetching conclusions from it. I believe many of us have seen crazier bugs.
[ Parent
| on HN ]
Re:If you move your mouse continually the query may not fail...
by drunkenfly on Saturday January 04, 2014 @12:24PM
(#7011859)
This is by far craziest I've seen: "Error Message: Your Password Must Be at Least 18770 Characters and Cannot Repeat Any of Your Previous 30689 Passwords" [1]
[1] https://support.microsoft.com/kb/276304
Edit: typo
Re:If you move your mouse continually the query may not fail...
by username223 on Saturday January 04, 2014 @01:13PM
(#7012145)
"Note that the number of required characters changes from 17,145 to 18,770 with the installation of SP1."
Wow. The story behind the extra 1625 characters must be good.
Re:If you move your mouse continually the query may not fail...
by Someone on Saturday January 04, 2014 @01:36PM
(#7012257)
My $0.02 is on a dull explanation: the max length and #remembered parameters must be configurable and/or depend on the access method, and the printf-like call that creates the message string must have passed erroneous pointers pointing into some DLL. When that DLL changed, or when another DLL changed in size, causing the DLL to move, the pointers pointed to different, but still constant data.
Re:If you move your mouse continually the query may not fail...
by ryen on Saturday January 04, 2014 @01:58PM
(#7012378)
Whats crazy is Microsoft believing this is an acceptable solution rather than fixing/patching it.
Re:If you move your mouse continually the query may not fail...
by Nilzor on Saturday January 04, 2014 @03:13PM
(#7012687)
They don't. It's listed as a workaround. The fix is Excel 2000.
Re:If you move your mouse continually the query may not fail...
by rbanffy on Saturday January 04, 2014 @09:07PM
(#7014130)
The crazy part is they made you pay for the fix. Therefore, it was considered acceptable behavior for Excel 97.
Re:If you move your mouse continually the query may not fail...
by lwan on Saturday January 04, 2014 @09:57PM
(#7014285)
Okay come on. It's not like this is a ridiculously common use case. Plus there are 2 other workarounds.
If you're playing with Oracle data that often, you're probably an enterprise customer who's going to buy the next version anyway.
It's not like this was happening every time you wanted to save or copy/paste data.
Re:If you move your mouse continually the query may not fail...
by rbanffy on Saturday January 04, 2014 @10:14PM
(#7014337)
I agree it's not a very relevant problem that didn't affect too many people. Still, it shows a pretty lame bug (that is, if the Oracle folks did their job correctly). In 1997 it was already usual to offer updates through the internet.
It's still kind of embarrassing.
Re:If you move your mouse continually the query may not fail...
by PythonicAlpha on Saturday January 04, 2014 @11:52AM
(#7011697)
>I believe many of us have seen crazier bugs.
Might be, but is it a good sign for computer industry as a whole?
Re:If you move your mouse continually the query may not fail...
by TeMPOraL on Saturday January 04, 2014 @01:04PM
(#7012102)
It's a sign we're having trouble in handling the complexity of our computer systems. Programming is mostly human-mind-bound now (and has been for many years); we need better tools and better abstractions.
Re:If you move your mouse continually the query may not fail...
by clarry on Saturday January 04, 2014 @01:27PM
(#7012224)
I think we need to remove that complexity and find a simpler approach to things, not just "better" (more complex) tools to layer even more complexity on top of complex.
Re:If you move your mouse continually the query may not fail...
by PythonicAlpha on Saturday January 04, 2014 @06:14PM
(#7013426)
I also would recommend that approach! The problem is, that you need more professional and better programmers that are aware of the problem and do reduce the complexity. Many self indulgent programmers, that think they are smart, won't.
But the trend is more to hire more and more novice programmers (because they are cheaper) ... so we get more into trouble in the future!
Re:If you move your mouse continually the query may not fail...
by userbinator on Saturday January 04, 2014 @10:24PM
(#7014364)
Agree completely. I think that contemporary CS education is really responsible for this "more complexity is better" mentality, by encouraging overly general and abstracted solutions, and that abstraction should really be applied only when it's necessary and not as a "just because we can" thing.
Aspiring programmers could learn a lot from the demoscene, where astonishingly impressive things are done with very little code and complexity.
Re:If you move your mouse continually the query may not fail...
by kyberias on Saturday January 04, 2014 @03:32PM
(#7012775)
Let's rephrase my point: the existence of this knowledge base article should not be taken as a sign for ANYTHING. :)