pgsql: Fix planner's test for case-foldable characters in ILIKE with IC

2019-08-12 Thread Tom Lane
Fix planner's test for case-foldable characters in ILIKE with ICU. As coded, the ICU-collation path in pattern_char_isalpha() failed to consider regular ASCII letters to be case-varying. This led to like_fixed_prefix treating too much of an ILIKE pattern as being a fixed prefix, so that indexscan

pgsql: Fix planner's test for case-foldable characters in ILIKE with IC

2019-08-12 Thread Tom Lane
Fix planner's test for case-foldable characters in ILIKE with ICU. As coded, the ICU-collation path in pattern_char_isalpha() failed to consider regular ASCII letters to be case-varying. This led to like_fixed_prefix treating too much of an ILIKE pattern as being a fixed prefix, so that indexscan

pgsql: Fix planner's test for case-foldable characters in ILIKE with IC

2019-08-12 Thread Tom Lane
Fix planner's test for case-foldable characters in ILIKE with ICU. As coded, the ICU-collation path in pattern_char_isalpha() failed to consider regular ASCII letters to be case-varying. This led to like_fixed_prefix treating too much of an ILIKE pattern as being a fixed prefix, so that indexscan

pgsql: Fix planner's test for case-foldable characters in ILIKE with IC

2019-08-12 Thread Tom Lane
Fix planner's test for case-foldable characters in ILIKE with ICU. As coded, the ICU-collation path in pattern_char_isalpha() failed to consider regular ASCII letters to be case-varying. This led to like_fixed_prefix treating too much of an ILIKE pattern as being a fixed prefix, so that indexscan