Bug #72931 [Opn->Csd]: PDO_FIREBIRD with Firebird 3.0 not work on returning statement

From: Date: Wed, 07 Dec 2016 20:18:13 +0000
Subject: Bug #72931 [Opn->Csd]: PDO_FIREBIRD with Firebird 3.0 not work on returning statement
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-205829@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=72931&edit=1 ID: 72931 Updated by: ab@php.net Reported by: edgardmessias at gmail dot com Summary: PDO_FIREBIRD with Firebird 3.0 not work on returning statement -Status: Open +Status: Closed Type: Bug Package: PDO Firebird Operating System: Any PHP Version: Irrelevant Block user comment: N Private report: N New Comment: Automatic comment on behalf of dorin.marcoci@marcodor.com Revision: http://git.php.net/?p=php-src.git;a=commit;h=13ffa88e1f62c4407c55e1b82c299fc452211662 Log: Fixed bug #72931 PDO_FIREBIRD with Firebird 3.0 not work on returning statement Previous Comments: ------------------------------------------------------------------------ [2016-12-05 16:45:51] dorin dot marcoci at gmail dot com All current pdo_firebird tests passed OK. My own scenarios passed. Patch submited in Firebird community for further testing. ------------------------------------------------------------------------ [2016-08-23 11:27:01] edgardmessias at gmail dot com 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 this bug report at https://bugs.php.net/bug.php?id=72931&edit=1

« previous php.bugs (#205829) next »