php.net |  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: 2014-01-01 12:35 UTC
Votes:6
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: mariuz
Status: Assigned Package: PDO Firebird
PHP Version: master-Git-2012-12-05 (Git) OS: All
Private report: No CVE-ID:
Have you experienced this issue?
Rate the importance of this bug to you:

 [2012-12-05 07:15 UTC] james at kenjim dot com
Description:
------------
The documentation at http://php.net/manual/en/pdo.transactions.php 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.



Patches

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

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2013-02-22 16:11 UTC] mariuz@php.net
-Status: Open +Status: Assigned -Assigned To: +Assigned To: mariuz
 [2014-01-01 12:35 UTC] felipe@php.net
-Package: PDO related +Package: PDO Firebird
 
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Fri Feb 24 19:01:40 2017 UTC