How do implicit joined columns work with Android contacts data?-ThrowExceptions

Exception or error: I’m querying the ContactsContract.Data table to find phone records. I get an error when I create a new CursorLoader: java.lang.IllegalArgumentException: Invalid column deleted My code: import android.provider.ContactsContract.CommonDataKinds.Phone; import android.provider.ContactsContract.Data; … String[] projection = { Phone.DELETED, Phone.LOOKUP_KEY, Phone.NUMBER, Phone.TYPE, Phone.LABEL, Data.MIMETYPE, Data.DISPLAY_NAME_PRIMARY }; // “mimetype = ? AND deleted = ?” String selection …

Return type for Android Room joins-ThrowExceptions

Exception or error: Let’s say I want to do an INNER JOIN between two entities Foo and Bar: @Query(“SELECT * FROM Foo INNER JOIN Bar ON Foo.bar = Bar.id”) List<FooAndBar> findAllFooAndBar(); Is it possible to force a return type like this? public class FooAndBar { Foo foo; Bar bar; } When I try to do …