Re: [COMMITTERS] 'pgsql/src/backend/parser gram.y'

> Update of /usr/local/cvsroot/pgsql/src/backend/parser
> In directory hub.org:/tmp/cvs-serv80148/parser
>
> Modified Files:
> gram.y
> Log Message:
> 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.
>
>

Houston, we have a problem. DoMatch has:

case '%':
/* %% is the same as % according to the SQL standard */
/* Advance past all %'s */
while (*p == '%')

Don't we want %% to be %?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026