[wp-trac] [WordPress Trac] #35361: Error in SQL syntax search page

[WordPress Trac]

#35361: Error in SQL syntax search page
-------------------------------------+--------------------
 Reporter:  salvoaranzulla           |       Owner:
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  4.4.2
Component:  Query                    |     Version:  4.4
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:
-------------------------------------+--------------------
Changes (by boonebgorges):

 * keywords:  dev-feedback => has-patch needs-testing
 * version:  4.4.1 => 4.4
 * milestone:  Awaiting Review => 4.4.2


Comment:

 @salvoaranzulla Thanks very much for the ticket, and welcome to WordPress
 Trac!

 I have confirmed the problem. As you note, it happens when the number of
 LIKE terms is greater than 6 *and* the search string contains at least one
 negated term. In your case (`LENOVO Lenovo TAB 2 A10 -70L ZA010058DE blu`)
 the negated term is `-70L`.

 [attachment:35361.diff] should solve the issue, using more or less the
 same logic as you've proposed. Could you verify on your installation?

 Negated search terms were introduced in 4.4, so I'm marking this for 4.4.2
 consideration.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/35361#comment:6>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform