[PECL-BUG] Bug #16074 [NEW]: pdo_informix bidValue(...) does not work correctly

[email protected] ("sahib dot alejandro at gmail dot com")
Newsgroups php.pear.webmaster
Message-ID <[email protected]>
From:             sahib dot alejandro at gmail dot com
Operating system: Ubuntu 8.10
Package version:  
PHP version:      5.2.6
Package:          Bug System
Bug Type:         Bug
Bug description:  pdo_informix bidValue(...) does not work correctly

Description:
------------
PDO_INFORMIX bindValue(...) or bindParam(...) does not work as expected,
there is no diference using prepare(...) with a direct sql query or a
stored procedure query.
It seems the binded value lose their value and if you're using these value
in the WHERE clause then always fail the condition.

Configuration:
Ubuntu 8.10
Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4.1 with Suhosin-Patch
Informix CSDK 3.50 UC.3DE.Linux
IBM Informix Dynamic Server Version 10.00.FC4
PDO_INFORMIX driver 1.2.6

Reproduce code:
---------------
mypdo1.php [using bindValue(...), DON'T WORK]
<?
$Pdo = new PDO('informix: host=myhost; server=myserver; protocol=onsoctcp;
service=11000; database=empleados', 'user', 'password');
$Stmt = $Pdo->prepare('EXECUTE PROCEDURE test(?)');
$Stmt->bindValue(1, $sString);
$sString = "myString";
$Stmt->execute();
$aRow = $Stmt->fetch(PDO::FETCH_NUM);
echo '<pre>'; var_dump($aRow); echo '</pre>';
?>

mypdo2.php [using direct value in sql query, IT WORK]
<?
$Pdo = new PDO('informix: host=myhost; server=myserver; protocol=onsoctcp;
service=11000; database=empleados', 'user', 'password');
$Stmt = $Pdo->prepare('EXECUTE PROCEDURE test("myString")');
$Stmt->execute();
$aRow = $Stmt->fetch(PDO::FETCH_NUM);
echo '<pre>'; var_dump($aRow); echo '</pre>';
?>

Expected result:
----------------
Same result in both scripts
array(2) {
  [0]=>
  string(9) "JARAMILLO"
  [1]=>
  string(3) "LEO"
}

Actual result:
--------------
mypdo1.php
array(2) {
  [0]=>
  NULL
  [1]=>
  NULL
}

mypdo2.php
array(2) {
  [0]=>
  string(9) "JARAMILLO"
  [1]=>
  string(3) "LEO"
}

-- 
Edit bug report at http://pecl.php.net/bugs/bug.php?id=16074&edit=1
--
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.