Kbase P96746: Error (141) when using CONTAINS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Error (141) when using CONTAINS
** Index value is too long. (141)
CAUSE:
This is a known issue
FIX:
The length of the search-expression in the CONTAINS operator is the same as for multi-component indexes and is based on the following calculation:
(Sum of component sizes) + 2 * (number of components) LT 199
There no plans to increase this limit, but the following can be used as a workaround:
WHERE field CONTAINS SUBSTRING(string-expression,1,196)
BUT, it truncates the string-expression and it can lead into unpredictable results. Use with caution.