Closed zuminzi closed 1 year ago
DB에 존재하지 않으나 DB에 존재하는 데이터와 주소값이 동일하여, 본래 반환되지 말아야 할 데이터(인생네컷 청주 충북대 중문점)가 인생네컷 청주 충북대점(id: 18731)으로 반환되고 있었습니다.
인생네컷 청주 충북대 중문점
인생네컷 청주 충북대점
18731
Hibernate: select shop0_.id as id1_6_, shop0_.create_date as create_d2_6_, shop0_.modify_date as modify_d3_6_, shop0_.address as address4_6_, shop0_.brand_id as brand_id9_6_, shop0_.favorite_cnt as favorite5_6_, shop0_.place_name as place_na6_6_, shop0_.review_cnt as review_c7_6_, shop0_.star_rating_avg as star_rat8_6_ from shop shop0_ where REPLACE(shop0_.place_name,' ','')=? or REPLACE(shop0_.address,' ','') like ? TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [인생네컷청주충북대점] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [%충북청주시서원구1순환로704번길78%] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([id1_6_] : [BIGINT]) - [18731] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([create_d2_6_] : [TIMESTAMP]) - [2023-05-01T22:29:23.684209] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([modify_d3_6_] : TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([address4_6_] : [VARCHAR]) - [충북 청주시 서원구 1순환로704번길 78] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([brand_id9_6_] : [BIGINT]) - [1] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([favorite5_6_] : [INTEGER]) - [0] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([place_na6_6_] : [VARCHAR]) - [인생네컷 청주 충북대점] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([review_c7_6_] : [INTEGER]) - [1] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([star_rat8_6_] : [DOUBLE]) - [5.0] INFO 1 --- [nio-8080-exec-7] c.i.f.domain.shop.service.ShopService : Matched: DB shop (인생네컷 청주 충북대점 - 충북 청주시 서원구 1순환로704번길 78), Kakao API shop (인생네컷 청주충북대점 - 충북 청주시 서원구 1순환로704번길 78 - 충북 청주시 서원구 사창동 413-1) Hibernate: select shop0_.id as id1_6_, shop0_.create_date as create_d2_6_, shop0_.modify_date as modify_d3_6_, shop0_.address as address4_6_, shop0_.brand_id as brand_id9_6_, shop0_.favorite_cnt as favorite5_6_, shop0_.place_name as place_na6_6_, shop0_.review_cnt as review_c7_6_, shop0_.star_rating_avg as star_rat8_6_ from shop shop0_ where REPLACE(shop0_.place_name,' ','')=? or REPLACE(shop0_.address,' ','') like ? TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [인생네컷청주충북대중문점] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [%충북청주시서원구1순환로704번길78%] TRACE 1 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicExtractor : extracted value ([id1_6_] : [BIGINT]) - [18731] INFO 1 --- [nio-8080-exec-7] c.i.f.domain.shop.service.ShopService : Matched: DB shop (인생네컷 청주 충북대점 - 충북 청주시 서원구 1순환로704번길 78), Kakao API shop (인생네컷 청주충북대중문점 - 충북 청주시 서원구 1순환로704번길 78 - 충북 청주시 서원구 사창동 413-1) ..
문제 및 해결 방안
문제 상세
DB에 존재하지 않으나 DB에 존재하는 데이터와 주소값이 동일하여, 본래 반환되지 말아야 할 데이터(
인생네컷 청주 충북대 중문점
)가인생네컷 청주 충북대점
(id:18731
)으로 반환되고 있었습니다.작업 상세 내용