[BUG]: Column '0' is not part of the column map. After iterating for the second time in a Resultset

[JoaoSetas]

We have a problem in our project since the upgrade from phalcon 3.4.5 to the latest version 5.4.0.
When using the \Phalcon\Mvc\Model\Query\Builder in any of our models we have the same issue after iterating the second time over the ResultSet we get the error Column '0' is not part of the column map when doing toArray() in that result set.

To Reproduce

Code example of bug:

$result = $models_manager
    ->createBuilder()
    ->addFrom(Products::class, 'p')
    ->limit(10)
    ->getQuery()
    ->execute();

foreach ($result as $value) {}
foreach ($result as $value) {}

$result->toArray();  // Error here - `Column '0' is not part of the column map` 

We can also reproduce the error like this.

$result = $models_manager
    ->createBuilder()
    ->addFrom(Products::class, 'p')
    ->limit(10)
    ->getQuery()
    ->execute();

$result->rewind();
$result->next();
dump($result);
$result->rewind();
dump($result); exit;

We notice that in the second dump, the property row has more properties and with the wrong indexs.

Screenshots
First dump:

Second dump:

Details

• Phalcon version: 5.4.0
• PHP Version: 8.1.25
• Operating System: Docker image - php:8.1-fpm
• Installation type: installing via package manager
• Server: Nginx
• Database: mysql:8

[dfernandesbsolus]

I have the same problem :(

[apoca]

Same problem here!!!

[niden]

Resolved in #16468

Thank you @JoaoSetas @dfernandesbsolus and @apoca for reporting this