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. Custom Library or What happened to PlatformLibrary?

I would like to add a custom JNI library to my platform so that I can
access it from several different client apps.  After doing some
research, it appears there was at one time an example of how to do
this included in the source called PlatformLibary (see the link

2. SSX released: Super Simple XML DOM-like API with simple XPath

Needed a fast (on Android), simple, small XML parsing library with a
great Java API.  So I wrote one.
Documentation at:
License (from me and my client): Apache 2.0

Let me know if you use it or have questions.

If you want much more painless Java->C++, for Android or just "native
Java", then check out JavaGlue:

Stephen D. Williams LinkedIn:
V:650-450-UNIX (8649) V:866.SDW.UNIX V:703.371.9362 F:703.995.0407
AIM:sdw Skype:StephenDWilliams Yahoo:sdwlignet Resume:


3. Android SDK platforms 2.2 and ASE

4. [WTA] : Movie Player untuk Spica

5. Giving Permission to another app

6. Android Emulator via Website

7. ACR122 USB NFC Reader with Android Mobile