android / android/nowinandroid
[Bug]: Fts Database data increase and insert infinitely
- Dominant language
- Kotlin
- Stars
- 21.8k
- Forks
- 4.6k
- Avg merge
- 19h 20m
- Merged PRs (30d)
- 2
Description
### Is there an existing issue for this?
- [X] I have searched the existing issues
### Is there a StackOverflow question about this issue?
- [X] I have searched StackOverflow
### What happened?
Both TopicFts and NewsResourceFts databases inserted always new data which came from network, not replaced.
The origin newsResourcesFts data size is 311, but in the image has 2177.
The origin topicsFts data size is 19, but in the image has 133.
### Relevant logcat output
_No response_
### Code of Conduct
- [X] I agree to follow this project's Code of Conduct
Contributor guide
Research direction
Start by tracing how TopicFts and NewsResourceFts receive network data and compare the origin counts with the reported database counts. Reproduce the repeated insertion, then verify that refreshing data replaces or updates existing records rather than growing the FTS tables indefinitely.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- android, kotlin
- Domain
- databases, mobile
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100