인프런 커뮤니티 질문&답변

안녕하세요 강사님!

프로젝트 진행중에 이해가 되지 않은 점이 생겨 질문드립니다..!

@Test
    @DisplayName("유저가 반품, 취소한 상품들을 조회할 수 있다. ")
    public void findDistinctWithDetailsByMemberId() {
        // given
        Member member = Member.builder().build();

        Order order = Order.builder()
                .member(member)
                .orderNo("123")
                .build();

        Product product1 = Product.builder().build();
        Product product2 = Product.builder().build();
        Product product3 = Product.builder().build();

        OrderDetail orderDetail1 = OrderDetail.builder()
                .order(order)
                .product(product1)
                .statusCode(StatusCodeType.RETURN_COMPLETED.getCode())
                .build();
        OrderDetail orderDetail2 = OrderDetail.builder()
                .order(order)
                .product(product2)
                .statusCode(StatusCodeType.ORDER_CANCEL.getCode())
                .build();
        OrderDetail orderDetail3 = OrderDetail.builder()
                .order(order)
                .product(product3)
                .statusCode(StatusCodeType.DELIVERY_DELAY.getCode())
                .build();

        order.addOrderDetail(orderDetail1);
        order.addOrderDetail(orderDetail2);
        order.addOrderDetail(orderDetail3);

        productRepository.saveAll(List.of(product1, product2, product3));
        memberRepository.save(member);
        orderRepository.save(order);

        // when
        List<Order> orders = orderRepository.findDistinctWithDetailsByMemberId(member.getId());

        // then
        assertThat(orders).hasSize(1)
                .extracting("orderNo")
                .contains("123");

        List<OrderDetail> orderDetails = orders.get(0).getOrderDetails();
        assertThat(orderDetails).hasSize(2);

    }

@Override
    public List<Order> findDistinctWithDetailsByMemberId(Long memberId) {

        BooleanExpression statusCondition = orderDetail.statusCode.eq(ORDER_CANCEL.getCode());
        BooleanExpression orCondition = statusCondition.or(orderDetail.statusCode.eq(RETURN_COMPLETED.getCode()));

        return queryFactory
                .selectDistinct(order)
                .from(order)
                .join(order.orderDetails, orderDetail).fetchJoin()
                .where(
                        order.member.id.eq(memberId),
                        orCondition
                )
                .fetch();
    }

다음과 같이 테스트를 작성했습니다.

memberId와 ORDER_CANCEL,RETURN_COMPLETED 상태로 걸러서 최종적으로 원하는 orderDetail이 2개 나올 것으로 예상했습니다. 그러나 예상과 달리 3개의 orderDetail이 나왔습니다.

em.flush();
em.clear();

// when
        List<Order> orders = orderRepository.findDistinctWithDetailsByMemberId(member.getId());

when절 이전에 강제로 영속성 컨텍스트를 플러시하고 클리어 해주니 예상대로 orderDetail이 2개가 반환되었습니다.

영속성 컨텍스트에서 어떠한 문제가 있는 것 같은데 감도 안잡혀서 이렇게 질문 드립니다...ㅠㅠ 감사합니다.

아래는 JPA가 날린 쿼리입니다..!

select
        distinct o1_0.order_id,
        o1_0.address_id,
        o1_0.created_at,
        o1_0.deleted_at,
        o1_0.member_id,
        od1_0.order_id,
        od1_0.order_detail_id,
        od1_0.cancelled_at,
        od1_0.coupon_id,
        od1_0.created_at,
        od1_0.deleted_at,
        od1_0.delivered_date,
        od1_0.order_no,
        od1_0.payment_key,
        od1_0.price,
        od1_0.product_id,
        od1_0.quantity,
        od1_0.reason,
        od1_0.status_code,
        od1_0.updated_at,
        o1_0.order_name,
        o1_0.order_no,
        o1_0.real_price,
        o1_0.total_price,
        o1_0.total_used_coupon_price,
        o1_0.updated_at,
        o1_0.used_point 
    from
        orders o1_0 
    join
        order_detail od1_0 
            on o1_0.order_id=od1_0.order_id 
    where
        o1_0.member_id=? 
        and (
            od1_0.status_code=? 
            or od1_0.status_code=?
        )