Repository navigation
PgSQL large object resource is incorrectly closed #9411
Description
Description
The following code:
<?php
$pdo = new PDO('pgsql:host=127.0.0.1;dbname=test', 'root', 'root');
$pdo->beginTransaction();
$oid = $pdo->pgsqlLOBCreate();
var_dump($lob = $pdo->pgsqlLOBOpen($oid, 'wb'));
fwrite($lob, 'test');
$pdo->commit();
$pdo->beginTransaction();
var_dump($lob = $pdo->pgsqlLOBOpen($oid, 'wb'));
var_dump(fgets($lob));Resulted in this output:
resource(4) of type (stream)
resource(5) of type (stream)
bool(false)
But I expected this output instead:
resource(4) of type (stream)
resource(5) of type (stream)
string(4) "test"
PHP Version
PHP 8.0.21
Operating System
Ubuntu 20.04
Activity
cmb69 commentedon Aug 24, 2022
Indeed, the first LOB stream is only closed after the second transaction has been started.
Fix GH-9411: PgSQL large object resource is incorrectly closed
Merge branch 'PHP-8.0' into PHP-8.1
Merge branch 'PHP-8.1' into PHP-8.2
Merge branch 'PHP-8.2'