updating hibernate ScrollableResult or Spring Data JPA Slice when updated column is in query halves number of rows processed
I’ve come across some curious but consistent behaviour when processing large batches of results using either Spring JPA Slice or Hibernates ScrollableResult where an update is made on a column that is also part of the where clause. Issue is only half of the valid results are processed. Each time it is rerun it reduces by half.