Fix Data Compression Issues and Retain LowCardinality Type in Join Algorithms

Fixes Data compressed with different methods in join_algorithm='auto'. Keep LowCardinality as type for left table join key in join_algorithm='partial_merge'. #15088 (Artem Zuikov).