Have we considered not writing tests that assert every query ever made to the database, whether that query hit the cache, and what order they were executed in? Your test doesn't need to care about SELECT statements being run.
Show this thread
-
The former makes sense for integration tests tho
It really doesn't. It's just an insidiously disguised version of the latter. You're coupling yourself to details you don't want to be.