Changes between Initial Version and Version 19 of Ticket #3254


Ignore:
Timestamp:
Jan 18, 2009, 2:55:07 PM (16 years ago)
Author:
Ramiro Morales
Comment:

(description)

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3254

    • Property Triage Stage Unreviewed → Accepted
    • Property Summary [patch] experimental fts support for postgres, oracle and mssql → [patch] experimental fulltext search support for postgres, oracle and mssql
    • Property Cc sam@… johann.queuniet@… hv@… rboumart@… dan.fairs@… twidi@… Matt Boersma added
    • Property Component Metasystem → Database wrapper
    • Property Patch needs improvement set
    • Property Needs documentation set
    • Property Needs tests set
    • Property Reporter changed from Ronny Pfannschmidt <ronny.pfannschmidt@…> to Ronny Pfannschmidt
    • Property Keywords oracle fulltext search added

  • Ticket #3254 – Description

    initial v19  
    11I didn't like it was missing.
    22
    3 oracle, mssql : add a FulltextIndex for the Fields
     3oracle, mssql : add a !FulltextIndex for the Fields
    44
    5 postgresql: for each FulltextField add a extra tsvector Field named like "%(fieldname)_tsv"
     5postgresql: for each !FulltextField add a extra tsvector Field named like `"%(fieldname)_tsv"`
    66
    77Problems with sqlite fts:
    8 * they stated a match statement may only be used once in a query
    9 * it needs a very specific syntax to search multiple fields
    10 * i have no idea how to get that into the ORM
     8
     9 * they stated a match statement may only be used once in a query
     10 * it needs a very specific syntax to search multiple fields
     11 * i have no idea how to get that into the ORM
Back to Top