Comment 0 for bug 39828

Christian Robottom Reis wrote:
> https://chinstrap.ubuntu.com/~jamesh/oops.cgi/2006-04-15/A280
>
> SELECT DISTINCT DistroReleasePackageCache.id, DistroReleasePackageCache.descriptions, DistroReleasePackageCache.binarypackagename, DistroReleasePackageCache.name, DistroReleasePackageCache.summary, DistroReleasePackageCache.distrorelease, DistroReleasePackageCache.summaries, DistroReleasePackageCache.description, _prejoin0.id, _prejoin0.name, rank(fti, ftq('SB! live not working 5.10')) AS rank FROM DistroReleasePackageCache, BinaryPackageName AS _prejoin0 WHERE _prejoin0.id = DistroReleasePackageCache.binarypackagename AND
> distrorelease = 5 AND (
> fti @@ ftq('SB! live not working 5.10') OR
> DistroReleasePackageCache.name = 'SB! live not working 5.10')
> ORDER BY rank DESC
>
> Seen this before?

The Syntax Error is raised from tsearch2 when it gets a query string it
cannot compile - most likely triggered by the exclamation point in an
unexpected position.

 affects /products/launchpad
 assignee stub

--
Stuart Bishop <email address hidden> http://www.canonical.com/
Canonical Ltd. http://www.ubuntu.com/