git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix BRIN minmax-multi distance for timetz type

author Tomas Vondra <tomas.vondra@postgresql.org>

Sun, 4 Apr 2021 17:21:41 +0000 (19:21 +0200)

committer Tomas Vondra <tomas.vondra@postgresql.org>

Sun, 4 Apr 2021 17:22:23 +0000 (19:22 +0200)

commit 7262f2421a1e099a631356f7b80ad198e34e2a8a

tree 78b6ff8f6170861dbfcf8e91c86f3586372fba4d tree

parent 2b10e0e3c2ca14d732521479123e5d5e2094e143 commit | diff

Fix BRIN minmax-multi distance for timetz type

The distance calculation ignored the time zone, so the result of (b-a)
might have ended negative even if (b > a). Fixed by considering the time
zone difference.

Reported-by: Jaime Casanova
Discussion: https://postgr.es/m/CAJKUy5jLZFLCxyxfT%3DMfK5mtPfSzHA1rVLowR-j4RRsFVvKm7A%40mail.gmail.com

src/backend/access/brin/brin_minmax_multi.c diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom