Weird interplay between Collection and PDO result set about collection HOT 13 CLOSED

<?php
require_once 'inc/prelude.php';
use loophp\iterators\ClosureIteratorAggregate;
use loophp\collection\Iterator\PsrCacheIterator;
use Symfony\Component\Cache\Adapter\ArrayAdapter;
use loophp\iterators\FilterIterableAggregate;
$fromDate = '2023-09-15 00:00:00';
$toDate = '2023-09-30 23:59:59';
$query = "SELECT *
          FROM communication
          WHERE `date` BETWEEN :fromDate AND :toDate";
$statement = $pdo->prepare($query);
$statement->bindValue('fromDate', $fromDate, PDO::PARAM_STR);
$statement->bindValue('toDate', $toDate, PDO::PARAM_STR);
$statement->execute();
$statement->setFetchMode(PDO::FETCH_ASSOC);
echo $statement->rowCount();
$cached = new ClosureIteratorAggregate(fn () => yield from new PsrCacheIterator($statement->getIterator(), new ArrayAdapter()), []);
$get = fn () => yield from new FilterIterableAggregate($cached, fn()=>true);
$get()->current();
$get()->current();

foreach ($cached as $i=> $r){
    var_dump($i, $r);
}

<?php
require_once 'inc/prelude.php';
use loophp\iterators\ClosureIteratorAggregate;
use loophp\collection\Iterator\PsrCacheIterator;
use Symfony\Component\Cache\Adapter\ArrayAdapter;
use loophp\iterators\FilterIterableAggregate;
$fromDate = '2023-09-15 00:00:00';
$toDate = '2023-09-30 23:59:59';
$query = "SELECT *
          FROM communication
          WHERE `date` BETWEEN :fromDate AND :toDate";
$statement = $pdo->prepare($query);
$statement->bindValue('fromDate', $fromDate, PDO::PARAM_STR);
$statement->bindValue('toDate', $toDate, PDO::PARAM_STR);
$statement->execute();
$statement->setFetchMode(PDO::FETCH_ASSOC);
echo $statement->rowCount();
$cached = new PsrCacheIterator($statement->getIterator(), new ArrayAdapter());
$get = fn () => yield from new FilterIterableAggregate($cached, fn()=>true);
$get()->current();
$get()->current();

foreach ($cached as $i=> $r){
    var_dump($i, $r);
}

<?php require_once 'vendor/autoload.php';
use loophp\iterators\ClosureIteratorAggregate;
use loophp\collection\Iterator\PsrCacheIterator;
use Symfony\Component\Cache\Adapter\ArrayAdapter;
use loophp\iterators\FilterIterableAggregate;

$pdo = new PDO('sqlite::memory:');
$pdo->query("CREATE TABLE communication(
    id INTEGER PRIMARY KEY,
    date TEXT,
    remarks TEXT
);");
$pdo->query("INSERT INTO communication
    (id, date, remarks)
    VALUES
    (1, '2023-09-17 11:47:11', 'This is the first one'),
    (2, '2023-09-18 07:52:19', 'This is the second one'),
    (3, '2023-09-19 13:05:17', 'This is the third one');
");


$fromDate = '2023-09-15 00:00:00';
$toDate = '2023-09-30 23:59:59';
$query = "SELECT *
          FROM communication
          WHERE `date` BETWEEN :fromDate AND :toDate";
$statement = $pdo->prepare($query);
$statement->bindValue('fromDate', $fromDate, PDO::PARAM_STR);
$statement->bindValue('toDate', $toDate, PDO::PARAM_STR);
$statement->execute();
$statement->setFetchMode(PDO::FETCH_ASSOC);

$cached = new ClosureIteratorAggregate(fn () => yield from new PsrCacheIterator($statement->getIterator(), new ArrayAdapter()), []);
$get = fn () => yield from new FilterIterableAggregate($cached, fn()=>true);
$get()->current();
$get()->current();

foreach ($cached as $i=> $r){
    var_dump($i, $r);
}

<?php declare(strict_types=1);

namespace Bug;

use loophp\collection\Collection;
use PDO;

require_once __DIR__ . '/vendor/autoload.php';

$pdo = new PDO('sqlite::memory:');
$pdo->query("CREATE TABLE communication(
    id INTEGER PRIMARY KEY,
    date TEXT,
    remarks TEXT
);");
$pdo->query("INSERT INTO communication
    (id, date, remarks)
    VALUES
    (1, '2023-09-17 11:47:11', 'This is the first one'),
    (2, '2023-09-18 07:52:19', 'This is the second one'),
    (3, '2023-09-19 13:05:17', 'This is the third one');
");

$fromDate = '2023-09-15 00:00:00';
$toDate = '2023-09-30 23:59:59';
$query = "SELECT *
          FROM communication
          WHERE `date` BETWEEN :fromDate AND :toDate";
$statement = $pdo->prepare($query);
$statement->bindValue('fromDate', $fromDate, PDO::PARAM_STR);
$statement->bindValue('toDate', $toDate, PDO::PARAM_STR);
$statement->execute();
$statement->setFetchMode(PDO::FETCH_ASSOC);

$collection = Collection::fromIterable($statement->getIterator());

$collection->current();
$collection->current();

foreach ($collection as $i => $r){
    var_dump($i, $r);
}