[postgis-tickets] [PostGIS] #2369: SQL Statemant Works in Windows version 1.5x Not in Liunx version 2.0x

[PostGIS]

#2369: SQL Statemant Works in Windows version 1.5x  Not in Liunx version 2.0x
----------------------+-----------------------------------------------------
 Reporter:  vbalent   |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  critical  |   Milestone:  PostGIS 2.1.0
Component:  postgis   |     Version:  2.0.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 This is the second time this week that my ST Functions that worked fine in
 Windows Server are now not working in Linux.

 I truly doubt PostGIS is trying to break a lot of peoples codes?

  SQL Statement

 SELECT P1.* FROM PART_1_CRIMES P1, "PatrolZones" PZ WHERE P1.PART_I_CRIME
 IN ('MURDER','RAPE','ROBBERY','AGGRAVATE
 D_ASSAULT','BURGLARY','LARCENY','MV_THEFT','MV_LARCENY')  AND
 PZ.ID_AS_STRI IN('101','102','103','104','105','106',
 '107','108','109','110','201','202','203','204','205','206','207','208','209')
 AND ST_WITHIN(P1.GEOM,PZ.the_geom) ORDER
 BY P1.BEGINNING_DATE;



  This exact same SQL statement works 100% as expected in this Windows
 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
  Linux 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?

 Thanks,
 Val

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