Data in my reports and in the Data Browser are showing incorrect IDs, however, when I switch over to the database I see the correct IDs as expected. Thus, this appears to be an issue with MyDBR reporting only and not a real issue with the data (thank goodness!)...
I am stuck using BIGINT(19) for my IDs, this is due to legacy constraints, but for all intents and purposes this was working just fine in MyDBR until today.
Today, when I re-ran a report I noticed that IDs which are required to be unique, have been "copied" down by MyDBR and appear the same for multiple records in an arbitrary fashion (which is impossible because the column is primary key and auto-increment).
Screenshots visual the issue well
MyDBR Report screenshot:
MyDBR Data Browser screenshot:
Edit: to add, this issue affects most, if not all tables in my database, it's not isolated to the one above.
I am losing hair trying to figure this out, couple things I want to mention that may help:
1. I accidentally set the ID column to BIGINT(20) when it should actually be BIGINT(19), however, I don't think this has caused the issue as BIGINT's of 19 characters should fit just fine within a BIGINT(20) column.
2. I ran an update yesterday, but I did not notice this issue right away, thus I'm not able to isolate the update as the cause.
Help is greatly appreciated!