Bonus points table does not reflect issue title updates and shows old titles instead of renamed ones
The bonus_points table currently stores the reason as a string. Since we recently updated it to show the issue title instead of the issue link, two problems have emerged:
- Newly created entries display the latest format (issue titles), while older entries still show the legacy data.
- When an issue title is renamed, the change is not reflected here—unlike in the create_issue table—because there is no synchronisation logic or trigger mechanism in place.
Discussion Points
We should decide whether to:
- Perform a one-time migration to update existing bonus_points entries from issue URLs to titles, or
- Implement a dynamic solution that keeps issue titles in sync when they are renamed in the source table.
Recreation steps
- Create a bonus point entry for an issue.
- Observe how the bonus_points entry logs the issue title in the reason column.
- Rename the issue title.
- Check whether the title change is reflected in the bonus_points table.
Implementation plan
To Do
Related Discussion
See #226 (closed)
Edited by 🤖 GitLab Bot 🤖