ID: 44135 Comment by: chx1975 at gmail dot com Reported By: chx1975 at gmail dot com Status: Assigned Bug Type: PDO related Operating System: Linux PHP Version: 5.2.5 Assigned To: johannes New Comment:
I renamed it to what MySQL calls it. Please just drop the defines then, I copied them from mysql_com.h -- sorry, I am a n00b in doing this. Please also drop any client flags you do not feel useful. Previous Comments: ------------------------------------------------------------------------ [2008-10-23 13:25:24] [EMAIL PROTECTED] Thanks for the patch, a few comments/questions: - Why are you renaming the connect_opts variable? Any particular reason? - You shouldn't use the numeric values, as they might change, but the values provided by the client library, this also ensures that only flags supported by the library are being used. - I think the SSL flag won't work without specific SSL certs & stuff, but I have to check that myself ------------------------------------------------------------------------ [2008-10-23 01:34:27] chx1975 at gmail dot com An attempt to fix this can be found at http://drupal4hu.com/php-44135.patch . I added a number of flags not just the one I needed. running <?php $p = new PDO('mysql:host=localhost;dbname=test', 'root', '', array(PDO::MYSQL_ATTR_CLIENT_FLAGS => PDO::MYSQL_CLIENT_FOUND_ROWS)); $p->exec('TRUNCATE a'); $p->exec('INSERT INTO a VALUES (1)'); echo $p->exec('UPDATE a SET a = 1 WHERE a = 1'); $p = new PDO('mysql:host=localhost;dbname=test', 'root', ''); echo $p->exec('UPDATE a SET a = 1 WHERE a = 1'); ?> shows a 1 (one row found) and then a 0 (0 updated) so the patch seems to work. ------------------------------------------------------------------------ [2008-02-16 03:29:44] larry at garfieldtech dot com 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. ------------------------------------------------------------------------ [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
