@Cmastication we got caught by this when we upgraded to MySQL 8 and the implicit row order sorting went away. We had a couple places we were unintentionally relying on that order and they were returning randomly now, leading to wild bugs (especially across paginated APIs). And because one of them was in a less used part of the app, it was live for a couple months before we got a big report.