In Progress 2.9.7 - NS - MMS Backups corrupted

[weedy]

MMS backups can become corrupted where the backup will merge sms and mms messages.
The backup app will show thousands of MMS being restored when the true number should be around 200 or less.

This do not cause duplicates in the MMS app but significantly slows down the processing and rendering of MMS in a thread.

 

[weedy]

Still present in 2.9.21. And getting worse as my MMS count increases.

 

[iBotPeaches]

Reported: http://www.miui.com/thread-771820-1-1.html

 

[weedy]

Still present in 2.11.2.

This seems to fix it 'DELETE FROM pdu WHERE thread_id IS NULL'.
So the Backup/SMS app should drop database entries that are missing vital fields, like the thread_id, ct_t, or tr_id.
Xiaomi should know better what to filter on, but thread_id is probably best.