Why Did MySQL’s BIT Index Miss a Query? A Real‑World Debugging Tale
A production MySQL service crashed due to a BIT(1) status column being compared with a string in an indexed query, revealing how implicit type conversion and index usage can cause unexpected bugs and how removing the offending index quickly resolved the issue.
