IssueTracker

Component used: Room

Version used: 2.4.0-beta02

Devices/Android versions reproduced on: Pixel 3a (Android 11)

I have 3 entities as defined below (there are other fields in each entity, but for simplicity these are the relevant ones):

My DAO has this function:

@Query(
"""
SELECT * FROM library_item_resources
    LEFT JOIN library_item_resource_refs
    ON library_item_resources.slug = library_item_resource_refs.resource_slug
    WHERE library_item_resources.library_item_slug = :libraryItemSlug
"""
)
suspend fun getLibraryItemResources(
    libraryItemSlug: String
): Map<LibraryItemResourceEntity, List<LibraryItemResourceRefEntity>>

I am getting a crash on kotlin.jvm.internal.Intrinsics.checkNotNullParameter, parameter library_item_slug.

Looking at the generating Dao_Impl.java file I see this in the corresponding generated DAO function:

final int _cursorIndexOfLibraryItemSlug = CursorUtil.getColumnIndexOrThrow(_cursor, "library_item_slug");
final int _cursorIndexOfLibraryItemSlug_1 = CursorUtil.getColumnIndexOrThrow(_cursor, "library_item_slug");

...

if (_cursor.isNull(_cursorIndexOfLibraryItemSlug_1)) {
  _libraryItemSlug_1 = null;
} else {
  _libraryItemSlug_1 = _cursor.getString(_cursorIndexOfLibraryItemSlug_1);
}

When I renamed column library_item_slug in each entity, the function works as expected. It seems the problem is that the overloaded column name is causing problems with CursorUtil.getColumnIndexOrThrow .