Hi,

I've been trying to use the groupBy feature available in the trunk and it works great. However, I haven't managed to have the right results for maps that return a primitive.

These are the result maps:

<resultMap id="Fields.ResultMap" class="Field">
      <result property="Id" column="id"  />
      <result property="Name" column="name" />
      <result property="Description" column="description" />
      <result property="FieldType" column="field_type"/>
    </resultMap>

    <resultMap id="Fields.Fill.ResultMap" class="Field" extends="Fields.ResultMap" groupBy="Id">
      <result property="PossibleValues" column="value_text" resultMapping="Fields.PossibleValues.ResultMap" />
    </resultMap>

    <resultMap id="Fields.PossibleValues.ResultMap" class="string">
      <result property="value" column="value_text" />
    </resultMap>


and here is the statement:

<select id="Select.Fields.Fill" resultMap="Fields.Fill.ResultMap" parameterClass="string">
      SELECT
      f.*, pv.value_text
      FROM fields f
      LEFT JOIN possible_values pv ON f.id = pv.field_id
      <isParameterPresent>
        WHERE f.id = #value#
      </isParameterPresent>
    </select>

It actually groups the results correctly (2 inserted entries return 2 rows) but I get empty strings instead of the correct values.
Where did I go wrong, or is this is a bug?

Thanks in advance,
  Bruno Silva
-- 
Cool Advance - Information Systems
http://www.cooladvance.com/