I'm experimenting with this new ArcGIS Pro 2.0+ that became available at my workplace (currently using ArcMap), and I'm experiencing some inconsistencies with datasets brought in via query layers from our SQL Server (currently '08 server. Tried w/ a '16 server and had same issues).
Some datasets seem to work just fine (selecting / "identifying" / searching), and some datasets erroneously return incorrect records when I "identify" them with the new "Explore" button. Example: I "identify" a utility pole in front of our building, which I know has a name of "POLE-X", but the "identify/explore" window returns back "POLE-W". If I "identify" that pole again it may return another pole, "POLE-Z", or sometimes no object attributes at all.
Has anybody encountered odd behavior like this before?