Strange behaviour querying for objects id a Query Layer

Discussion created by joanv on Jun 21, 2011
Dear all,

I have several Query Layers coming from an Oracle DB in my map service (10.01). They all work great except when I query them for objectIds. In this case it returns ALL the records when it should only return as many values as OIDS in the query.

I tested all my tables and layers, and it looks like only those created with Add Query Layer have the same behaviour, even those with geometry.

After that, I looked for a service with Query Layers as tables and I found this one, which is version 10 and acts exactly the same way.

I think it can be bug, can anyone confirm it? Any workaround?

Thank you