[JIRA] Updated: (NXP-5450) VCS: add support for phrase matching in fulltext search
[
https://jira.nuxeo.com/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
---
Description:
This feature will only be available for databases which supports phrase
matching.
For PostgreSQL, see NXP-6720.
was:
This feature will only be available for databases which supports phrase
matching.
For PostgreSQL, where this feature is not supported natively, we will match the
phrase "foo bar" using:
to_tsquery('foo & bar') @@ to_tsvector(fulltext) AND fulltext LIKE '% foo bar
%'
This means that the fulltext column will have to be in clear text,
pre-canonicalized (lowercase, no diacritics), and with an initial and trailing
space.
> VCS: add support for phrase matching in fulltext search
> ---
>
> Key: NXP-5450
> URL: https://jira.nuxeo.com/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: New Feature
> Components: Core SQL Storage, Search / Query
>Reporter: Thierry Martins
>Assignee: Florent Guillaume
>Priority: Major
> Fix For: 5.4.2
>
>
> This feature will only be available for databases which supports phrase
> matching.
> For PostgreSQL, see NXP-6720.
--
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
[JIRA] Updated: (NXP-5450) VCS: add support for phrase matching in fulltext search
[
https://jira.nuxeo.com/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
---
Comment: was deleted
(was: Note that a more complex match like
abc "foo bar" -"gee man"
will have to be turned into something like:
to_tsquery('abc & foo & bar') @@ to_tsvector(fulltext)
AND (fulltext LIKE '% foo bar %' AND NOT fulltext LIKE '% gee man %')
i.e., the initial fulltext match has to match a superset of the complete query,
so it cannot easily contain excluded phrases.
)
> VCS: add support for phrase matching in fulltext search
> ---
>
> Key: NXP-5450
> URL: https://jira.nuxeo.com/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: New Feature
> Components: Core SQL Storage, Search / Query
>Reporter: Thierry Martins
>Assignee: Florent Guillaume
>Priority: Major
> Fix For: 5.4.2
>
>
> This feature will only be available for databases which supports phrase
> matching.
> For PostgreSQL, see NXP-6720.
--
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
[JIRA] Updated: (NXP-5450) VCS: add support for phrase matching in fulltext search
[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
---
Status: Open (was: Triage)
> VCS: add support for phrase matching in fulltext search
> ---
>
> Key: NXP-5450
> URL: https://jira.nuxeo.org/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: New Feature
> Components: Core SQL Storage, Search / Query
>Reporter: Thierry Martins
>Assignee: Florent Guillaume
>Priority: Major
> Fix For: 5.4
>
>
> This feature will only be available for databases which supports phrase
> matching.
> For PostgreSQL, where this feature is not supported natively, we will match
> the phrase "foo bar" using:
> to_tsquery('foo & bar') @@ to_tsvector(fulltext) AND fulltext LIKE '% foo
> bar %'
> This means that the fulltext column will have to be in clear text,
> pre-canonicalized (lowercase, no diacritics), and with an initial and
> trailing space.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
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
[JIRA] Updated: (NXP-5450) VCS: add support for phrase matching in fulltext search
[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
---
Component/s: Search / Query
> VCS: add support for phrase matching in fulltext search
> ---
>
> Key: NXP-5450
> URL: https://jira.nuxeo.org/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: New Feature
> Components: Core SQL Storage, Search / Query
>Reporter: Thierry Martins
>Assignee: Florent Guillaume
>Priority: Major
> Fix For: 5.4
>
>
> This feature will only be available for databases which supports phrase
> matching.
> For PostgreSQL, where this feature is not supported natively, we will match
> the phrase "foo bar" using:
> to_tsquery('foo & bar') @@ to_tsvector(fulltext) AND fulltext LIKE '% foo
> bar %'
> This means that the fulltext column will have to be in clear text,
> pre-canonicalized (lowercase, no diacritics), and with an initial and
> trailing space.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
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
[JIRA] Updated: (NXP-5450) VCS: add support for phrase matching in fulltext search
[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
---
Summary: VCS: add support for phrase matching in fulltext search (was: Add
support for phrase matching in fulltext search)
> VCS: add support for phrase matching in fulltext search
> ---
>
> Key: NXP-5450
> URL: https://jira.nuxeo.org/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Core SQL Storage
>Reporter: Thierry Martins
>Assignee: Florent Guillaume
>Priority: Major
> Fix For: 5.4
>
>
> This feature will only be available for databases which supports phrase
> matching.
> For PostgreSQL, where this feature is not supported natively, we will match
> the phrase "foo bar" using:
> to_tsquery('foo & bar') @@ to_tsvector(fulltext) AND fulltext LIKE '% foo
> bar %'
> This means that the fulltext column will have to be in clear text,
> pre-canonicalized (lowercase, no diacritics), and with an initial and
> trailing space.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
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
[JIRA] Updated: (NXP-5450) VCS: add support for phrase matching in fulltext search
[
https://jira.nuxeo.org/browse/NXP-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5450:
---
Issue Type: New Feature (was: Improvement)
> VCS: add support for phrase matching in fulltext search
> ---
>
> Key: NXP-5450
> URL: https://jira.nuxeo.org/browse/NXP-5450
> Project: Nuxeo Enterprise Platform
> Issue Type: New Feature
> Components: Core SQL Storage
>Reporter: Thierry Martins
>Assignee: Florent Guillaume
>Priority: Major
> Fix For: 5.4
>
>
> This feature will only be available for databases which supports phrase
> matching.
> For PostgreSQL, where this feature is not supported natively, we will match
> the phrase "foo bar" using:
> to_tsquery('foo & bar') @@ to_tsvector(fulltext) AND fulltext LIKE '% foo
> bar %'
> This means that the fulltext column will have to be in clear text,
> pre-canonicalized (lowercase, no diacritics), and with an initial and
> trailing space.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
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
