Select to view content in your preferred language

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

725
3
11-28-2011 11:20 AM
KirkKuykendall
Deactivated User
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/Map...

In some cases I notice setting Where="1=1" is used to return all rows, seems like 1=2 would return none.
0 Kudos
3 Replies
RaviNarayanan
Esri Contributor
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.
0 Kudos
KirkKuykendall
Deactivated User
Thanks Ravi,  Is there a 10.1 sample server available for me to test against?
0 Kudos
RaviNarayanan
Esri Contributor
0 Kudos