--TEST-- Bug #46274 (pdo_pgsql - Segfault when using PDO::ATTR_STRINGIFY_FETCHES and blob) --SKIPIF-- --FILE-- setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); $db->query('CREATE TABLE test_one_blob (id SERIAL NOT NULL, blob1 BYTEA)'); $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)"); $data = 'foo'; $blob = fopen('php://memory', 'a'); fwrite($blob, $data); rewind($blob); $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); $stmt->execute(); $blob = ''; $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); $stmt->execute(); $data = ''; $blob = fopen('php://memory', 'a'); fwrite($blob, $data); rewind($blob); $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); $stmt->execute(); $blob = NULL; $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); $stmt->execute(); $res = $db->query("SELECT blob1 from test_one_blob"); // Resource var_dump($x = $res->fetch()); var_dump(fread($x['blob1'], 10)); // Resource var_dump($res->fetch()); var_dump(fread($x['blob1'], 10)); // Resource var_dump($res->fetch()); var_dump(fread($x['blob1'], 10)); // NULL var_dump($res->fetch()); $db->query('DROP TABLE test_one_blob'); ?> --EXPECTF-- array(2) { ["blob1"]=> resource(%d) of type (stream) [0]=> resource(%d) of type (stream) } string(3) "foo" array(2) { ["blob1"]=> resource(%d) of type (stream) [0]=> resource(%d) of type (stream) } string(0) "" array(2) { ["blob1"]=> resource(%d) of type (stream) [0]=> resource(%d) of type (stream) } string(0) "" array(2) { ["blob1"]=> NULL [0]=> NULL }