diff options
author | Ivan Kohler <ivan@freeside.biz> | 2012-04-24 11:35:56 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2012-04-24 11:35:56 -0700 |
commit | 6587f6ba7d047ddc1686c080090afe7d53365bd4 (patch) | |
tree | ec77342668e8865aca669c9b4736e84e3077b523 /rt/t/fts/not_indexed.t | |
parent | 47153aae5c2fc00316654e7277fccd45f72ff611 (diff) |
first pass RT4 merge, RT#13852
Diffstat (limited to 'rt/t/fts/not_indexed.t')
-rw-r--r-- | rt/t/fts/not_indexed.t | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/rt/t/fts/not_indexed.t b/rt/t/fts/not_indexed.t new file mode 100644 index 000000000..0a1abd081 --- /dev/null +++ b/rt/t/fts/not_indexed.t @@ -0,0 +1,61 @@ +#!/usr/bin/perl -w + +use strict; +use warnings; + +use RT::Test tests => 20; + +RT->Config->Set( FullTextSearch => Enable => 1, Indexed => 0 ); + +my $q = RT::Test->load_or_create_queue( Name => 'General' ); +ok $q && $q->id, 'loaded or created queue'; +my $queue = $q->Name; + +sub run_tests { + my @test = @_; + while ( my ($query, $checks) = splice @test, 0, 2 ) { + run_test( $query, %$checks ); + } +} + +my @tickets; +sub run_test { + my ($query, %checks) = @_; + my $query_prefix = join ' OR ', map 'id = '. $_->id, @tickets; + + my $tix = RT::Tickets->new(RT->SystemUser); + $tix->FromSQL( "( $query_prefix ) AND ( $query )" ); + + my $error = 0; + + my $count = 0; + $count++ foreach grep $_, values %checks; + is($tix->Count, $count, "found correct number of ticket(s) by '$query'") or $error = 1; + + my $good_tickets = ($tix->Count == $count); + while ( my $ticket = $tix->Next ) { + next if $checks{ $ticket->Subject }; + diag $ticket->Subject ." ticket has been found when it's not expected"; + $good_tickets = 0; + } + ok( $good_tickets, "all tickets are good with '$query'" ) or $error = 1; + + diag "Wrong SQL query for '$query':". $tix->BuildSelectQuery if $error; +} + +@tickets = RT::Test->create_tickets( + { Queue => $q->id }, + { Subject => 'book', Content => 'book' }, + { Subject => 'bar', Content => 'bar' }, + { Subject => 'no content', Content => undef }, +); + +run_tests( + "Content LIKE 'book'" => { book => 1, bar => 0 }, + "Content LIKE 'bar'" => { book => 0, bar => 1 }, + "(Content LIKE 'baz' OR Subject LIKE 'con')" => { 'no content' => 1 }, + "(Content LIKE 'bar' OR Subject LIKE 'con')" => { 'no content' => 1, bar => 1 }, + "(Content LIKE 'bar' OR Subject LIKE 'missing')" => { bar => 1 }, +); + + |