Kbase P57780: Query with 'CONTAINS' hangs client if executed in a client/s
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/18/2003 |
|
Status: Unverified
SYMPTOM(s):
Query with 'CONTAINS' hangs client if executed in a client/server environment.
Same query runs fine if executed in a self service client environment.
The Query has a complex CONTAINS compound expression that includes OR conditions.
CAUSE:
Bug number 20031010-035 has been logged for this issue. The fix is scheduled to be included in 9.1D08 service pack.
FIX:
A work around is to rewrite the CONTAINS expression. For example rewriting the query:
OPEN QUERY myQuery FOR EACH myTable WHERE
Fld1 = "00003979" AND
Fld2 CONTAINS 'DE@Support TY@Agility L1@Inventory (SO@SDB|SO@INT)(Price|Break)'
NO-LOCK.
AS
OPEN QUERY myQuery FOR EACH myTable WHERE
Fld1 = "00003979" AND
Fld2 CONTAINS 'DE@Support TY@Agility L1@Inventory SO@SDB Price' OR
Fld2 CONTAINS 'DE@Support TY@Agility L1@Inventory SO@SDB Break' OR
Fld2 CONTAINS 'DE@Support TY@Agility L1@Inventory SO@INT Price' OR
Fld2 CONTAINS 'DE@Support TY@Agility L1@Inventory SO@INT Break'
NO-LOCK.
avoids the problem and improves the performance.