I want to stab MySQL between the eyes. Or rather if MySQL had eyes, I’d stab it squarely between them.
It just wasted far too much of my time with this bit of annoying behaviour. I’ll admit it was also my fault, but I still think MySQL reacted in a retarded way. (But then from a “database” system which on its default settings is happy to silently mangle data however it feels, that’s not too surprising).