[wp-trac] [WordPress Trac] #64390: get_adjacent_post() SQL changes can loop infinitely in Storefront/derivative theme code

[WordPress Trac]

#64390: get_adjacent_post() SQL changes can loop infinitely in
Storefront/derivative theme code
-----------------------------------------+---------------------------------
 Reporter:  jmdodd                       |       Owner:  peterwilsoncc
     Type:  defect (bug)                 |      Status:  reviewing
 Priority:  normal                       |   Milestone:  6.9.1
Component:  Posts, Post Types            |     Version:  6.9
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch changes-requested  |     Focuses:  template,
                                         |  performance
-----------------------------------------+---------------------------------

Comment (by jmdodd):

 This issue was detected on ~220 sites out of ~450,000 sites so ~0.05%
 (less than a tenth of a percent). It is observable only when a post is
 requested that has the same timestamp as an adjacent post, and so far has
 only been seen for product pages for Storefront-derivative themes with a
 lack of looping protection -- that overlap seems to be fairly sparse.

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