[postgis-tickets] [PostGIS] #2363: st_distance with an added Integer value is not working in 2.0

[PostGIS]

#2363: st_distance with an added Integer value is not working in 2.0
---------------------+------------------------------------------------------
 Reporter:  vbalent  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 I have two PostGIS environments (Windows Server and Linux)
 My Linux Version does not retrun records and throws no errors;

 I have built a simple SQL function in that
 1) transforms my Lat Longs into State Plane US Feet WORKS
 2) measure the distance between the two points and buffer it by 1 mile
 (5280) US Feet DOES NOT WORK

 However No Errors are thrown, just No Records are returned.

 SQL Statement

 SELECT P1.* FROM PART_1_CRIMES P1  WHERE P1.PART_I_CRIME IN
 ('MURDER','RAPE','ROBBERY','AGGRAVATED_ASSAULT','BURGLARY','LARCENY','MV_THEFT','MV_LARCENY')
  AND ST_DISTANCE(ST_TRANSFORM(ST_POINTFROMTEXT('POINT(-73.76545859999999
 42.658618)', 4326), 2260),P1.GEOM)<=5280 ORDER BY P1.BEGINNING_DATE DESC
 LIMIT 1000;


 This exact same SQL statement works 100% as expected in this Version:

 PostgreSQL 9.1.7, compiled by Visual C++ build 1500, 32-bit
 POSTGIS="1.5.5" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.6.1, 21 August 2008"
 LIBXML="2.7.8" USE_STATS

 However not in this
 Version:

  PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
 20120313 (Red Hat 4.4.7-3), 64-bit POSTGIS="2.0.3 r11128" GEOS="3.3.
 8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.7.6"
 LIBJSON="UNKNOWN" TOPOLOGY


 Please advise?

 Regards
 Val
 518-457-5905

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2363>
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.