Fix Incorrect Partition Pruning with Nullable Partition Keys

Fix incorrect partition pruning when there is a nullable partition key. Note: most likely you don't use nullable partition keys - this is an obscure feature you should not use. Nullable keys are a nonsense and this feature is only needed for some crazy use-cases. This fixes #38941. #38946 (Amos Bird).