Bug #72931 [Com]: PDO_FIREBIRD with Firebird 3.0 not work on returning statement

From: Date: Mon, 05 Dec 2016 16:45:54 +0000
Subject: Bug #72931 [Com]: 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-205783@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 Comment by: dorin dot marcoci at gmail dot com Reported by: edgardmessias at gmail dot com Summary: PDO_FIREBIRD with Firebird 3.0 not work on returning statement Status: Open Type: Bug Package: PDO Firebird Operating System: Any PHP Version: Irrelevant Block user comment: N Private report: N New Comment: All current pdo_firebird tests passed OK. My own scenarios passed. Patch submited in Firebird community for further testing. Previous Comments: ------------------------------------------------------------------------ [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 (#205783) next »