Ever since I started using FTS extensively, I frequently ran into this
limitation:
** TODO: Strangely, it is not possible to associate a column specifier
** with a quoted phrase, only with a single token. Not sure if this was
** an implementation artifact or an intentional decision when
2011/11/14 nobre rafael.ro...@novaprolink.com.br
Comment from the source:
** TODO: Strangely, it is not possible to associate a column specifier
** with a quoted phrase, only with a single token. Not sure if this was
** an implementation artifact or an intentional decision when fts3 was
Comment from the source:
** TODO: Strangely, it is not possible to associate a column specifier
** with a quoted phrase, only with a single token. Not sure if this was
** an implementation artifact or an intentional decision when fts3 was
** first implemented. Whichever it was, this
When I have a basic FTS query that needs to be restricted to a column, I
can write it in two ways:
1.) WHERE column MATCH 'apple'
2.) WHERE table MATCH 'column:apple'
But when I have a phrase query, I can only write it in one way:
1.) WHERE column MATCH 'apple juice'
The problem is that when I
