On Wed, Jul 29, 2026 at 12:11 PM shihao zhong <[email protected]> wrote: > > Hi hackers, > > The ~ operator gets index conditions from a fixed pattern prefix, via > textregexeq_support(). regexp_like(), which is the same test, has no > support function and so misses out. > > With no flags the two are identical,
regexp_like_no_flags is the same as textregexeq, therefore let the textregexeq support function also used in regexp_like_no_flags is OK, i think. we already have coverage for textregexeq_support, https://coverage.postgresql.org/src/backend/utils/adt/like_support.c.gcov.html. I tend to think V1 regression tests are unnecessary, but that's a minor point. -- jian https://www.enterprisedb.com/
