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 07:04 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  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 31 - 11 = ?

 
 [2008-04-04 07: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 20: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 22: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.