Opened 9 years ago

Closed 9 years ago

#5387 closed enhancement (fixed)


Reported by: Fernando de Oliveira Owned by: Fernando de Oliveira
Priority: normal Milestone: 7.6
Component: BOOK Version: SVN
Severity: normal Keywords:


2014-08-15 - Release 3.8.6

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 ticket 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

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. 

Change History (2)

comment:1 by Fernando de Oliveira, 9 years ago

Owner: changed from blfs-book@… to Fernando de Oliveira
Status: newassigned

comment:2 by Fernando de Oliveira, 9 years ago

Resolution: fixed
Status: assignedclosed

Fixed at r13927.

Note: See TracTickets for help on using tickets.