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?