Opened 7 years ago

Closed 7 years ago

#3841 closed defect (fixed)

geography btree handling of empty

Reported by: pramsey Owned by: pramsey
Priority: medium Milestone: PostGIS 2.4.0
Component: postgis Version: master
Keywords: history Cc:

Description

As reported by Peter Geoghegan, we don't have a deterministic answer for how to sort a geography sets with EMPTY in them. This can cause bad behaviour in indexes (though hopefully nobody builds btree indexes on either geography or geometry).

Change History (5)

comment:1 by pramsey, 7 years ago

Patched trunk at r15680

comment:2 by pramsey, 7 years ago

Resolution: → fixed
Status: new → closed

comment:3 by robe, 7 years ago

Keywords: history added

are you ever going to add stuff to NEWS :)

comment:4 by robe, 7 years ago

Resolution: fixed
Status: closed → reopened

I assume you are making further changes to this per

​https://lists.osgeo.org/pipermail/postgis-devel/2017-September/026428.html

and perhaps you'll be gracious enough to note it in the NEWs file as well.

comment:5 by pramsey, 7 years ago

Resolution: → fixed
Status: reopened → closed

OK, NEWS is in, as are changes to handle typed empty.

Note: See TracTickets for help on using tickets.