MDL-69145 core: Set the default filterset join type to ALL