pgsql: Fix BRIN minmax-multi distance for interval type

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема pgsql: Fix BRIN minmax-multi distance for interval type
Дата
Msg-id E1lT6RE-0003xA-Pf@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix BRIN minmax-multi distance for interval type

The distance calculation for interval type was treating months as having
31 days, which is inconsistent with the interval comparator (using 30
days). Due to this it was possible to get negative distance (b-a) when
(a<b), trigerring an assert.

Fixed by adopting the same logic as interval_cmp_value.

Reported-by: Jaime Casanova
Discussion: https://postgr.es/m/CAJKUy5jKH0Xhneau2mNftNPtTy-BVgQfXc8zQkEvRvBHfeUThQ%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2b10e0e3c2ca14d732521479123e5d5e2094e143

Modified Files
--------------
src/backend/access/brin/brin_minmax_multi.c | 21 +++++++++++++--------
1 file changed, 13 insertions(+), 8 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Improve psql's behavior when the editor is exited without saving
Следующее
От: Tomas Vondra
Дата:
Сообщение: pgsql: Fix BRIN minmax-multi distance for timetz type