[BugFix] Do not apply cardinality-preserving join pruning if there is no prunable joins (backport #50197)

[BugFix] Do not apply cardinality-preserving join pruning if there is no prunable joins (backport #50197) #6551