@peemee A transmission is something I touch grudgingly. They're never simple. Everything that breaks takes a herculean effort to get to it seems.
After helping the CEO put a new transmission in a 7 series BMW, I vowed never to offer such help again.
It's amazing how muscle memory works.
For the first time since childhood, I actually lost my balance and fell. Was walking into a bookstore with sidekick and I somehow stubbed my toe on the curb. Had too much forward momentum to regain my balance so I fell,
Many, many years before, I was heavily into judo. Most of our early classes were being grabbed, sometimes unaware, and slammed into the ground. There was a purpose to this. Once you instinctively know how to land, taking the shock with your arm/shoulder and leg, you're golden. Eventually, you can reverse it and throw the other guy without thinking.
Well, when I fell, it all kicked in. Leg. Arm.
Sidekick thought it was pretty badass that a 240 pound 50 plus guy could fall onto a concrete patio and emerge without even a bruise.
@sumudu I'e been so far removed from social media it isn't funny. Just too many other things occupying my attention.
@matigo It boggles my mind. Many hundreds of businesses run that report at the end of the month (some weekly). In 13 years, that bug has never once surfaced.
Upon further review of the code, that SQL was only generated if a customer was using a very advanced feature that almost no-one else uses. Namely because they don't know about it nor do they need it anyway. Very specific use case.
if(!lastFilterName.isEmpty())
ss << " AND w.won IN (SELECT won FROM "
<< lastFilterName << ')';Incredible how a line of code, in service for almost 13 years without incident, can only be called in a one in a million circumstance and bomb.
It's part of some generated SQL and that particular case is never reached. It's a one in a million shot the temporary table referenced by lastFilterName exists at that stage. (It's complicated)
In this case it was and the w.won column blew massive chunks because NOTHING in that generated SQL ever selected anything and referenced it as as w. (Should have been s.). Probably a copy/paste thing we did years ago and we just didn't catch it…because that line was never, ever reached. In hundreds of installations. For 13 years. Until two hours ago in Alabama.
This is why I live in outer space and Skyrim after hours.
Since I have been inundated by work-related things, I have decided to do some non-work-related things.
Wrote a mod to un-do a "fix" the Skyrim unofficial patch made to Redbelly Mine and Shor's Stone. I rather miss having a early source of ebony ore.
Wrote a mod to make the Greybeard robes craftable and wearable. Plus, made a light armor variant that can be crafted and upgraded.
Modified a couple of my favorite, small house mods to my liking and repackaged them.
So, I've decided to live in Skyrim instead of reality this evening.