v.24.4Improvement
Join table engine with ANY strictness now prioritizes first inserted row after reload
Jointable engine with strictnessANYis consistent after reload. When several rows with the same key are inserted, the first one will have higher priority (before, it was chosen randomly upon table loading). close #51027. #61972 (vdimir).
Why it matters
Previously, when multiple rows with the same key existed in aJoin table with ANY strictness, the selected row was chosen randomly after the table was reloaded. This change ensures deterministic and stable behavior, improving reliability and predictability of query results involving such joins.How to use it
Use theJoin table engine with strictness set to ANY as usual. After insertion of multiple rows with the same key, the engine will now consistently prioritize the first inserted row upon reload without requiring any configuration changes.