I’m a programmer, and this reminds me of one time when I got a support call about a bug in our app: a “State” picklist with 509 entries (for you non-United Statesians, this is a bit more than the 50 or so states - we sometimes include shit like DC, Puerto Rico and Guam in these lists - I should have been seeing), including about 20 different versions of “Louisiana” (like Lousiana, Louisiania etc.) and lots of different countries (occasionally spelled correctly). What had happened was that we originally had a table in the database for listing all the states, and one of our coders got the assignment to add a marriage license module to the app, mirroring the state’s paper form that was used for this. Since the “State” line had to accommodate people from other countries, the clerks just used this line to enter whatever country they were from and insisted on the same functionality in the app. Since our database was fully relational, this coder just used the existing “States” table but added new entries in code whenever a user typed out a non-standard thing in the box. Completely hosing every place in the app that used a States picklist.
The real mystery was how this table grew to 509 entries before anyone noticed a problem.