[PATCH]: fix bug in SP-GiST box_ops

From: Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: [PATCH]: fix bug in SP-GiST box_ops
Date: 2017-01-30 04:12:03
Message-ID: 9ea5b157-478c-8874-bc9b-050076b7d042@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Working on the tests for new SP-GiST opclasses for polygons and circles, I've
found a bug in the SP-GiST box_ops (added in 9.6): some operators
(&<, &>, $<|, |&>) have wrong tests in spg_box_quad_inner_consistent().
This obviously leads to incorrect results of a SP-GiST index scan (see tests
in the attached patch, their results were taken from a sequential scan).

Nikita Glukhov
Postgres Professional:http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
fix-bugs-in-SP-GiST-box_ops-v01.patch text/x-patch 8.5 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2017-01-30 04:44:09 Re: [PATCH] Rename pg_switch_xlog to pg_switch_wal
Previous Message Stephen Frost 2017-01-30 04:06:41 pgsql: test_pg_dump TAP test whitespace cleanup