[wp-trac] [WordPress Trac] #64250: Refactor redirect_guess_404_permalink to use WP_Query instead of raw SQL

[WordPress Trac]

#64250: Refactor redirect_guess_404_permalink to use WP_Query instead of raw SQL
-------------------------------------------------+-------------------------
 Reporter:  spacedmonkey                         |       Owner:
                                                 |  spacedmonkey
     Type:  enhancement                          |      Status:  reviewing
 Priority:  normal                               |   Milestone:  7.0
Component:  Permalinks                           |     Version:  2.3
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch commit has-unit-tests      |     Focuses:
  needs-dev-note changes-requested               |  performance
-------------------------------------------------+-------------------------

Comment (by peterwilsoncc):

 @spacedmonkey You're right, none isn't a good word but I figured you'd get
 the idea. Of the three options you present, I like the third best with the
 first as a very close second.

 My preference remains for the generic rather than the current code's
 version as it would be a little frustrating to end up with `exact`,
 `starts_with` and `ends_with`.

 Re: ES drop-ins, I think a little outreach would need to be made to ensure
 that changes work as expected. As the addition of the slug to the
 searchable fields and the position (whether the changes I've proposed or
 those in the existing PR) would either bypass the `s` trigger for elastic
 search or trigger the wrong result set.

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