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)
注意: 本文归作者所有, 未经作者允许, 不得转载. 若有谬误, 欢迎指出