Steps to reproduce the issue

Create a simple prepared statement with a parameter, which is used more than once, and bind it to a variable. The following code example doesn't make sense but shows the problem:

$db = \Joomla\CMS\Factory::getContainer()->get('DatabaseDriver');
$someValue = 2;
$query = $db->getQuery(true)
    ->select('*')
    ->from('#__action_logs')
    ->where('id < :someValue AND user_id < :someValue ;')
    ->bind(':someValue', $someValue);
$db->setQuery($query);
$db->execute();

Expected result

All occurences of the parameter (:someValue) should be replaced and the query should be executed successfully.

Actual result

Exception: The number of variables must match the number of parameters in the prepared statement

System information (as much as possible)

Joomla 4.4.9

Additional comments

The error occurs using Joomla 4.4.9 but seems to be fixed in Joomla 5.2.1. Of course, there is an easy workaround (using different placeholders) but it took me a while to understand the problem (my original Sql statement was more complicated), so I think its worth to fix it to save others from having the same problem.