diff options
| author | Nicolas Seinlet <nse@openerp.com> | 2019-05-22 13:28:04 +0000 |
|---|---|---|
| committer | Nicolas Seinlet <nse@openerp.com> | 2019-05-22 13:28:04 +0000 |
| commit | 691b0e7e6fd1179452b19bf69f18a3692df79322 (patch) | |
| tree | 1f91212a8363168f0633cda1389d9750f911c182 /addons/lunch/report | |
| parent | dac369453ca43d8345da0352a97ac0d8bfa1f539 (diff) | |
[FIX] lunch : row_number with order
row_number without order is not invariant depending on the readed
fields. The order by clause on the partition solve this.
closes odoo/odoo#33573
Signed-off-by: Olivier Dony (odo) <odo@openerp.com>
Diffstat (limited to 'addons/lunch/report')
| -rw-r--r-- | addons/lunch/report/lunch_product_report.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/addons/lunch/report/lunch_product_report.py b/addons/lunch/report/lunch_product_report.py index 2615cb827ee..3a30fc426d3 100644 --- a/addons/lunch/report/lunch_product_report.py +++ b/addons/lunch/report/lunch_product_report.py @@ -69,7 +69,7 @@ class LunchProductReport(models.Model): self._cr.execute(""" CREATE or REPLACE view %s AS ( SELECT - row_number() over () AS id, + row_number() over (ORDER BY user_id,product.id) AS id, product.id AS product_id, product.name, product.category_id, |