[rt-users] RT 4.2.9 Simple Search, Subject LIKE instead of Id =

[Vladimir Nikolic]

Hello,

after upgrade to 4.2.9 (from 4.2.2), we noticed that Simple Search by 
Ticket id doesn't work.
If I enter 783509 in Search box, Edit Search shows sql query:

( Subject LIKE 783502 ) AND (  Status = 'new' OR Status = 'open' OR 
Status = 'resolved' OR Status = 'stalled' OR Status = 'rejected' OR 
Status = 'deleted' )

/usr/local/lib/perl5/site_perl/RT/Search/Simple.pm has lines:

     # Assume that numbers were actually "default"s if we have other limits
     if ($limits->{id} and keys %{$limits} > 1) {
         my $values = delete $limits->{id};
         for my $value (@{$values}) {
             $value =~ /(\d+)/ or next;
             my ($key, @tsql) = $self->HandleDefault($1);
             push @{$limits->{$key}}, @tsql;
         }
     }

which rewrites 'Id =' to 'Subject LIKE'.

sub HandleDefault   {
     my $fts = RT->Config->Get('FullTextSearch');
     if ($fts->{Enable} and $fts->{Indexed}) {
         return default => "(Subject LIKE '$_[1]' OR Content LIKE '$_[1]')";
     } else {
         return default => "Subject LIKE '$_[1]'";
     }
}

Regards,
Vladimir