mybatis lose duplicated rows when using association

[gaofeng816]

I have a resultMap definition:

<select id="querySellerSupplierNotice" resultType="Message">
    SELECT
    a.id,
    a.create_time as message_create_time,
    a.content,
    b.title,
    c.subdomain,
    b.id as bid,
    c.id as cid
    FROM
    message a
    INNER JOIN supplier b
    ON
    a.user_id = b.user_id
    LEFT JOIN site c
    ON
    a.user_id = c.user_id
    INNER JOIN ln_seller2product d
    ON a.user_id =
    d.supplier_user_id
    WHERE a.type
    = 'corpnews'
    AND a.create_time >
    date_sub(curdate(), interval 90 day)
    AND a.STATE = 1
    AND d.seller_user_id =
    #{sellerId}
    ORDER BY
    a.create_time DESC,b.title DESC
  </select>

<resultMap type="Message" id="sellerSupplierMap">
    <id property="id" column="id" />
    <result property="content" column="content" />
    <result property="createTime" column="message_create_time" />
    <association property="supplier" column="user_id" javaType="Supplier">
      <id property="id" column="bid" />
      <result property="title" column="title" />
    </association>
    <association property="site" column="user_id" javaType="Site">
      <id property="id" column="cid" />
      <result property="subdomain" column="subdomain" />
    </association>
  </resultMap>

this select will return over 70 rows but a lot of them are totally duplicated.

If I use resultType="hashmap" or resultType="Message" it will returns all rows.
But I use the resultMap above, mybatis will automatically ignore the duplicated rows, and returns a small list than expected.

I don't think it's appropriate for mybatis to drop rows under any scenario.

[harawata]

It is the expected behavior when you use association or collection.
There is a simple explanation comment on the similar issue #512 .

If you want all the rows returned, just build a resultMap without association.

<resultMap type="Message" id="sellerSupplierMap">
  <id property="id" column="id" />
  <result property="content" column="content" />
  <result property="createTime" column="message_create_time" />
  <result property="supplier.id" column="bid" />
  <result property="supplier.title" column="title" />
  <result property="site.id" column="cid" />
  <result property="site.subdomain" column="subdomain" />
</resultMap>

[edited: wrong issue number]