前几天公司有个项目要过google的CTS测试，但是Contacts模块老是有两条case fail不能通过，在这里记录一下。

android.provider.cts.ContactsProvider2_AccountRemovalTest

------------testAccountRemovalWithMergedContact_hasDeleteLogsForContactsrun

------------ testAccountRemoval_hasDeleteLogsForContacts fail

 

通过查阅国外的网站原来Contactsproviders的查询效率出了问题，修改如下：

 

Bug fix:

db.rawQuery( "SELECT " + RawContactsColumns.CONCRETE_CONTACT_ID +

          " FROM " + Tables.RAW_CONTACTS +

          " WHERE " + RawContactsColumns.ACCOUNT_ID + " = ?1" +

*****************added this*********************************************************"

AND "+ RawContactsColumns.CONCRETE_DELETED+ " != 1"+

 ******************added this********************************************************"

AND " + RawContactsColumns.CONCRETE_CONTACT_ID +

                    " NOT IN (" +

                   " SELECT " + RawContactsColumns.CONCRETE_CONTACT_ID +

                    " FROM " + Tables.RAW_CONTACTS +

                   " WHERE " + RawContactsColumns.ACCOUNT_ID + " != ?1

" *************************this is added********************************************* +

 " AND "+ RawContactsColumns.CONCRETE_DELETED+ " !=

1"*************************this is added*********************************************

+")", accountIdParams)

 

if u see i have added a extra check " AND "+ RawContactsColumns.CONCRETE_DELETED+ " != 1"