SQL是不是没有判断Operator_id为空的情况？执行该方法后UserAwardMapList中没有operator_id为NULL的UserAwardMap.

SQL：

<select id="queryUserAwardMapList" resultMap="userAwardResultMap">
   SELECT
   uam.user_award_id,
   uam.create_time,
   uam.used_status,
   uam.point,
   buyer.user_id,
   buyer.name,
   s.shop_id,
   s.shop_name,
   a.award_id,
   a.award_name,
   operator.user_id AS operator_id,
   operator.name AS operator_name
   FROM
   tb_user_award_map uam,
   tb_person_info buyer,
   tb_shop s,
   tb_award a,
   tb_person_info operator
   <where>
      uam.user_id = buyer.user_id
      AND
      uam.shop_id = s.shop_id
      AND
      uam.award_id = a.award_id
      AND
      uam.operator_id = operator.user_id
      <!--按顾客信息精确查询-->
      <if test="userAwardCondition.user!=null
                   and userAwardCondition.user.userId!=null">
         and uam.user_id = #{userAwardCondition.user.userId}
      </if>
      <!--按某个店铺精确查询-->
      <if test="userAwardCondition.shop!=null
               and userAwardCondition.shop.shopId!=null">
         and uam.shop_id = #{userAwardCondition.shop.shopId}
      </if>
      <!--按顾客名字模糊查询-->
      <if test="userAwardCondition.user!=null
               and userAwardCondition.user.name!=null">
         and buyer.name like '%${userAwardCondition.user.name}%'
      </if>
      <!--按奖品名模糊查询-->
      <if test="userAwardCondition.award!=null
               and userAwardCondition.award.awardName!=null">
         and a.award_name like '%${userAwardCondition.award.awardName}%'
      </if>
      <!--按奖品可用状态查询-->
      <if test="userAwardCondition.usedStatus!=null">
         and uam.used_status = #{userAwardCondition.usedStatus}
      </if>
   </where>
   ORDER BY uam.create_time desc
   LIMIT #{rowIndex},#{pageSize}
</select>

UserAwardMapDaoTest:

数据库中tb_user_award_map: