-
Type: Bug
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: 5.5.0-HF18, 5.6.0-HF19, 5.7.1, 5.8.0-HF01
-
Fix Version/s: QualifiedToSchedule
-
Component/s: Query & PageProvider
-
Tags:
This was rapported by some customers with around 50.000 documents in the DB.
After investigation, it happens since 5.5 due to changes from NXP-5689
Seems like the NX_TO_TSVECTOR function is called at each query whereas it should already be done in the index. Altering the FULLTEXT table columns to their previous type solves the problem because the code can handle both cases.
- depends on
-
NXP-5689 VCS: store PostgreSQL fulltext in clear text
- Resolved