#46249 [Opn->Fbk]: pdo_pgsql always fill in NULL for empty BLOB
| From: | felipe@php.net | Date: | Sat, 11 Oct 2008 00:26:17 +0000 |
| Subject: | #46249 [Opn->Fbk]: pdo_pgsql always fill in NULL for empty BLOB | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-129615@lists.php.net to get a copy of this message | ||
ID: 46249
Updated by: felipe@php.net
Reported By: hswong3i at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: Debian
PHP Version: 5.2.6
New Comment:
I can't reproduce using 5.3CVS:
$db = new PDO('pgsql:host=localhost dbname=test', 'foo', 'bar',
array(PDO::ATTR_STRINGIFY_FETCHES => TRUE));
$stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (?)");
$stmt->execute(array(''));
var_dump($db->errorinfo());
$stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES
(:foo)");
$x = '';
$stmt->bindParam(':foo', $x);
$stmt->execute();
var_dump($db->errorinfo());
$stmt = $db->query("INSERT INTO test_one_blob (blob1) VALUES ('')");
$stmt->execute();
teste=> select * from test_one_blob where blob1 is null;
id | blob1
----+-------
(0 registros)
Do you have tested using PDO directly, without Drupal's db_insert()?
Previous Comments:
------------------------------------------------------------------------
[2008-10-07 18:00:22] hswong3i at gmail dot com
Description:
------------
When pdo_pgsql working with:
1. BLOB field,
2. running INSERT/UPDATE queries, and
3. BLOB value with empty string ''
It will always fill NULL into database and so result as buggy.
INSERT/UPDATE BLOB value with NULL will function correctly.
P.S. pdo_mysql is NOT buggy when running with similar programming
logic, empty string pass into database correctly. Tested with PHP5.2.6
and PHP5.3-dev, both are buggy.
Reproduce code:
---------------
Please refer to http://drupal.org/node/316095#comment-1047830
for more
information.
Expected result:
----------------
Empty string should fill into database correctly.
Actual result:
--------------
Empty string is now stored as NULL.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=46249&edit=1