[PostGIS] #5632: After creating the index of GIST, ST_Equals gives the incorrect answer.
PostGIS
trac at osgeo.org
Fri Dec 1 11:38:52 PST 2023
#5632: After creating the index of GIST, ST_Equals gives the incorrect answer.
----------------------+---------------------------
Reporter: Wenjing | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.4.2
Component: postgis | Version: 3.4.x
Resolution: | Keywords:
----------------------+---------------------------
Comment (by pramsey):
Smaller replicator
{{{
DROP TABLE IF EXISTS t;
CREATE TABLE t AS
SELECT 1 AS id, 'POINT EMPTY'::geometry AS geom;
CREATE INDEX idx ON t USING GIST (geom);
SELECT * FROM t WHERE geom ~= 'POINT EMPTY'::geometry;
SET enable_seqscan = false;
SELECT * FROM t WHERE geom ~= 'POINT EMPTY'::geometry;
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5632#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list