map为空时调用keySet()传给jpa导致的bug

kyaa111 3年前 ⋅ 688 阅读

userService.deleteNotInId(userMap.keySet());

@Modifying
@Query(value = "DELETE FROM user WHERE id NOT IN (:iqs)", nativeQuery = true)
void deleteNotInId(@Param("ids") Iterable<String> iqs);

当userMap size为0时

预期jpa sql为DELETE FROM user WHERE iq NOT IN ('')

而实际sql为 DELETE FROM user WHERE iq NOT IN (null)

注意: 本文归作者所有, 未经作者允许, 不得转载. 若有谬误, 欢迎指出

#jpa

赏