id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 2634,geography regression failure ST_DWithin/ST_Distance between 2.0.4 and 2.1.2 for dimensional mix of geographies,robe,pramsey,"This is unwatered down fresh from garden bot. I'll try to water it down to something we can throw in our tests: This is running on: {{{ POSTGIS=""2.1.2dev r12220"" GEOS=""3.4.2-CAPI-1.8.2 r0"" PROJ=""Rel. 4.8.0, 6 March 2012"" GDAL=""GDAL 1.10.0, released 2013/04/24"" LIBXML=""2.7.8"" LIBJSON=""UNKNOWN"" RASTER }}} {{{ SELECT ST_DWithin(geography(foo1.the_geom), geography(foo2.the_geom), 100, false) As result, ST_Distance(geography(foo1.the_geom), geography(foo2.the_geom)), _ST_DistanceUncached(geography(foo1.the_geom), geography(foo2.the_geom) ) FROM ((SELECT ST_Collect(ST_SetSRID(ST_MakePoint(i,j,k),4326)) As the_geom FROM generate_series(-10,50,20) As i CROSS JOIN generate_series(40,70, 25) j CROSS JOIN generate_series(1,3) k )) As foo1 CROSS JOIN ((SELECT ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05) As the_geom FROM (SELECT a*1.11111111 FROM generate_series(-10,50,10) As a) As i(i) CROSS JOIN generate_series(40,70, 20) As j ORDER BY i, i*j, j)) As foo2 LIMIT 2; result | st_distance | _st_distanceuncached --------+------------------+---------------------- f | 229423.805745173 | 229423.805745173 f | 75661.624157771 | 0 }}} ",defect,closed,critical,PostGIS 2.1.2,postgis,2.1.x,fixed,,