Doc #75666 [Com]: mysqli_begin_transaction GOOD work on mysql 5.5.58
| From: | spam2 at rhsoft dot net | 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