Kbase P119074: Error 42 when using multiple INDEX RINDEX or MATCHES criteria in query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
bfx: Field too large for a data item. Try to increase -s. (42)
Specifying multiple INDEX, RINDEX or MATCHES criteria in query using AND, OR
FOR EACH table WHERE
INDEX(field, "data")>0
AND INDEX(field, "data2")>0
AND INDEX(field, "data3")>0 ...
Large field data in selected records
CAUSE:
Bug# 20060925-016
CAUSE:
When an expression using "INDEX(some-large-field, xxx) OR INDEX(large-field, yyy) OR ..." is used, the stack space is not freed until the entire expression has been calculated. When using large fields, this can cause the client to run out of stack space.
FIX:
Upgrade to OpenEdge 10.1B or later.
As a workaround, either increase the -s startup parameter, or use a word index and the CONTAINS function.