1.0.47.0 Posted

Last post 12-04-2007 9:18 AM by Robert Simpson. 0 replies.

Page 1 of 1 (1 items)
	Sort Posts: Previous Next

Reply Contact

Code merge with SQLite 3.5.3
Added installer support for Visual Studio 2008. Code is still using the VS2005 SDK so one or two bells and whistles are missing, but nothing significant.
This is the last version that the FTS1 and FTS2 extensions will appear. Everyone should rebuild their fulltext indexes using the new FTS3 module. FTS1 and FTS2 suffer from a design flaw that could cause database corruption with certain vacuum operations.
Fixed pooled connections so they rollback any outstanding transactions before going to the pool.
Fixed the unintended breaking of the TYPES keyword, and mis-typing of untyped or indeterminate column types.
Assert a FileIOPermission() requirement in the static SQLiteFunction constructor.
The CE-only SQLiteFunction.RegisterFunction() is now available on the desktop platform for dynamic registration of functions. You must still close and re-open a connection in order for the new function to be seen by a connection.
Fixed the "database is locked" errors by implementing behavioral changes in the interop.c file for SQLite. Closing a database force-finalizes any prepared statements on the database to ensure the connection is fully closed. This was rather tricky because the GC thread could still be finalizing statements itself.
Modifed the mergebin utility to help circumvent a long-standing strong name verification bug in the Compact Framework.

Page 1 of 1 (1 items)