Why is my update affecting twice the number of records than expected?
An update trigger on table1 causes the UI to return double the amount of records. The 500 records are being updated. However, each update causes a new record to be inserted into an audit table. The UI returns the count of the total rows affected for the query statement, not just the update itself!