[ 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"."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"."simpletext_title" IS NULL AND "fulltext"."id" = "dublincore"."id"; > 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 ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets