Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.0b4

Bug #13581 beginTransaction() issue wrong query.
Submitted: 2008-04-04 02:04 UTC Modified: 2008-04-07 17:03 UTC
From: sunaoka Assigned: quipo
Status: Closed Package: MDB2_Driver_mysql (version 1.4.1)
PHP Version: 5.2.5 OS:
Roadmaps: (Not assigned)    
Subscription  


 [2008-04-04 02:04 UTC] sunaoka (Norifumi Sunaoka)
Description: ------------ beginTransaction() issue wrong query. see: http://dev.mysql.com/doc/refman/4.1/en/commit.html Test script: --------------- $db =& MDB2::factory('mysql://username:password@localhost/test'); $db->beginTransaction(); echo $db->last_query; Expected result: ---------------- SET AUTOCOMMIT = 0 Actual result: -------------- SET AUTOCOMMIT = 1

Comments

 [2008-04-07 15:43 UTC] brotherli (Thomas Bruederli)
I had the same problem with the 1.4.1 version. Finally I found the problem in _getServerCapabilities() where the capabilities are only checked once (static $already_checked is set to true). When creating a second instance using MDB2::connect(), this new object does never enter the if-block on line 751. Changing static $already_checked to $this->already_checked solved the problem for me.
 [2008-04-07 17:03 UTC] quipo (Lorenzo Alberton)
@Norifumi: you're right, thanks for noticing. Fixed in CVS. @Thomas: that's another issue, it was fixed in the latest release. Please upgrade.