diff options
| author | anatawa12 <anatawa12@icloud.com> | 2025-08-17 17:08:38 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-08-17 17:08:38 +0900 |
| commit | fea9f27fd6e9d04e0746e4dfc6f971aacc001eb9 (patch) | |
| tree | c15c9701b99a630da15558d26365778591a26358 /packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts | |
| parent | Bump version to 2025.8.0-alpha.12 (diff) | |
| download | misskey-fea9f27fd6e9d04e0746e4dfc6f971aacc001eb9.tar.gz misskey-fea9f27fd6e9d04e0746e4dfc6f971aacc001eb9.tar.bz2 misskey-fea9f27fd6e9d04e0746e4dfc6f971aacc001eb9.zip | |
chore: preserve notes with local reactions (#16412)
Diffstat (limited to 'packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts')
| -rw-r--r-- | packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts b/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts index f53d403280..36c34c753c 100644 --- a/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts +++ b/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts @@ -86,6 +86,7 @@ export class CleanRemoteNotesProcessorService { 'note."userHost" IS NOT NULL', 'NOT EXISTS (SELECT 1 FROM user_note_pining WHERE "noteId" = note."id")', 'NOT EXISTS (SELECT 1 FROM note_favorite WHERE "noteId" = note."id")', + 'NOT EXISTS (SELECT 1 FROM note_reaction INNER JOIN "user" ON note_reaction."userId" = "user".id WHERE note_reaction."noteId" = note."id" AND "user"."host" IS NULL)', ].join(' AND '); const minId = (await this.notesRepository.createQueryBuilder('note') |