Merge branch 'main' into avm99963-monorail
Merged commit 34d8229ae2b51fb1a15bd208e6fe6185c94f6266
GitOrigin-RevId: 7ee0917f93a577e475f8e09526dd144d245593f4
diff --git a/tools/backfill-issue-timestamps.sql b/tools/backfill-issue-timestamps.sql
index 0cc84a8..3c1302c 100644
--- a/tools/backfill-issue-timestamps.sql
+++ b/tools/backfill-issue-timestamps.sql
@@ -1,8 +1,6 @@
--- Copyright 2016 The Chromium Authors. All Rights Reserved.
---
--- Use of this source code is governed by a BSD-style
--- license that can be found in the LICENSE file or at
--- https://developers.google.com/open-source/licenses/bsd
+-- Copyright 2016 The Chromium Authors
+-- Use of this source code is governed by a BSD-style license that can be
+-- found in the LICENSE file.
DROP PROCEDURE IF EXISTS BackfillIssueTimestampsChunk;
@@ -39,8 +37,8 @@
SELECT c_issue_id AS 'Processing:';
-- Set the fields to the largest timestamp of any relevant update.
- UPDATE Issue
- SET
+ UPDATE Issue
+ SET
owner_modified = (SELECT MAX(created)
FROM IssueUpdate
JOIN Comment ON IssueUpdate.comment_id = Comment.id
@@ -87,4 +85,3 @@
delimiter ;
-