Unenumerbrated
by in Feature Articles on 2026-11-16Submitter Valts shares an enumerated mystery:
This happened a few years ago (before COVID). A colleague called me over because he couldn't make sense of the results he was getting from some MySQL queries in MySQL Workbench. I don't remember the queries in particular, but let's say
select * from payments where client_id=1234showed 12 rows, all having thesuccessfulfield set to1. But when you selectedselect count(*) from payments where client_id=1234 and successful=1you got back0rows. And this was reproducible on my machine, too. Yet in code similar queries worked just fine.