Another fun fact is that string comparisons are case insensitive by default:

https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.htm...

This can definitely catch you by surprise and cause bugs that are only detected late.