Bug #53651 [Asn->Fbk]: Under mysqlnd, mysqli_affected_rows() returns 0

Edit report at http://bugs.php.net/bug.php?id=53651&edit=1 ID: 53651 Updated by: andrey@php.net Reported by: marc at phpmyadmin dot net Summary: Under mysqlnd, mysqli_affected_rows() returns 0 -Status: Assigned +Status: Feedback Type: Bug Package: MySQLi related Operating System: Linux PHP Version: 5.3.4 Assigned To: mysql Block user comment: N Private report: N New Comment: I can't reproduce it. Maybe it's bogus due to something else. Here are my results : myslqnd + MySQL 5.5.8 (executed twice in a row) andrey@poohie:/work/vanilla/php/php-src/branches/PHP_5_3$ ./php b.php Affected rows (UPDATE): 1 andrey@poohie:/work/vanilla/php/php-src/branches/PHP_5_3$ ./php b.php Affected rows (UPDATE): 0 myslqnd + MySQL 5.1-dev (executed twice in a row) andrey@poohie:/work/vanilla/php/php-src/branches/PHP_5_3$ ./php b.php Affected rows (UPDATE): 1 andrey@poohie:/work/vanilla/php/php-src/branches/PHP_5_3$ ./php b.php Affected rows (UPDATE): 0 As you see, the second time the result is 0. Why? It is a feature or gotcha of MySQL. If the row doesn't change affected_rows is 0. And the row doesn't change from toto to toto there is no change, thus the row is left intact. Previous Comments: ------------------------------------------------------------------------ [2011-01-04 19:08:06] marc at phpmyadmin dot net Description: ------------ In PHP 5.3.4 (also 5.3.3 and 5.3.2), connecting to MySQL 5.1.49 with mysqli extension under mysqlnd, I always obtain 0 as the result of mysqli_affected_rows() following an UPDATE that changed one row. Works fine under PHP 5.2.14 + MySQL 5.1.49 client library. Thanks, Marc Delisle Test script: --------------- <?php $link = mysqli_init(); mysqli_real_connect($link, 'localhost', 'user', 'password', 'db'); /* * CREATE TABLE mytable (id int not null, myname varchar(50 not null)) engine=MyISAM; * INSERT INTO mytable (id, myname) values(1, 'toto'); */ mysqli_query($link, "update mytable set myname='Marc' where id=1"); printf("Affected rows (UPDATE): %d\n", mysqli_affected_rows($link)); mysqli_close($link); ?> Expected result: ---------------- Affected rows (UPDATE): 1 Actual result: -------------- Affected rows (UPDATE): 0 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=53651&edit=1