Android Room @Query报错：查询返回字段与实体不匹配问题

问题场景 #

在Room DAO中编写关联Conversation与User表的查询，为解决两个实体类的同名字段冲突，给@Embedded添加了prefix注解，但仍出现字段不匹配错误。

DAO代码 #

@Query("select Conversation.*, User.* from Conversation join User on Conversation.createdBy = User.userUuid where conversationUuid = :conversationUuid")
fun selectAllForOverview(conversationUuid: UUID): LiveData<List<ConversationSelectAllForOverview>>

数据类定义 #

data class ConversationSelectAllForOverview(
    @Embedded(prefix = "arg0")
    val arg0: DbConversation,
    @Embedded(prefix = "arg1")
    val arg1: DbUser
)

错误信息 #

error: 查询返回的列在entity.ConversationSelectAllForOverview中找不到对应字段
[conversationUuid,createdBy,tsCreated,distanceMapped,showOnMap,showOnOverview,allowMessagesByInRangeRegularUsers,allowMessagesByOutOfRangeRegularUsers,stillReadableForOutOfRangeRegularUsers,freedomInReplies,title,subject,likes,latitude,longitude,hasPassword,isSubscribed,showOnMapScreen,isLiked,bypassChecks,isHidden,nsfw,currentDirectEvents,totalDirectEventsAfterLastJoin,subscriptions,userUuid,username,karma,tsCreated,allowsPrivateChats,allowsNsfw,thisUserBlockedCurrentUser,incomingFriendshipRequest,outstandingFriendshipRequest,friends,bio,appRoleMapped]
这些字段被标注为非空或基本类型。查询返回的列：
[conversationUuid,createdBy,tsCreated,distanceMapped,showOnMap,showOnOverview,allowMessagesByInRangeRegularUsers,allowMessagesByOutOfRangeRegularUsers,stillReadableForOutOfRangeRegularUsers,freedomInReplies,title,subject,likes,avatar,latitude,longitude,hasPassword,isSubscribed,showOnMapScreen,isLiked,bypassChecks,isHidden,conversationReportReasonMapped,nsfw,currentDirectEvents,totalDirectEventsAfterLastJoin,lastReadConversationEventPk,mostRecentConversationEventUuid,relevance,subscriptions,userUuid,username,karma,tsCreated,allowsPrivateChats,allowsNsfw,avatar,currentUserBlockedThisUserTsCreated,thisUserBlockedCurrentUser,searchScreenScore,recentSearchedTsCreated,userReportReasonMapped,incomingFriendshipRequest,outstandingFriendshipRequest,friends,bio,appRoleMapped]
public abstract androidx.lifecycle.LiveData<java.util.List<entity.ConversationSelectAllForOverview>>
selectAllForOverview(@org.jetbrains.annotations.NotNull()

解决方案 #

• 修改查询语句，为返回列添加对应前缀的别名
  核心问题是：使用@Embedded(prefix)后，Room期望查询返回的列名是前缀_原字段名，但select *返回的是原字段名，没有前缀，导致匹配失败。必须明确列出所有字段并添加对应前缀的别名，示例如下：

  @Query("""
      select 
          Conversation.conversationUuid as arg0_conversationUuid,
          Conversation.createdBy as arg0_createdBy,
          Conversation.tsCreated as arg0_tsCreated,
          -- 列出DbConversation的所有字段，统一添加arg0_前缀
          User.userUuid as arg1_userUuid,
          User.username as arg1_username,
          User.karma as arg1_karma,
          User.tsCreated as arg1_tsCreated,
          -- 列出DbUser的所有字段，统一添加arg1_前缀
      from Conversation 
      join User on Conversation.createdBy = User.userUuid 
      where conversationUuid = :conversationUuid
  """)
  fun selectAllForOverview(conversationUuid: UUID): LiveData<List<ConversationSelectAllForOverview>>
  

  注意：禁止使用select *，否则同名字段（如tsCreated）会重复返回，且Room无法匹配到带前缀的目标字段。

• 核对实体类与数据库列名的映射
  确认DbConversation和DbUser的字段是否与数据库列名完全对应，如果实体类字段用@ColumnInfo(name = "xxx")指定了列名，查询中的别名要对应前缀_xxx，而非实体类的字段名。

• 优化前缀命名（可选）
  将arg0、arg1改为更直观的前缀（如conv_、user_），提升代码可读性：

  data class ConversationSelectAllForOverview(
      @Embedded(prefix = "conv_")
      val conversation: DbConversation,
      @Embedded(prefix = "user_")
      val user: DbUser
  )
  

  对应的查询语句中，字段别名也要同步改为conv_conversationUuid、user_userUuid这类格式。

内容的提问来源于stack exchange，提问作者J. Doe