diff options
| author | Jeremy Kersten <jke@odoo.com> | 2016-07-01 10:22:52 +0200 |
|---|---|---|
| committer | Jeremy Kersten <jke@odoo.com> | 2016-07-04 15:48:15 +0200 |
| commit | 4dce86164cdf8ec95cc0d7f45c8aa516c7568504 (patch) | |
| tree | 2feaa104fbdecc59cf65a3252bb0c2d3368c73de /doc/reference/javascript.rst | |
| parent | 645b1687fc6f9882a922ebff586934533609d4f4 (diff) | |
[FIX] website_sale: fix order for the pager in front end.
In psql, use LIMIT and OFFSET together without a fully specified and uniq sort order
will generate unexpected behaviour.
Eg:
> id id_dept name
> -------------------
> 1 1 Tom
> 2 1 Mike
> 3 2 Meggie
> 4 2 Marge
> 5 3 Bart
> 6 3 Lisa
> using LIMITed selects like:
> SELECT * FROM employee ORDER BY id_dept LIMIT 3
> SELECT * FROM employee ORDER BY id_dept LIMIT 3 OFFSET 3
> SELECT * FROM employee ORDER BY id_dept LIMIT 3 OFFSET 6
> You can have some result missings from the 3 requests, and others duplicated.
> Because id_dept is not a uniq order.
Diffstat (limited to 'doc/reference/javascript.rst')
0 files changed, 0 insertions, 0 deletions
