Bug #69656 [NEW]: mysqli_commit does not affect MYSQLI_ASYNC

From: contact at sshilko dot com Operating system: Linux PHP version: 5.5.25 Package: MySQLi related Bug Type: Bug Bug description:mysqli_commit does not affect MYSQLI_ASYNC Description: ------------ mysqli_commit does not work when using mysqlnd + MYSQLI_ASYNC + autocommit=false. The main transaction gets commited, but everything executed via MYSQLI_ASYNC does not get commited. Test script: --------------- https://gist.github.com/sshilko/2119c6b87ff4887142ab Expected result: ---------------- $ time php async.php Doing insert AUTOCOMMIT=FALSE: INSERT INTO asynctest (date, user_id) values ('2015-05-18', '1431964720') Insert done Doing select: Array ( [0] => Array ( [COUNT(*)] => 1 ) ) Doing insert AUTOCOMMIT=TRUE: INSERT INTO asynctest (date, user_id) values ('2015-05-18', '1431964720') Insert done Doing select: Array ( [0] => Array ( [COUNT(*)] => 2 ) ) real 0m0.032s user 0m0.013s sys 0m0.003s Actual result: -------------- $ time php async.php Doing insert AUTOCOMMIT=FALSE: INSERT INTO asynctest (date, user_id) values ('2015-05-18', '1431964720') Insert done Doing select: Array ( [0] => Array ( [COUNT(*)] => 0 ) ) Doing insert AUTOCOMMIT=TRUE: INSERT INTO asynctest (date, user_id) values ('2015-05-18', '1431964720') Insert done Doing select: Array ( [0] => Array ( [COUNT(*)] => 1 ) ) real 0m0.032s user 0m0.013s sys 0m0.003s -- Edit bug report at https://bugs.php.net/bug.php?id=69656&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=69656&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=69656&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=69656&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=69656&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=69656&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=69656&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=69656&r=needscript Try newer version: https://bugs.php.net/fix.php?id=69656&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=69656&r=support Expected behavior: https://bugs.php.net/fix.php?id=69656&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=69656&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=69656&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=69656&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=69656&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=69656&r=dst IIS Stability: https://bugs.php.net/fix.php?id=69656&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=69656&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=69656&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=69656&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=69656&r=mysqlcfg