Was getting some missing values on FETCH test - I think the cause is a difference of opinion on how the partition hash is interprted.
Generated code when creating the index has:
but calculation of partition for picking the index has:
I think this means that the distribution will truncate the hash to 32-bits before doing the modulus, but the getPartition will do the modulus at 64-bits. They may therefore give different answers