Doc #75666 [Com]: mysqli_begin_transaction GOOD work on mysql 5.5.58

From: Date: Tue, 12 Dec 2017 10:17:13 +0000
Subject: Doc #75666 [Com]: mysqli_begin_transaction GOOD work on mysql 5.5.58
References: 1  Groups: php.doc.bugs 
Request: Send a blank email to doc-bugs+get-15282@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=75666&edit=1 ID: 75666 Comment by: spam2 at rhsoft dot net Reported by: root_x at ukr dot net Summary: mysqli_begin_transaction GOOD work on mysql 5.5.58 Status: Verified Type: Documentation Problem Package: MySQLi related Operating System: Linux 4.4.0-62-generic 64bit PHP Version: Irrelevant Block user comment: N Private report: N New Comment: > Requires MySQL 5.6 and above, and the InnoDB engine (it is enabled by default) this is nonsense, it needs InnoDB which became default in 5.6 but si available for ages now and frankly it don't even need PHP 5.5 for transactions to work, just InnoDB and plain SQL (HP 5 >= 5.5.0, PHP 7) https://dev.mysql.com/doc/refman/5.5/en/commit.html Previous Comments: ------------------------------------------------------------------------ [2017-12-12 02:09:59] root_x at ukr dot net Good. I thought that only I alone did not understand this "problem". I previously noticed some errors in the translation. I can report them through a bug tracker. (Only I need to carefully fill in the fields when registering bugreport). ------------------------------------------------------------------------ [2017-12-12 02:01:10] requinix@php.net Yes, the documentation will be updated. ------------------------------------------------------------------------ [2017-12-12 01:58:54] root_x at ukr dot net Will there be any changes on the site in the documentation? Or at least a comment on the documentation? ------------------------------------------------------------------------ [2017-12-12 01:04:19] requinix@php.net mysqli_begin_transaction basically just builds and executes a START TRANSACTION statement. The only thing that requires MySQL >=5.6 are the READ ONLY and READ WRITE modes. Plain transactions and WITH CONSISTENT SNAPSHOT transactions will work with MySQL 5.5. This is already enforced correctly by PHP. https://dev.mysql.com/doc/refman/5.5/en/commit.html ------------------------------------------------------------------------ [2017-12-12 00:30:19] root_x at ukr dot net Description: ------------ On localhost: mysql server 5.5.58 php 5.5.9 mysqli_begin_transaction works without any problems ( https://www.youtube.com/watch?v=OQoU02zLwFw ). But in the documentation it is written that for work it is required mysql 5.6 or higher: http://php.net/manual/en/mysqli.begin-transaction.php Why the code works on the mysql version 5.5.58 ? I do not understand something :( https://stackoverflow.com/questions/47762765/mysqli-begin-transaction-work-on-mysql-5-5-57?noredirect=1#comment82487811_47762765 Expected result: ---------------- I was expecting an error message. Actual result: -------------- NO bug.Еverything works well. BUT so it should not be.(?) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=75666&edit=1

« previous php.doc.bugs (#15282) next »