From: Operating system: All PHP version: 5.3SVN-2011-04-30 (SVN) Package: PDO related Bug Type: Feature/Change Request Bug description:PDO_MYSQL Always Uses Emulated Prepared Statements
Description: ------------ The PDO_MySQL driver defaults emulate_prepare to 1, which forces all prepared queries to be emulated by the driver. This means that even though the client library (mysqlnd or libmysql) may support prepared statements, PDO will never really use them. You can set the attribute PDO::ATTR_EMULATE_PREPARES to 0, and it prepares and executes the prepared statements just fine using the native mode (rather than emulation). However this is not documented at all on PHP.NET. Since PDO_MYSQL will fallback to emulation automatically if the client library or server are too old for prepared statements, I would suggest that the default value for emulate_prepare should be set to 0 to allow for true prepared statements. -- Edit bug report at http://bugs.php.net/bug.php?id=54638&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=54638&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=54638&r=trysnapshot53 Try a snapshot (trunk): http://bugs.php.net/fix.php?id=54638&r=trysnapshottrunk Fixed in SVN: http://bugs.php.net/fix.php?id=54638&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=54638&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=54638&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=54638&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=54638&r=needscript Try newer version: http://bugs.php.net/fix.php?id=54638&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=54638&r=support Expected behavior: http://bugs.php.net/fix.php?id=54638&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=54638&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=54638&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=54638&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=54638&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=54638&r=dst IIS Stability: http://bugs.php.net/fix.php?id=54638&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=54638&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=54638&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=54638&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=54638&r=mysqlcfg
