#44135 [Com]: PDO MySQL does not support CLIENT_FOUND_ROWS

From: Date: Sat, 16 Feb 2008 03:29:45 +0000
Subject: #44135 [Com]: PDO MySQL does not support CLIENT_FOUND_ROWS
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-122333@lists.php.net to get a copy of this message
ID: 44135 Comment by: larry at garfieldtech dot com Reported By: chx1975 at gmail dot com Status: Open Bug Type: PDO related Operating System: Linux PHP Version: 5.2.5 New Comment: I can duplicate this problem. The issue appears to be that by default, MySQL will return the number of affected rows from a previous UPDATE statement, not the number of matched rows. That values will differ if the update statement would set a row to its existing value. With ext/mysql and ext/mysqli, it can be set to return matched rows instead. PDO does not appear to have a way to allow that. Previous Comments: ------------------------------------------------------------------------ [2008-02-16 03:26:34] chx1975 at gmail dot com Description: ------------ mysql_real_connect supports client flags http://dev.mysql.com/doc/refman/4.1/en/mysql-real-connect.html most importantly CLIENT_FOUND_ROWS but PDO provides no way to pass it in. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=44135&edit=1

« previous php.bugs (#122333) next »