How MySQL Implicit Type Conversion Turned an Indexed Query Into a 7M-Row Scan

It was supposed to be a standard, run-of-the-mill maintenance task—the kind of routine database housekeeping that backend engineers perform dozens of times a month without a second thought. A small batch of customer account records needed…