The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.)
When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than the library of the real file) and so users that started using the file after this were working with the dupe and the others were using the real one.
We can't figure out why that would have happened and never saw it before. Anyone seen anything like this happening?