Re: BUG #5816: index not used in function

"frank" <frank@ros-i.com> wrote:

> WHERE upper("thisColumn") like $1

The function's plan is kept from one execution to another, and it
can't know what will be in the first parameter -- perhaps '%X%'?  If
you build up the statement in a string and EXECUTE it, you might get
the desired behavior.

Anyway, next time you have an issue like this, please post to the
performance list; this is not a bug.

-Kevin