0 rows 1 row 4 rows list() [] [Mechanical Keyboard] 4 items single() EmptyResult.. Mechanical Keyboard IncorrectResultSize.. optional() Optional.empty Optional[Mechanical Keyboard] IncorrectResultSize.. set() [] [Mechanical Keyboard] 4 items single() on 0 rows: org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0 single() on 4 rows: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 4 EmptyResultDataAccessException extends IncorrectResultSizeDataAccessException: true untyped singleValue() of COUNT(*): 5 (Long) untyped optionalValue() with no row: Optional.empty optional() over SELECT MAX(price) with no matching rows: Optional.empty single() over the same query: org.springframework.dao.TypeMismatchDataAccessException: Result value is null but no null value expected