SQLite version 3.8.6 is now available on the SQLite website:
http://www.sqlite.org/
http://www.sqlite.org/download.html
SQLite version 3.8.6 is a regularly scheduled maintenance release. Upgrading
from all previous versions is recommended.
This release contains the usual assortment of obscure bug fixes. One bug,
however, deserves special attention. A problem appeared in the CREATE INDEX
command beginning with version 3.8.2 (2013-12-06) that allowed, under some
circumstances, a UNIQUE index to be created on a column that was not unique.
Once the index was created, no new non-unique entries could be inserted, but
preexisting non-unique entries would remain. See
http://www.sqlite.org/src/info/9a6daf340df99ba93c for further information. In
addition to fixing this bug, the PRAGMA integrity_check command has been
enhanced to detect non-uniqueness in UNIQUE indices, so that if this bug did
introduce any problems in databases, those problems can be easily detected.
Other noteworthy changes include the addition of support for hexadecimal
integers (ex: 0x1234), and performance enhancements to the IN operator which,
according to mailing list reports, help some queries run up to five times
faster.
Version 3.8.6 uses 25% fewer CPU cycles than version 3.8.0 from approximately
one year ago, according to valgrind and the test/speedtest1.c test program. On
the other hand, the compiled binary for version 3.8.6 is about 5% larger than
3.8.0. The size increase is due in part to the addition of new features such as
WITHOUT ROWID tables and common table expressions.
Please post to the [email protected] mailing list if you encounter any
problems in this release.
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-announce mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce
