Repair recently-introduced error in makeIndexable for LIKE:
Tom Lane <tgl@sss.pgh.pa.us>
Repair recently-introduced error in makeIndexable for LIKE: a non-leading % would be put into the >=/<= patterns. Also, repair longstanding confusion about whether %% means a literal %%. The SQL92 doesn't say any such thing, and textlike() knows that, but gram.y didn't.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/parser/gram.y | modified | +25 −12 |
| src/backend/utils/adt/like.c | modified | +4 −2 |