post_exists creates SQL-error

[yetAnotherDaniel]

Function post_exists is missing a space:

<?php
'AND post_content = %s' // wrong
' AND post_content = %s' // correct

Therefore, it produces an SQL error under the following circumstances:

Create a post with empty title and content '123'.

Run at admin:

<?php
add_action( 'admin_init', function() {
        echo post_exists( '', '123' ); exit;
});

Produces:
'...You have an error in your SQL syntax...'

I attached a proposal.

[yetAnotherDaniel]

new post_exists function

[johnbillion]

Introduced in [10722].

[johnbillion]

Thanks for the report @yetAnotherDaniel! This is indeed a valid bug. I've attached a patch and a unit test. We'll get this fixed in 4.5.

[SergeyBiryukov]

In 36113:

Import: Add a missing space to post_exists().

The lack of space resulted in SQL error when searching for posts by content.

Props yetAnotherDaniel, johnbillion.
Fixes #35246.