Life has a funny way to hinting at us, unfortunately most of the time we are just not aware of it. Case in point:
Yesterday afternoon I spent 2-3 hours cursing at MySql because my stored procedure just didn’t work. The syntax looked fine. The condition check worked correctly by itself but just not inside the sproc. I was not a happy camper.
This morning I was helping to troubleshoot an issue that arose in test environment. Turned out the problem had to do with MySql’s case insensitivity. This was different from Microsoft’s SQL Server, with which I had more experience.
After lunch I continued with my MySql stored procedures. I grabbed a colleague to help, and he pointed out that the cause was with MySql’s case insensitivity, again.
So the test issue this morning was code-monkey king’s way of hinting me at my sproc bug, but I was just totally oblivious to it.
I’ve had the same experience myself, where the same problem suddenly shows up in different settings at the same time. I guess I need things to hit me on the head a few times before I learn.
Hammer time!
I hate it when that happens. But I’m sure you will remember next time.