https://community.wanikani.com/ 에서 누군가 제 게시물에 '좋아요’를 눌렀다는 알림을 받았고, 이어 ‘훌륭한 답변’ 배지 획득 알림이 왔습니다. 해당 '좋아요’는 실제로 그 게시물의 50번째 '좋아요’였습니다. 하지만 배지 획득 날짜는 5일 전으로 표시되어 있습니다. 이런 현상은 이전에 최소 한 번 더 본 적이 있습니다.
The Great Reply badge query is using the post’s updated_at column to set when the badge was granted. Liking a post does not reset its updated_at value, so granted at will be set to the post’s creation date, or to the last time the post was edited.
We have a few other queries that are triggered when a user acts on a post that set the granted at time in the same way. For badges where the query is run once daily, for example the Famous Link badge, current_timestamp is used to set granted_at. Could a similar approach be used for queries that are triggered when a user acts on a post?