[FIX] core: prefetching of context-dependent fields

Consider a context-dependent field, and successively access it on a
recordset with different contexts.  On the first context, the field is
correctly computed in batch.  After that, the field is always computed
one by one.

The bug is in the method that determines which records in a given set
have no value in cache.  On the first context, the cache is empty for
the field, so all records are returned.  After that, the method
considers that all records have a value in cache: they do, but for
another context key!  Simply using the context key when looking up the
cache fixes the issue.

closes odoo/odoo#52360

X-original-commit: 35d69589d9b43afe6c6fc9779458323f7180153e
Signed-off-by: Xavier Dollé (xdo) <xdo@odoo.com>
Co-authored-by: Xavier-Do <xdo@odoo.com>

1 files changed, 7 insertions, 0 deletions

diff --git a/odoo/addons/test_performance/models/models.py b/odoo/addons/test_performance/models/models.py
index aecca064ee9..95c0ef9bb54 100644
--- a/odoo/addons/test_performance/models/models.py
+++ b/odoo/addons/test_performance/models/models.py
@@ -11,6 +11,7 @@ class BaseModel(models.Model):
     name = fields.Char()
     value = fields.Integer(default=0)
     value_pc = fields.Float(compute="_value_pc", store=True)
+    value_ctx = fields.Float(compute="_value_ctx")
     partner_id = fields.Many2one('res.partner', string='Customer')
 
     line_ids = fields.One2many('test_performance.line', 'base_id')
@@ -22,6 +23,12 @@ class BaseModel(models.Model):
         for record in self:
             record.value_pc = float(record.value) / 100
 
+    @api.depends_context('key')
+    def _value_ctx(self):
+        self.env.cr.execute('SELECT 42')  # one dummy query per batch
+        for record in self:
+            record.value_ctx = self.env.context.get('key')
+
     @api.depends('line_ids.value')
     def _total(self):
         for record in self: