filtered_domain() computed quarters in four-month groups and counted weekdays from Monday, so it could disagree with search(). Both now follow PostgreSQL. Check custom code that relied on the old in-memory results.
On the upgrade checklist: 18.0 → 19.0
| Branch | Pull request | Commit |
|---|---|---|
| 19.0 | odoo/odoo#292818 ↗ | 54236254d1 ↗ |
| 20.0 | odoo/odoo#293389 ↗ | 4d2d9ef6de ↗ |
[FIX] orm: align quarter and weekday filters with SQL In-memory date domains calculate quarters using four-month groups and weekdays with Monday as zero. SQL uses three-month quarters and Sunday as zero, so filtered_domain() and search() can return different records. Correct the quarter calculation and use the same weekday numbering as PostgreSQL for date and datetime fields. Add regressions comparing SQL and in-memory filtering across all months and weekdays, including the complementary domains. Fixes #292723.