v.24.4Performance Improvement
Fix Primary Index Usage in Boolean Expressions with Redundant Conditions
Fix an issue where when a redundant= 1or= 0is added after a boolean expression involving the primary key, the primary index is not used. For example, bothSELECT * FROM <table> WHERE <primary-key> IN (<value>) = 1andSELECT * FROM <table> WHERE <primary-key> NOT IN (<value>) = 0will both perform a full table scan, when the primary index can be used. #62142 (josh-hildred).