Steps to reproduce the issue

When we set the error_reporting to highest and when we are processing multiple queries at same time, like consider using an Iterator and while processing those items which we fetch through iterator, if we make any other query on getDbo of JFactory, our iteration ends because query gets overridden.

$db       = Factory::getDbo();
$query    = $db->getQuery(true);
$iterator = $db->setQuery($query)->getIterator();

foreach ($iterator as $o)
{
   // This is just an example. If we have some another query while processing it causes loop to terminate. 
   $query2  = $db->getQuery(true);
   $db->setQuery($query2)->execute();
}

Expected result

Independent queries should be executed independently without interfering with each other in development mode as well.

Actual result

I can't iterate all the records due to this behavior in development mode, it only executes loop only once.

System information (as much as possible)

Linux
PHP 7.2
MySQL 8
Joomla 3.10.10

Additional comments

It also throws this errors

Warning: mysqli_fetch_object(): Couldn't fetch mysqli_result in C:\xampp\htdocs\staging\libraries\joomla\database\iterator\mysqli.php on line 41

Warning: mysqli_free_result(): Couldn't fetch mysqli_result in C:\xampp\htdocs\staging\libraries\joomla\database\iterator\mysqli.php on line 53