v.25.8Bug Fix (user-visible misbehavior in an official stable release)
Fix incorrect result of queries with WHERE
Official CH changelog text
Fixed incorrect result of queries with WHERE ... IN (<subquery>) clause and enabled query condition cache (setting use_query_condition_cache). #83445 (LB7666).