#42443 [NEW]: PDO SQLite3 lacks integer type support

From: gwynne@php.net Operating system: * PHP version: 6CVS-2007-08-27 (CVS) PHP Bug Type: SQLite related Bug description: PDO SQLite3 lacks integer type support Description: ------------ PDO SQLite3 calls sqlite3_bind_text() for all non-blob and non-null parameter types regardless of whether integer data is provided. Integer data can be bound with sqlite3_bind_int(), which saves memory space and improves efficiency, as well as storing the intended type in a database which uses SQLite3's value typing. Patch is at: http://news.php.net/php.internals/31935 Reproduce code: --------------- Difficult to show reproduction. Expected result: ---------------- Difficult to show reproduction. Actual result: -------------- Difficult to show reproduction. -- Edit bug report at http://bugs.php.net/?id=42443&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42443&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42443&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42443&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42443&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42443&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42443&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42443&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42443&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42443&r=support Expected behavior: http://bugs.php.net/fix.php?id=42443&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42443&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42443&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42443&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42443&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42443&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42443&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42443&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42443&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42443&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42443&r=mysqlcfg