761300 - When searching comments with Advanced Search, strings with leading spaces cause SQL abort

Status: RESOLVED DUPLICATE of bug 760075

(Bugzilla :: Query/Bug List, defect)

Description

[Kent Rogers [:mrbball]]

If I do an Advanced Search and search using the criteria:

 Comment   ...   contains all of the strings   ...   " some_string"

I get an SQL syntax error:

Software error:

DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ...'

This appears to be a 4.2 regression.  It does not happen on BMO or
on landfill/4.0 but definitely happens on landfill/4.2.

A space is included in the buglist.cgi URL that is generated.
Here is the URL generated on landfill/4.2 by querying for a
comment that contains " some_string":

https://landfill.bugzilla.org/bugzilla-4.2-branch/buglist.cgi?list_id=51393&resolution=---&query_format=advanced&token=1338841597-933deca1885fa305058eb976e864cbb2&longdesc=%20some_string&longdesc_type=allwordssubstr