Req #34630 [Com]: PDO: LOB support incomplete in some drivers
Edit report at http://bugs.php.net/bug.php?id=34630&edit=1
ID: 34630
Comment by: i dot kay at me dot com
Reported by: wez@php.net
Summary: PDO: LOB support incomplete in some drivers
Status: Closed
Type: Feature/Change Request
Package: Feature/Change Request
Operating System: *
PHP Version: 5CVS-2005-09-24 (cvs)
Assigned To: wez
New Comment:
Having just compiled PHP 5.3.2 on CentOS 5.5 domU I have encountered
this bug
after running make test.
I used the following configure command:
./configure --prefix=/usr/local --sysconfdir=/etc/php --with-apxs2
--with-zlib
The error reported by make test was:
=====================================================================
WARNED TEST SUMMARY
---------------------------------------------------------------------
via [ext/pdo_sqlite/tests/common.phpt]
SQLite PDO Common: Bug #34630 (inserting streams as LOBs)
[ext/pdo_sqlite/tests/bug_34630.phpt] (warn: XFAIL section but test
passes)
via [ext/sqlite/tests/pdo/common.phpt]
SQLite2 PDO Common: Bug #34630 (inserting streams as LOBs)
[ext/sqlite/tests/pdo/bug_34630.phpt] (warn: XFAIL section but test
passes)
=====================================================================
Previous Comments:
------------------------------------------------------------------------
[2008-07-23 13:58:18] uw@php.net
Now that PHP 5_3 compiles again on Solaris using Sun CC, I see this test
failing on:
mysqldev@production:~/Connector-PHP-PDO-mysqlnd/testlogs> find ./ -type
f -name bug_34630.diff
./solaris10-sparc64/bug_34630.diff
./solaris8-sparc64/bug_34630.diff
./hpux11.23-ia64/bug_34630.diff
./solaris9-sparc64/bug_34630.diff
mysqldev@production:~/Connector-PHP-PDO-mysqlnd/testlogs> cat
solaris10-sparc64/bug_34630.diff
007+ string(14) "Resource id #6"
007- string(17) "I am the LOB data"mysqldev
(This time AIX is not on the list because the AIX box has been skipped)
SPARC 32 bit seems fine.
------------------------------------------------------------------------
[2008-07-14 14:14:12] uw@php.net
This one still fails on aix5.2-ppc64 and hpux11.23-ia64 with
php5.3-200807081830. It seems to work fine on all other platforms.
------------------------------------------------------------------------
[2005-09-24 20:34:02] wez@php.net
Description:
------------
Quoting a reporting I received via email:
I'm trying to use PDO abstraction layer (version 1.0RC1), but I'm having
serious problems with LOB support in Oracle and Postgres (the only I've
tried).
Reproduce code:
---------------
<?php
/* Connect to an ODBC database using driver invocation */
$dsn = 'pgsql:host=192.168.0.4 port=5432 dbname=isodb_fresz';
$path = "test.jpg";
$dbh = new PDO($dsn, "isodb_user", "isodb_user");
$sql="
insert into iso_dane_binarne (db_dane_binarne_id, db_dane)
values(1, ?);";
$content = fopen($path, "rb");
print_r($content);
$stmt = $dbh->prepare($sql);
print_r(PDO_PARAM_LOB);
$stmt->bindParam( 1, $content, PDO_PARAM_LOB);
$stmt->execute();
?>
Expected result:
----------------
The image content in the database
Actual result:
--------------
This inserts something like "Resource id 3#" string into db_dane (bytea
type) column.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=34630&edit=1
Thread (8 messages)