topic Re: bug: Query Where 1=2 returns more than zero features in ArcGIS REST APIs and Services Questions

bug: Query Where 1=2 returns more than zero features

KirkKuykendall — Mon, 28 Nov 2011 19:20:22 GMT

I would expect the count to be zero if Where="1=2", however I get 3149 (all features).

http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Specialty/ESRI_StatesCitiesRivers_USA/MapServer/0/query?text=&geometry=&geometryType=esriGeometryPoint&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&objectIds=&where=1%3D2&time=&returnCountOnly=true&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=&outFields=&f=html

In some cases I notice setting Where="1=1" is used to return all rows, seems like 1=2 would return none.

Re: bug: Query Where 1=2 returns more than zero features

RaviNarayanan — Tue, 29 Nov 2011 13:01:17 GMT

Kirk,
Thank you for this posting. Since this is a 10.0 specific issue, I have submitted a bug for ArcGIS Server for .NET 10.0. Please let us know if this is critical for your workflow.

This is not reproducible in 10.1 beta.

Re: bug: Query Where 1=2 returns more than zero features

KirkKuykendall — Tue, 29 Nov 2011 13:50:34 GMT

Thanks Ravi, Is there a 10.1 sample server available for me to test against?

Re: bug: Query Where 1=2 returns more than zero features

RaviNarayanan — Wed, 21 Dec 2011 15:39:58 GMT

Here is one --
http://servicesbeta4.esri.com/arcgis/rest/services