Fixed update test and implementation

Update will alter the previous row to invalidate. self will have the new
row_id.
Merge remote-tracking branch 'upstream/master'
Ammend with 'as_of' effective date
Merge remote-tracking branch 'upstream/master'