Bug #72931 [NEW]: PDO_FIREBIRD with Firebird 3.0 not work on returning statement
| From: | edgardmessias at gmail dot com | Date: | Tue, 23 Aug 2016 11:27:03 +0000 |
| Subject: | Bug #72931 [NEW]: PDO_FIREBIRD with Firebird 3.0 not work on returning statement | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-203509@lists.php.net to get a copy of this message | ||
From: edgardmessias at gmail dot com
Operating system: Any
PHP version: Irrelevant
Package: PDO Firebird
Bug Type: Bug
Bug description:PDO_FIREBIRD with Firebird 3.0 not work on returning statement
Description:
------------
The problem occurs when Firebird 3.0 is used.
Using the "pdo_firebird" extension, the problem occurs.
If you use the "Interbase" extension is run normally.
Test script:
---------------
<?php
$pdo = new
PDO('firebird:dbname=localhost:/tmp/TEST.FDB;charset=ISO8859_1',
'SYSDBA', 'masterkey', array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_CASE => PDO::CASE_LOWER,
));
$stmt = $pdo->prepare("INSERT INTO animal (type) VALUES ('cat')
RETURNING type");
$stmt->execute();
echo $stmt->fetchColumn();
?>
Expected result:
----------------
cat
Actual result:
--------------
SQLSTATE[HY000]: General error: -902 Dynamic SQL Error SQLDA error Wrong
number of parameters (expected 1, got 0)
--
Edit bug report at https://bugs.php.net/bug.php?id=72931&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=72931&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=72931&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=72931&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=72931&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=72931&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=72931&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=72931&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=72931&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=72931&r=support
Expected behavior: https://bugs.php.net/fix.php?id=72931&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=72931&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=72931&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=72931&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=72931&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=72931&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=72931&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=72931&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=72931&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=72931&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=72931&r=mysqlcfg