Recycling of _ID field in SMS Table

by shahzad ahmad » Wed, 25 Nov 2009 08:49:15 GMT

Sponsored Links
   I've just found out that _ID field is not always unique in SMS table and
gets repeated after some days. Is it normal or some bug ? Can someone tell
what is threshold before _ID field is repeated. Actually i have implementing
a logic thinking that _ID field is always unique in all records i.e SMS,
Call logs, Contacts etc but now discovered that it is not guaranteed to be
always unique in SMS messages. I didn't check for contacts , call logs etc
but it is true for SMS messages.

Suppose a SMS messages had _ID field equal to 1. But after some days that
message is deleted so now 1 is not assigned to any message as id, will the
system assign that id to some new message whenever it wants to ?



Other Threads

1. WMA Streaming.

Hi Experts,

Can you please give me some idea for "changes/modification reqd in
existing Android setup for WMA streaming".

Kindly assist.

Best Regards,

2. How to track down: java.lang.IllegalArgumentException: View not attached to window manager

> Since Cupcake I have a couple of those issues where I don't see my code in

That doesn't mean it's not your code at fault. For instance in this
case what are you doing with the dialogs and their parent activities?

Romain Guy
Android framework engineer

Note: please don't send private questions to me, as I don't have time
to provide private support.  All such questions should be posted on
public forums, where I and others can see and answer them


3. Block list view item

4. Example of Dataset Observers

5. How to donload all the files from this site

6. Alarm issue.

7. Conference cal