1--TEST--
2PDO_Firebird: Bug #76488 Memory leak when fetching a BLOB field
3--EXTENSIONS--
4pdo_firebird
5--SKIPIF--
6<?php require('skipif.inc'); ?>
7--ENV--
8LSAN_OPTIONS=detect_leaks=0
9--FILE--
10<?php
11require 'testdb.inc';
12
13$sql = '
14with recursive r(n) as (
15  select 1 from rdb$database
16  union all
17  select n+1 from r where n < 1000
18)
19select n,
20       cast(lpad(\'A\', 8000, \'A\') as BLOB sub_type TEXT) as SRC
21from r
22';
23
24    for ($i = 0; $i < 10; $i++) {
25        $sth = $dbh->prepare($sql);
26        $sth->execute();
27        $rows = $sth->fetchAll();
28        unset($rows);
29        unset($sth);
30    }
31    unset($dbh);
32    echo "OK";
33?>
34--EXPECT--
35OK
36