diff options
| author | SEINLET Nicolas <nse@odoo.com> | 2020-08-20 09:28:58 +0000 |
|---|---|---|
| committer | SEINLET Nicolas <nse@odoo.com> | 2020-08-20 16:40:23 +0000 |
| commit | 48ccbe67c66755d14ab537d04ac9ff407efe6335 (patch) | |
| tree | 395698e03f3a7889c4833f3166b53da4909792f4 /doc/reference | |
| parent | 53064e3db1c13e7015f0f730aa5646b80fa9c509 (diff) | |
[IMP] account: make sequence indexable
the search for sequence include a criteria `date_trunc('year', date) =
date_trunc('year', '2017-10-01'::date)` Which is translated by query
planner in `date_trunc('year'::text, date::timestamp with time zone)`.
As it's mutable thanks to the time zone, it's not indexable. Enforcing
the `without timezone` makes the query planner use an immutable
`date_trunc('year'::text, date::timestamp without time zone)`. As it's
immutable, it's indexable.
closes odoo/odoo#56244
X-original-commit: 70f671a32a504c6aa92fd19e38e6151c10b2325b
Signed-off-by: Quentin De Paoli (qdp) <qdp@openerp.com>
Diffstat (limited to 'doc/reference')
0 files changed, 0 insertions, 0 deletions