From: michael at bluemoon dot com
Operating system: Linux/Windows
PHP version: 5.1.2
PHP Bug Type: PDO related
Bug description: Interbase PDO
Description:
------------
Exception thrown when issuing SELECT query using PDO driver
for Firebird/Interbase. Database Server runs Interbase 7.5.x
(Linux).
Problem occurs with PHP 5.1.2 running in both Linux/Apache 2
and Windows 2000/IIS environments.
Tried running PHP alternately with Interbase 6 and 7.5 Run-
time Client Libraries on each platform; same problem.
Native PHP Firebird/Interbase functions (e.g., ibase_connect
(), etc.) functions work fine in same environments used to
test PDO functions.
Confirmed DSN string used in my PDO connection function is
correct by testing PDO::ATTR_CONNECTION_STATUS attribute;
value returned is 1.
Reproduce code:
---------------
try {
$dbh = new PDO($dsn, $user, $password, array(
PDO::ATTR_PERSISTENT => true
));
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $dbh->prepare("SELECT Count(*) FROM MY_TABLE");
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_NUM);
$stmt = null;
echo $row[0];
}
catch (PDOException $e) {
die $e->getMessage();
}
Expected result:
----------------
Should output integer value result from SELECT query to screen
Actual result:
--------------
Outputs the following error:
SQLSTATE[HY000]: General error: -804 Dynamic SQL Error SQL
error code = -804 Incorrect values within SQLDA structure
--
Edit bug report at http://bugs.php.net/?id=36128&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=36128&r=trysnapshot44
Try a CVS snapshot (PHP 5.1):
http://bugs.php.net/fix.php?id=36128&r=trysnapshot51
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=36128&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=36128&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=36128&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=36128&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=36128&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=36128&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=36128&r=support
Expected behavior: http://bugs.php.net/fix.php?id=36128&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=36128&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=36128&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=36128&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36128&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=36128&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=36128&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=36128&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=36128&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=36128&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=36128&r=mysqlcfg
