|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #63690 Problems with a manual transaction while auto commit is enabled.
Submitted: 2012-12-05 07:15 UTC Modified: 2017-10-24 06:45 UTC
Avg. Score:4.2 ± 1.2
Reproduced:5 of 6 (83.3%)
Same Version:3 (60.0%)
Same OS:2 (40.0%)
From: james at kenjim dot com Assigned:
Status: Open Package: PDO Firebird
PHP Version: master-Git-2012-12-05 (Git) OS: All
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: james at kenjim dot com
New email:
PHP Version: OS:


 [2012-12-05 07:15 UTC] james at kenjim dot com
The documentation at gives me the impression that the default mode a pdo db driver is in is auto-commit.  If I choose to create a batch of queries in one transaction I can do so by first issuing a begin transaction.  This however does not appear to be the case when looking at the c code for all but the odbc pdo driver.  Auto-commit is never actually disabled so all my queries in my transaction block get committed when they get executed.  I have only tested this behavior with Firebird.

I have created a patch that will turn off auto-commit at the driver level when beginTransaction is called and will restore the user setting when commit or rollback is called.  This way all pdo drivers that support transactions and auto-commit should now act properly.  The patch also includes the ability to support commits/rollbacks that keep the transaction open.  Also included in this patch is my patch from Request #63215 since I realized that patch needed pdo to support the ability to keep a transaction open after calling commit/rollback.

Please note my patch was only tested with the Firebird database driver so other database drivers should have their beginTransaction with auto-commit on functionality tested.


PDO_Transaction_During_AutoCommit_and_Commit_Continue_Support (last revision 2012-12-05 07:16 UTC) by james at kenjim dot com)

Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2013-02-22 16:11 UTC]
-Status: Open +Status: Assigned -Assigned To: +Assigned To: mariuz
 [2014-01-01 12:35 UTC]
-Package: PDO related +Package: PDO Firebird
 [2017-10-24 06:45 UTC]
-Status: Assigned +Status: Open -Assigned To: mariuz +Assigned To:
PHP Copyright © 2001-2018 The PHP Group
All rights reserved.
Last updated: Sun Nov 19 01:31:42 2017 UTC