[rt-users] 'content matches' and 'content doesn't match' give same results

[Alex Peters]

Values need to be quoted, I believe.  Compare these two queries:

Content LIKE foo.com
Content LIKE 'foo.com'

I wonder whether wildcards might be necessary, like they seem to be in
regular SQL:

Content LIKE '%foo.com%'
On 09/08/2014 12:36 am, "Jeff Blaine" <jblaine at kickflop.net> wrote:

> Setup: RT 4.2.5 with PostgreSQL and full-text indexing enabled
> and completed for all tickets. Tickets 1, 2, and 3 all have
> contents with the string foo.com
>
> Searching for 'content LIKE foo.com' returns tickets 1, 2, 3
>
> Searching for 'content NOT LIKE foo.com' returns tickets 1, 2, 3
>
> Has anyone seen this? Any ideas what might be going wrong or how
> do start debugging this?
>
> --
> Jeff Blaine
> kickflop.net
> PGP/GnuPG Key ID: 0x0C8EDD02
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140809/83810a9c/attachment.htm>