Bug #78179 [NEW]: MariaDB 10.3 broke mysqli::begin_transaction()

From: david dot bergeron5 at usherbrooke dot ca Operating system: Debian 9 PHP version: Irrelevant Package: MySQLi related Bug Type: Bug Bug description:MariaDB 10.3 broke mysqli::begin_transaction() Description: ------------ MariaDB Version 10.3.15-MariaDB-1:10.3.15+maria~stretch PHP Version: PHP version: 7.0.33-0+deb9u3 With MariaDB 10.3 they remove the innoDB version reporting. I think this is due to this issue in MariaDB. https://jira.mariadb.org/browse/MDEV-16172 So when you do a $db->begin_transaction(MYSQLI_TRANS_START_READ_WRITE); You receive a "PHP Warning: mysqli::begin_transaction(): This server version doesn't support 'READ WRITE' and 'READ ONLY'. Minimum 5.6.5 is required in /var/www/html/..." Test script: --------------- $host="localhost"; $username="username"; $password="password"; $database="yourdatabase"; $db = new mysqli( $host, $username, $password, $database); $db->begin_transaction(MYSQLI_TRANS_START_READ_WRITE); Expected result: ---------------- Should not say that this doesn't support 'READ WRITE'. Actual result: -------------- PHP Warning: mysqli::begin_transaction(): This server version doesn't support 'READ WRITE' and 'READ ONLY'. Minimum 5.6.5 is required in /var/www/html/dbtest.php on line 8 -- Edit bug report at https://bugs.php.net/bug.php?id=78179&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=78179&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=78179&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=78179&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=78179&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=78179&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=78179&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=78179&r=needscript Try newer version: https://bugs.php.net/fix.php?id=78179&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=78179&r=support Expected behavior: https://bugs.php.net/fix.php?id=78179&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=78179&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=78179&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=78179&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=78179&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=78179&r=dst IIS Stability: https://bugs.php.net/fix.php?id=78179&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=78179&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=78179&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=78179&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=78179&r=mysqlcfg