diff options
Diffstat (limited to 'src/backend/utils/adt/like_support.c')
| -rw-r--r-- | src/backend/utils/adt/like_support.c | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/src/backend/utils/adt/like_support.c b/src/backend/utils/adt/like_support.c index c8fec7863f4..77cc3781965 100644 --- a/src/backend/utils/adt/like_support.c +++ b/src/backend/utils/adt/like_support.c @@ -265,7 +265,7 @@ match_pattern_prefix(Node *leftop, * pattern-matching is not supported with nondeterministic collations. (We * could also error out here, but by doing it later we get more precise * error messages.) (It should be possible to support at least - * Pattern_Prefix_Exact, but no point as along as the actual + * Pattern_Prefix_Exact, but no point as long as the actual * pattern-matching implementations don't support it.) * * expr_coll is not set for a non-collation-aware data type such as bytea. @@ -357,13 +357,16 @@ match_pattern_prefix(Node *leftop, /* * If we found an exact-match pattern, generate an "=" indexqual. + * + * (Despite the checks above, we might fail to find a suitable operator in + * some cases with binary-compatible opclasses. Just punt if so.) */ if (pstatus == Pattern_Prefix_Exact) { oproid = get_opfamily_member(opfamily, ldatatype, rdatatype, BTEqualStrategyNumber); if (oproid == InvalidOid) - elog(ERROR, "no = operator for opfamily %u", opfamily); + return NIL; expr = make_opclause(oproid, BOOLOID, false, (Expr *) leftop, (Expr *) prefix, InvalidOid, indexcollation); @@ -379,7 +382,7 @@ match_pattern_prefix(Node *leftop, oproid = get_opfamily_member(opfamily, ldatatype, rdatatype, BTGreaterEqualStrategyNumber); if (oproid == InvalidOid) - elog(ERROR, "no >= operator for opfamily %u", opfamily); + return NIL; expr = make_opclause(oproid, BOOLOID, false, (Expr *) leftop, (Expr *) prefix, InvalidOid, indexcollation); @@ -396,7 +399,7 @@ match_pattern_prefix(Node *leftop, oproid = get_opfamily_member(opfamily, ldatatype, rdatatype, BTLessStrategyNumber); if (oproid == InvalidOid) - elog(ERROR, "no < operator for opfamily %u", opfamily); + return result; fmgr_info(get_opcode(oproid), <proc); greaterstr = make_greater_string(prefix, <proc, indexcollation); if (greaterstr) |