model-writtenrun 9508 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Jeevan Chalke reported that LIKE on an indexed bytea column raised a collation-zero cache lookup error and proposed returning false for missing collations, with a regression test, in #1.
- Tom Lane explained that returning false would disable pattern-prefix optimization in #2; after Jeevan asked about invalid nonzero identifiers in #3, Tom clarified that those should still raise errors in #4.
- Jeevan revised the patch to treat only collation zero as deterministic while retaining the regression test in #5.
- Peter Eisentraut argued that relaxing the cache function could hide incorrect callers and supplied a replacement that skips the determinism check for non-collatable types in match_pattern_prefix(), leaving the cache function unchanged, in #6.
- Jeevan expressed agreement in #7, and Peter committed #6 as abb9c63b2c with added text and bytea regression tests in the strings suite; his confirmation in #8 closed the thread with the fix landed.