php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Doc Bug #74140 mysqli_begin_transaction returns FALSE
Submitted: 2017-02-21 11:59 UTC Modified: 2018-01-29 23:34 UTC
From: ajoliveira at ajoliveira dot com Assigned:
Status: Not a bug Package: MySQLi related
PHP Version: 7.1.2 OS: Ubuntu
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ajoliveira at ajoliveira dot com
New email:
PHP Version: OS:

 

 [2017-02-21 11:59 UTC] ajoliveira at ajoliveira dot com
Description:
------------
mysqli_begin_transaction with MYSQLI_TRANS_START_READ_WRITE consistently returns FALSE even if there is no error reported with mysqli_error

PHP 7.0.13-0ubuntu0.16.04.1 (cli) ( NTS )

mysql  Ver 15.1 Distrib 10.1.21-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Was working on January 4, 2017.

database is InnoDB

Test script:
---------------
example:

$bd=mysqli_connect(NHOST,NUSER,NPASS,NNAME);
	if($bd==FALSE){
		echo mysqli_error();
	        return FALSE;
	}

if(mysqli_begin_transaction($bd,MYSQLI_TRANS_START_READ_WRITE)==FALSE){
		echo mysqli_error();
		mysqli_close($bd);
		return FALSE;
	}


Expected result:
----------------
Returning FALSE only when an error is found


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-01-29 23:34 UTC] vrana@php.net
-Status: Open +Status: Not a bug
 [2018-01-29 23:34 UTC] vrana@php.net
It requires MySQL 5.6 or higher. MariaDB usually reports itself as MySQL 5.5.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 17:01:58 2024 UTC