|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #34282 Bundle SQLite 3.2.3, which has important fixes
Submitted: 2005-08-27 19:04 UTC Modified: 2005-08-28 18:59 UTC
From: bugs at ilibi dot com Assigned: iliaa (profile)
Status: Closed Package: PDO related
PHP Version: 5.1.0RC1 OS: linux
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: bugs at ilibi dot com
New email:
PHP Version: OS:


 [2005-08-27 19:04 UTC] bugs at ilibi dot com
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 
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 


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-08-28 01:14 UTC]
Ilia, can you check this out..
 [2005-08-28 18:59 UTC]
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
Thank you for the report, and for helping us make PHP better.

PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Wed Oct 20 05:03:33 2021 UTC