쿼리문 작성할때 주의할점.

<select id="getDormentLoginList" resultType="LoginHistory">
/* 자동으로 휴면처리될 회원 조회*/
SELECT
max(member_id) as memberId
FROM
login_history as l

WHERE
DATEDIFF(NOW(),login_date)>90
GROUP by member_id
union
SELECT
m.member_id as memberId
FROM
member_info as m
left join
login_history as l
on m.member_id = l.member_id
WHERE
DATEDIFF(now(), member_reg_date )> 90
and m.member_status = "normal";

</select>

 

<select id="getAddrAmountList" resultType="int">
/* 회원별 배송지 숫자 조회 */
select
count(1)
from
addr_manage
where
member_id = #{memberId};
</select>

 

이 두쿼리문처럼 count라던가 max라던가 쓸경우엔는 resultMap이 안먹힌다

 

dbeaver에서라든가 쿼리문을 실행했을때는 되지만 스프링에서 실행했을경우에는 작동을 안한다

 

주의할것