Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the change log. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
eb5c390d520c986af0aca8a4ee734b41 |
| User & Date: | drh 2015-07-02 19:01:13 |
Context
|
2015-07-02
| ||
| 20:03 | Add "Compiling and Using FTS5" section to fts5.html. check-in: 59ff0eaf28 user: dan tags: trunk | |
| 19:01 | Update the change log. check-in: eb5c390d52 user: drh tags: trunk | |
| 17:59 | Fix a missing comma in fts5.in. check-in: b7f67421b7 user: dan tags: trunk | |
Changes
Changes to pages/changes.in.
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
proc chng {date desc {options {}}} {
global nChng aChng
set aChng($nChng) [list $date $desc $options]
incr nChng
}
chng {2015-00-00 (3.8.11)} {
<li>Added the [sqlite3_value_dup()] and [sqlite3_value_free()] interfaces.
<li>The [IS operator] is now able to drive indexes.
<li>Enhance the query planner to permit [automatic indexing] on FROM-clause
subqueries that are implemented by co-routine.
<li>Disallow the use of "rowid" in [common table expressions].
<li>Added the [PRAGMA cell_size_check] command for better and earlier
detection of database file corruption.
<li>Added the [matchinfo 'b' flag] to the [matchinfo()] function in [FTS3].
<li>Improved fuzz-testing of database files, with fixes for problems found.
<li>Add the fuzzcheck test program and automatically run this program
using both SQL and database test cases on "make test".
<p><b>Important bug fixes:</b>
<li>Fix [CREATE TABLE AS] so that columns of type TEXT never end up
holding an INT value. Ticket
[https://www.sqlite.org/src/info/f2ad7de056ab1dc9200|f2ad7de056ab1dc9200]
<li>Fix [CREATE TABLE AS] so that it does not leave NULL entries in the
[sqlite_master table] if the SELECT statement on the right-hand side
aborts with an error. Ticket
|
> > > > > > > > > |
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
proc chng {date desc {options {}}} {
global nChng aChng
set aChng($nChng) [list $date $desc $options]
incr nChng
}
chng {2015-00-00 (3.8.11)} {
<li>Added the [FTS5] extension.
<li>Added the [sqlite3_value_dup()] and [sqlite3_value_free()] interfaces.
<li>The [IS operator] is now able to drive indexes.
<li>Enhance the query planner to permit [automatic indexing] on FROM-clause
subqueries that are implemented by co-routine.
<li>Disallow the use of "rowid" in [common table expressions].
<li>Added the [PRAGMA cell_size_check] command for better and earlier
detection of database file corruption.
<li>Added the [matchinfo 'b' flag] to the [matchinfo()] function in [FTS3].
<li>Improved fuzz-testing of database files, with fixes for problems found.
<li>Add the fuzzcheck test program and automatically run this program
using both SQL and database test cases on "make test".
<li>Miscellaneous micro-optimizations result in 22.3% more work for the same
number of CPU cycles relative to the previous release.
SQLite now runs twice as fast as [version 3.8.0] and three times as
fast as [version 3.3.9].
(Measured using
[http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the
[http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on
Ubuntu 14.04 x64 with gcc 4.8.2 and -Os. Your performance may vary.)
<p><b>Important bug fixes:</b>
<li>Fix [CREATE TABLE AS] so that columns of type TEXT never end up
holding an INT value. Ticket
[https://www.sqlite.org/src/info/f2ad7de056ab1dc9200|f2ad7de056ab1dc9200]
<li>Fix [CREATE TABLE AS] so that it does not leave NULL entries in the
[sqlite_master table] if the SELECT statement on the right-hand side
aborts with an error. Ticket
|