[
https://jira.nuxeo.com/browse/NXP-8221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Olivier Grisel updated NXP-8221:
--------------------------------
Upgrade notes:
On PostgreSQL the following SQL query updates the "fulltext_title" from the
current value of the "dublincore:title" field and fixes the issue.
UPDATE fulltext SET simpletext_title = NX_TO_TSVECTOR("dublincore"."title")
FROM dublincore WHERE "fulltext"."simpletext_title" IS NULL AND "fulltext"."id"
= "dublincore"."id";
was:
On PostgreSQL the following SQL query updates the "fulltext_title" from the
current value of the "dublincore:title" field and fixes the issue.
UPDATE fulltext SET simpletext_title = NX_TO_TSVECTOR("dublincore"."title")
FROM dublincore WHERE "fulltext"."id" = "dublincore"."id";
I have updated the migration wiki page to document this step.
http://doc.nuxeo.com/display/KB/Upgrade+from+5.4.2+to+5.5#Upgradefrom5.4.2to5.5-Partiallymissingfulltextindexforthetitlefield
If someone knows the matching query for the other supported DBs please add it
there.
> Documents created in old versions of Nuxeo DM cannot be found when doing a
> fulltext search on the title field only
> ------------------------------------------------------------------------------------------------------------------
>
> Key: NXP-8221
> URL: https://jira.nuxeo.com/browse/NXP-8221
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.5
> Reporter: Olivier Grisel
> Assignee: Olivier Grisel
> Priority: Major
> Fix For: 5.6
>
>
> Documents created before the configuration of the ecm:fulltext_title index in
> the postgresql repository configuration file are not completely indexed hence
> not suggested by the new searchbox0 suggestion feature introduced in 5.5 nor
> through the advanced search form (when using the "Title" search field).
> We could probably write a SQL migration script for such simple cases
> involving only simple text fields.
> However such migration script would not work for other more complex indices
> involving binaries or complex properties. For such hypothetical cases a batch
> re-indexing operation would probably be required at the core repository level.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
