[wp-trac] [WordPress Trac] #56991: Update to get_page_by_title in 6.1 changes WHERE clause

[WordPress Trac]

#56991: Update to get_page_by_title in 6.1 changes WHERE clause
--------------------------+---------------------
 Reporter:  Bjorn2404     |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  6.1.1
Component:  General       |     Version:  6.1
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:
--------------------------+---------------------

Comment (by dilipbheda):

 When I changed the post status to "any," the mentioned problem seemed to
 be resolved.

 `'post_status' => 'any',`

 SQL Query:


 {{{
 SELECT
   wp_posts.ID
 FROM
   wp_posts
 WHERE
   1 = 1
   AND wp_posts.post_title = 'Test'
   AND wp_posts.post_type = 'page'
   AND (
     (
       wp_posts.post_status <> 'trash'
       AND wp_posts.post_status <> 'auto-draft'
     )
   )
 ORDER BY
   wp_posts.post_date ASC,
   wp_posts.ID ASC
 LIMIT
   0, 1
 }}}

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