From: bugs at ilibi dot com Operating system: linux PHP version: 5.1.0RC1 PHP Bug Type: SQLite related Bug description: Bundle SQLite 3.2.3, which has important fixes
Description: ------------ Please be advised that there has since been an importance update to SQLite. Ilia upgraded the bundled SQLite to 3.2.2 for beta 3. Please update to 3.2.4. 2005 August 21 (3.2.3) Added support for the CAST operator Tcl interface allows BLOB values to be transferred to user- defined functions Added the "transaction" method to the Tcl interface Allow the DEFAULT value of a column to call functions that have constant operands Added the ANALYZE command for gathering statistics on indices and using those statistics when picking an index in the optimizer Remove the limit (formerly 100) on the number of terms in the WHERE clause The right-hand side of the IN operator can now be a list of expressions instead of just a list of constants Rework the optimizer so that it is able to make better use of indices The order of tables in a join is adjusted automatically to make better use of indices The IN operator is now a candidate for optimization even if the left-hand side is not the left-most term of the index. Multiple IN operators can be used with the same index. WHERE clause expressions using BETWEEN and OR are now candidates for optimization Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE compile-time option to set its default value to "on". Use indices to help with GLOB expressions and LIKE expressions too when the case_sensitive_like pragma is enabled Added support for grave-accent quoting for compatibility with MySQL Improved test coverage Dozens of minor bug fixes 2005 August 24 (3.2.4) Fix a bug introduced in the previous release that can cause a segfault while generating code for complex WHERE clauses. Allow floating point literals to begin or end with a decimal point. -- Edit bug report at http://bugs.php.net/?id=34282&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34282&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34282&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34282&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=34282&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=34282&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34282&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34282&r=needscript Try newer version: http://bugs.php.net/fix.php?id=34282&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34282&r=support Expected behavior: http://bugs.php.net/fix.php?id=34282&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34282&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34282&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=34282&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34282&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=34282&r=dst IIS Stability: http://bugs.php.net/fix.php?id=34282&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34282&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34282&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34282&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34282&r=mysqlcfg