Got a bug that we don't make a log entry for a module in one case. Turns out they are reading the text of the log to determine how to make calculations for one of their reports.
Who bases $ calculations on log entries? It's not real data. I think Joe Celko would have a good rant over that.
The reasoning was that the comparison between created date and updated date was unreliable. Instead of a trigger band-aid which would have left their code the same after the reliability issue was resolved, this solution was devised.
Two days and many man-hours of research later we found that the reason they had no log was that someone updated the database through an Ad-Hoc SQL query. The log is generated through the GUI changes.
Posts
The One about Bingeworthy Shows
4 years ago
No comments:
Post a Comment
Be nice... it's the only internet we have.