For some reason, QGIS is not displaying the correct row of my data when I click on a feature with "Select Single Feature" or even the other select tools.
I have a point database linked from mysql. There is a column named ASR with a unique number. When I plot all of the points, they are correct - everything is where it should be. When I label the points they are all correct - ASRs correspond to points in the correct locations. When I open the attribute table, select a line, and then zoom to that feature, it works fine. Correct point, correct labeling, all good.
HOWEVER, if I just display the map of all the features and try clicking on one with the 'Show selected only' checked, it doesn't actually select the right point, and moreover it shows the wrong row. In most cases if I select a rectangle of 20 or 30 points, it actually highlights 20 or 30 OTHER points, and displays various results in the attribute table.
I'm totally confused. Almost everything is working right and its clear that the record data and point data are correct and in agreement, but selecting features by mouse is totally hosed.