[wp-trac] [WordPress Trac] #56802: Query: Post IDs cached for search and other 'LIKE' queries are unreachable

[WordPress Trac]

#56802: Query: Post IDs cached for search and other 'LIKE' queries are unreachable
-------------------------------------------------+-------------------------
 Reporter:  dlh                                  |       Owner:
                                                 |  spacedmonkey
     Type:  defect (bug)                         |      Status:  closed
 Priority:  normal                               |   Milestone:  6.1
Component:  Query                                |     Version:  trunk
 Severity:  normal                               |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:
  testing commit dev-reviewed                    |  performance
-------------------------------------------------+-------------------------
Changes (by spacedmonkey):

 * owner:  (none) => spacedmonkey
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"54634" 54634]:
 {{{
 #!CommitTicketReference repository="" revision="54634"
 Query: Remove placeholder from query cache key.

 Remove escape placeholder from query cache key, as placeholders are a
 based on a unique id on every request. This means that it is impossible
 for a cache to be reused, making queries that use escape placeholders such
 as `LIKE` searches, unable to be cached.

 Props dhl, spacedmonkey, peterwilsoncc, desrosj, chaion07, davidbaumwald,
 mukesh27.
 Fixes #56802.
 }}}

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