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

[WordPress Trac]

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

 * owner:   => boonebgorges
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"36251"]:
 {{{
 #!CommitTicketReference repository="" revision="36251"
 Avoid invalid SQL when building ORDER BY clause using long search strings.

 The introduction of negative search terms in 4.4 [34934] introduced the
 possibility that the ORDER BY clause of a search query could be assembled
 in
 such a way as to create invalid syntax. The current changeset fixes this
 by
 ensuring that the ORDER BY clause corresponding to the search terms is
 excluded when it would otherwise be empty.

 Props salvoaranzulla.
 Fixes #35361.
 }}}

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