intermittent search failures

[Galen Charlton]

Catalog searches in 2.11 and later can fail intermittently, with the following PostgreSQL error:

ERROR: type of parameter 56 (double precision) does not match that when preparing the plan (numeric)
CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment

This looks like a variant of an issue that was found, and fixed, in bug 1549505. In particular, note the following comments:

https://bugs.launchpad.net/evergreen/+bug/1549505/comments/10
https://bugs.launchpad.net/evergreen/+bug/1549505/comments/18

Evergreen 2.11

[Galen Charlton (gmc)]

A patch is available at the tip of the user/gmcharlt/lp1651808_cast_rel_to_numeric branch in the working/Evergreen repository:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/gmcharlt/lp1651808_cast_rel_to_numeric

The bug may affect 2.10 in addition to 2.11, so I've targeted both.

[Mike Rylander (mrylander)]

This makes perfect sense, and works for me. Getting this into the code now so that this weeks cuts (if they happen) are happier.

[Mike Rylander (mrylander)]

And .... complete. Thanks, Galen!