csu3_am335x/EVSE/GPL/php-8.1.12/ext/pdo_firebird/tests/bug_76488.phpt

--TEST--
PDO_Firebird: Bug #76488 Memory leak when fetching a BLOB field
--EXTENSIONS--
pdo_firebird
--SKIPIF--
<?php require('skipif.inc'); ?>
--ENV--
LSAN_OPTIONS=detect_leaks=0
--FILE--
<?php
require 'testdb.inc';

$sql = '
with recursive r(n) as (
  select 1 from rdb$database
  union all
  select n+1 from r where n < 1000
)
select n,
       cast(lpad(\'A\', 8000, \'A\') as BLOB sub_type TEXT) as SRC
from r
';

    for ($i = 0; $i < 10; $i++) {
        $sth = $dbh->prepare($sql);
        $sth->execute();
        $rows = $sth->fetchAll();
        unset($rows);
        unset($sth);
    }
    unset($dbh);
    echo "OK";
?>
--EXPECT--
OK