Multithread update does not update all records - version 9.4.1.0

[kowgli]

Hi,

I'm facing an issue in the latest version (9.4.1.0) when bulk updating records.

Sample query:

update account
set name = 'test'
where name is null

When having auto (0) in the worker threads only a subset of the records get updated. When I set the worker thread count to 1 all records get updated.

[MarkMpn]

This should be resolved as part of the multithreading updates in v9.5, can you please try updating and let me know if this still occurs?

[kowgli]

@MarkMpn
Unfortunately it's still not 100% working. A sample is a query like above and a set of lets say 10000 records. I run it. it says 10000 needs to be updated. It finishes. I run it again. Now it says (for example) 20 records need to be updated. it should be 0.