Bug #77888 [Opn->Fbk]: autocommit is not working !!

Edit report at https://bugs.php.net/bug.php?id=77888&edit=1 ID: 77888 Updated by: cmb@php.net Reported by: ch dot derenne at gmail dot com Summary: autocommit is not working !! -Status: Open +Status: Feedback Type: Bug Package: PDO Firebird Operating System: fedora28 PHP Version: 7.3.4 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: The following script gives the desired results for me (PHP-7.4 with Firebird 3.0.7): <?php $pdo = new PDO("firebird:dbname=C:\\test.fdb", "sysdba", "masterkey", [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); $pdo->exec("CREATE TABLE bug77888 (nam VARCHAR(50))"); $pdo->exec("CREATE PROCEDURE prc AS BEGIN INSERT INTO bug77888 VALUES ('foo'); END"); $pdo->exec("EXECUTE PROCEDURE prc"); $stmt = $pdo->query("SELECT nam FROM bug77888"); var_dump($stmt->fetchAll()); ?> If you still experience issues with any of the actively supported PHP versions[1], please provide a small self-contained reproducer, and/or further details of your system. [1] <https://www.php.net/supported-versions.php> Previous Comments: ------------------------------------------------------------------------ [2019-04-13 16:31:16] ch dot derenne at gmail dot com Description: ------------ Autocommit is not working well with firebird : In fact : Create a selecatble stored procedure that juste insert a row in a table Connect to pdo firebird database Use autocommit : $db->setAttribute( PDO::ATTR_AUTOCOMMIT, 1 ); Call the stored procedure Close the connection Do a select of tha table : the row is not present !! Now insert a commit just before closing connection. Execute the script : the row is present !! Expected result: ---------------- The transaction should be commited Actual result: -------------- The transaction is not commited ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=77888&edit=1