History log of /external/sqlite/dist/sqlite3.h
Revision Date Author Comments (<<< Hide modified files) (Show modified files >>>)
3e57a0403387a8b65a23ae6041e16b9eb59ca098 21-Jul-2017 JP Sugarbroad <jpsugar@google.com> DO NOT MERGE - fix FTS3 column pointer handling

Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer()
and use them to transfer the eponymous FTS3 column pointer to the
snippet() and offsets() routines.

Bug: 63852675
Change-Id: I0f0be2bfc21aef8917da63d76d1007fbf8c8ad4d
(cherry picked from commit f856b3209b8c3e62fcb4b2bbc7527d715c9e815e)
/external/sqlite/dist/sqlite3.h
253ed64ded244ef3d8a7226efb812e7989bc8026 23-Dec-2015 Nick Kralevich <nnk@google.com> sqlite: upgrade to SQLite 3.9.2

Downloaded from https://www.sqlite.org/2015/sqlite-amalgamation-3090200.zip

$ sha256sum sqlite-amalgamation-3090200.zip
567139c94375e3808a11f34d81f534d0c257e2c498cddbf4cac283d74b51fe9c sqlite-amalgamation-3090200.zip

dist/orig contains the stock sqlite3 code, as packaged in the ZIP file above.

dist contains a copy of dist/orig, but with the Android.patch file applied.
Please see Android.patch for a list of differences between stock and
Android.

One Android specific patch failed to apply cleanly. However, this patch was
a whitespace only patch, so it has been dropped from Android.patch. All
other android specific patches applied cleanly.

Changes since 3.8.10.2 (from https://www.sqlite.org/changes.html):

2015-11-03 (3.9.2)

* Fix the schema parser so that it interprets certain (obscure and ill-formed)
CREATE TABLE statements the same as legacy. Fix for ticket ac661962a2aeab3c331
* Fix a query planner problem that could result in an incorrect answer due to
the use of automatic indexing in subqueries in the FROM clause of a correlated

2015-10-16 (3.9.1)

* Fix the json1 extension so that it does not recognize ASCII form-feed as a
whitespace character, in order to comply with RFC-7159. Fix for ticket
57eec374ae1d0a1d
* Add a few #ifdef and build script changes to address compilation issues that
appeared after the 3.9.0 release.

2015-10-14 (3.9.0)

Policy Changes:

The version numbering conventions for SQLite are revised to use the emerging
standard of semantic versioning.

New Features And Enhancements:

* Added the json1 extension module in the source tree, and in the amalgamation.
Enable support using the SQLITE_ENABLE_JSON1 compile-time option.
* Added Full Text Search version 5 (FTS5) to the amalgamation, enabled using
SQLITE_ENABLE_FTS5. FTS5 will be considered "experimental" (subject to incompatible
changes) for at least one more release cycle.
* The CREATE VIEW statement now accepts an optional list of column names following
the view name.
* Added support for indexes on expressions.
* Added support for table-valued functions in the FROM clause of a SELECT statement.
* Added support for eponymous virtual tables.
* A VIEW may now reference undefined tables and functions when initially created.
Missing tables and functions are reported when the VIEW is used in a query.
* Added the sqlite3_value_subtype() and sqlite3_result_subtype() interfaced
(used by the json1 extension).
* The query planner is now able to use partial indexes that contain AND-connected
terms in the WHERE clause.
* The sqlite3_analyzer.exe utility is updated to report the depth of each btree and
to show the average fanout for indexes and WITHOUT ROWID tables.
* Enhanced the dbstat virtual table so that it can be used as a table-valued function
where the argument is the schema to be analyzed.

Other changes:

* The sqlite3_memory_alarm() interface, which has been deprecated and undocumented
for 8 years, is changed into a no-op.

Important fixes:

* Fixed a critical bug in the SQLite Encryption Extension that could cause the database
to become unreadable and unrecoverable if a VACUUM command changed the size of the
encryption nonce.
* Added a memory barrier in the implementation of sqlite3_initialize() to help ensure
that it is thread-safe.
* Fix the OR optimization so that it always ignores subplans that do not use an index.
* Do not apply the WHERE-clause pushdown optimization on terms that originate in the
ON or USING clause of a LEFT JOIN. Fix for ticket c2a19d81652f40568c.

2015-07-29 (3.8.11.1)

* Restore an undocumented side-effect of PRAGMA cache_size: force the database
schema to be parsed if the database has not been previously accessed.
* Fix a long-standing problem in sqlite3_changes() for WITHOUT ROWID tables that was
reported a few hours after the 3.8.11 release.

2015-07-27 (3.8.11)

* Added the experimental RBU extension. Note that this extension is experimental
and subject to change in incompatible ways.
* Added the experimental FTS5 extension. Note that this extension is experimental
and subject to change in incompatible ways.
* Added the sqlite3_value_dup() and sqlite3_value_free() interfaces.
* Enhance the spellfix1 extension to support ON CONFLICT clauses.
* The IS operator is now able to drive indexes.
* Enhance the query planner to permit automatic indexing on FROM-clause subqueries
that are implemented by co-routine.
* Disallow the use of "rowid" in common table expressions.
* Added the PRAGMA cell_size_check command for better and earlier detection of database
file corruption.
* Added the matchinfo 'b' flag to the matchinfo() function in FTS3.
* Improved fuzz-testing of database files, with fixes for problems found.
* Add the fuzzcheck test program and automatically run this program using both SQL
and database test cases on "make test".
* Added the SQLITE_MUTEX_STATIC_VFS1 static mutex and use it in the Windows VFS.
* The sqlite3_profile() callback is invoked (by sqlite3_reset() or sqlite3_finalize())
for statements that did not run to completion.
* Enhance the page cache so that it can preallocate a block of memory to use for the
initial set page cache lines. Set the default preallocation to 100 pages. Yields about
a 5% performance increase on common workloads.
* 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 cachegrind on the
speedtest1.c workload on Ubuntu 14.04 x64 with gcc 4.8.2 and -Os. Your performance
may vary.)
* Added the sqlite3_result_zeroblob64() and sqlite3_bind_zeroblob64() interfaces.

Important bug fixes:

* Fix CREATE TABLE AS so that columns of type TEXT never end up holding an INT
value. Ticket f2ad7de056ab1dc9200
* 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 873cae2b6e25b
* Fix the skip-scan optimization so that it works correctly when the OR optimization
is used on WITHOUT ROWID tables. Ticket 8fd39115d8f46
* Fix the sqlite3_memory_used() and sqlite3_memory_highwater() interfaces so that
they actually do provide a 64-bit answer.

Change-Id: Ic59c75950fe54b2ae3a2dabe5fe22f3fb4225e83
/external/sqlite/dist/sqlite3.h
693f9c610b18f09ffe4aaa8f583362481c9e1532 13-Jun-2015 Nick Kralevich <nnk@google.com> sqlite: upgrade to SQLite 3.8.10.2

Downloaded from https://www.sqlite.org/2015/sqlite-amalgamation-3081002.zip

$ sha256sum sqlite-amalgamation-3081002.zip
8272ba79711bf7f64a029d5976ce565ef3fb9bdbbb8b18affdae83d0dd60d61b sqlite-amalgamation-3081002.zip

dist/orig contains the stock sqlite3 code, as packaged in the ZIP file above.

dist contains a copy of dist/orig, but with the Android.patch file applied.
Please see Android.patch for a list of differences between stock and
Android.

All Android specific patches applied cleanly.

Description of changes compared to SQLite 3.8.10:

2015-05-20 (3.8.10.2)
* Fix an index corruption issue introduced by version 3.8.7. An index
with a TEXT key can be corrupted by an INSERT into the corresponding
table if the table has two nested triggers that convert the key
value to INTEGER and back to TEXT again. Ticket 34cd55d68e0
* SQLITE_SOURCE_ID: "2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4"
* SHA1 for sqlite3.c: 638abb77965332c956dbbd2c8e4248e84da4eb63

2015-05-09 (3.8.10.1)
* Make sqlite3_compileoption_used() responsive to the
SQLITE_ENABLE_DBSTAT_VTAB compile-time option.
* Fix a harmless warning in the command-line shell on some versions of MSVC.
* Fix minor issues with the dbstat virtual table.
* SQLITE_SOURCE_ID: "2015-05-09 12:14:55 05b4b1f2a937c06c90db70c09890038f6c98ec40"
* SHA1 for sqlite3.c: 85e4e1c08c7df28ef61bb9759a0d466e0eefbaa2

Change-Id: I60ba181489dc010683f8aabfff37cc7fee17b455
/external/sqlite/dist/sqlite3.h
3a6c79f802fabdb94367177310663397420e319f 08-May-2015 Nick Kralevich <nnk@google.com> sqlite: upgrade to SQLite 3.8.10

Downloaded from https://www.sqlite.org/2015/sqlite-amalgamation-3081000.zip

$ sha256sum sqlite-amalgamation-3081000.zip
b864bf802584e54a881db4ab9c8fb54b51339b2dc2c66f97fbf88ae4ee052ff8 sqlite-amalgamation-3081000.zip

dist/orig contains the stock sqlite3 code, as packaged in the ZIP file above.

dist contains a copy of dist/orig, but with the Android.patch file applied.
Please see Android.patch for a list of differences between stock and
Android.

One Android patch failed to apply cleanly, due to a change in how one
variable is handled. The patch was fixed. Other than that, no changes
to the Android specific patches.

Description of changes compared to SQLite 3.8.9:

SQLite Release 3.8.10 On 2015-05-07

Added the sqldiff.exe utility program for computing the differences between two SQLite database files.
Added the y format string to the matchinfo() function of FTS3.
Performance improvements for ORDER BY, VACUUM, CREATE INDEX, PRAGMA integrity_check, and PRAGMA quick_check.
Fix many obscure problems discovered while SQL fuzzing.
Identify all methods for important objects in the interface documentation. (example)
Made the American Fuzzy Lop fuzzer a standard part of SQLite's testing strategy.
Add the ".binary" and ".limits" commands to the command-line shell.
Make the "dbstat" virtual table part of standard builds when compiled with the SQLITE_ENABLE_DBSTAT_VTAB option.
SQLITE_SOURCE_ID: "2015-05-07 11:53:08 cf975957b9ae671f34bb65f049acf351e650d437"
SHA1 for sqlite3.c: 0b34f0de356a3f21b9dfc761f3b7821b6353c570

(cherrypicked from commit 3d169392f9f40c9a3a1571aa4be8da49ad3c0f8e)

Change-Id: I9d298922ddf405a597781749c8b39caee4ea638b
/external/sqlite/dist/sqlite3.h
3fcd43a0f1ef02756029e12af3cb9ba9faa13364 08-Apr-2015 Nick Kralevich <nnk@google.com> sqlite: upgrade to SQLite 3.8.9

Downloaded from http://www.sqlite.org/2015/sqlite-amalgamation-3080900.zip

$ sha256sum sqlite-amalgamation-3080900.zip
40a9f51a250fc41f6b5053a778681c622d82dec592c85de21edd3640eeb5f093 sqlite-amalgamation-3080900.zip

dist/orig contains the stock sqlite3 code, as packaged in the ZIP file above.

dist contains a copy of dist/orig, but with the Android.patch file applied.
Please see Android.patch for a list of differences between stock and
Android.

No new patches are introduced.

Bug: 20099586
Change-Id: Ic7be6d920698984dee67458678086e88db9a06d3
/external/sqlite/dist/sqlite3.h
9bee60b0fc0b60d4ae9e7533e0e6b7beca5f37fc 21-Aug-2014 Jeff Brown <jeffbrown@google.com> Upgrade SQLite to v3.8.6.

Bug: 15526305
Change-Id: Ib2c187345f845a0f86e25851b7d657c73e9b4ee4
/external/sqlite/dist/sqlite3.h
1c7cea379348522163370244e8fbbff8a136b7fa 07-Jun-2014 Nick Kralevich <nnk@google.com> sqlite: upgrade to SQLite 3.8.5

Downloaded from http://www.sqlite.org/2014/sqlite-amalgamation-3080500.zip

$ sha256sum sqlite-amalgamation-3080500.zip
d9d5a78a5449baa54b2bc62f74f756af81ce74f953f7f0f39aa8b47b2d862029 sqlite-amalgamation-3080500.zip

dist/orig contains the stock sqlite3 code, as packaged in the ZIP file above.

dist contains a copy of dist/orig, but with the Android.patch file applied.
Please see Android.patch for a list of differences between stock and
Android.

Change-Id: I675bc26116b8f02aa3ce841e48fa2ef940ffbe61
/external/sqlite/dist/sqlite3.h
8fecf56c625b5691ee3381e107ccbe1ff42398b1 30-May-2014 Nick Kralevich <nnk@google.com> sqlite: upgrade to SQLite 3.8.4.3

Downloaded from http://www.sqlite.org/snapshot/sqlite-amalgamation-201405271818.zip

$ sha256sum sqlite-amalgamation-3080403.zip
8bac4a9cf70270ca514db9b740e0950e7fca0c656119b42454376b7d5769b3d8 sqlite-amalgamation-3080403.zip

dist/orig contains the stock sqlite3 code, as packaged in the ZIP file above.

dist contains a copy of dist/orig, but with the Android.patch file applied.
Please see Android.patch for a list of differences between stock and
Android.

Bug: 15288755
Change-Id: I05f0c302ecb0e6c251cbe8c888f07cf2e0498855
/external/sqlite/dist/sqlite3.h
c82acac4e67711e8d9289b572d334298aeb5d806 20-Apr-2012 Jeff Brown <jeffbrown@google.com> Upgrade to SQLite 3.7.11.

Bug: 6176510
Change-Id: I482e980b3377a9606fc23e72fd25d0c648f718d4
/external/sqlite/dist/sqlite3.h
e667f09e2450fbe896a8faadf8ba534094dce7e5 20-Jan-2012 Jeff Brown <jeffbrown@google.com> Remove custom SQLITE_UNCLOSED error code.

This error code was introduced at some point to help track when
a database could not be closed because a statement was not finalized.
Now that the DB wrappers have been rewritten, it is technically no longer
possible for this to happen, so we can remove this.

Change-Id: Ia3c8167a0af522c852adbbd15c83c3c8f5732b26
/external/sqlite/dist/sqlite3.h
90ed05d921d6ed7f12012d9786d53f57fafee51a 20-Jan-2012 Jeff Brown <jeffbrown@google.com> Upgrade SQLite to 3.7.10.

Ported all original Android-specific patches.

Change-Id: I2c5801a92d783e2c5cba72147d9fb777ad7c8443
/external/sqlite/dist/sqlite3.h
6620e5283fe46ea3561525133d97f009bab7658d 25-Feb-2011 Vasu Nori <vnori@google.com> more sqlite logging and handling of EINTR

Change-Id: Iecba43846cb2eef28261303043484f142a67f924
/external/sqlite/dist/sqlite3.h
eadd0b9d4c7c73acc90491f7408fc0061cd2b1a7 20-Feb-2011 Vasu Nori <vnori@google.com> bug:3353077 posible fix from sqlite authors..

downloaded from
http://www.sqlite.org/sqlite-amalgamation-374-201102200340.zip
Change-Id: Ia82628469b4c3646e0964934178b60fa7083ee76
/external/sqlite/dist/sqlite3.h
95c34edce550d0869113085e0cd1b6b09e8fe38b 05-Jan-2011 Vasu Nori <vnori@google.com> latest and stable version of sqlite

this most probably will be sqlite for HC - unless some serious bugs come up
with this version.
Change-Id: Ib7d9023c861025fd28492ae133d21fc479c0c891
/external/sqlite/dist/sqlite3.h
de2b3240539802d409a25760d5cec9d4ebfd6686 30-Sep-2010 Vasu Nori <vnori@google.com> latest sqlite version from http://www.sqlite.org/draft/download.html

Change-Id: Ie6f1f5aaa1c3fe73af0fd71be5e749c1544ad684
/external/sqlite/dist/sqlite3.h
5b048aea8927cc0747debab2c0c5b618d9871985 04-Sep-2010 Vasu Nori <vnori@google.com> when dbclose fails, raise specific error from sqlite

the current error raised by sqlite - SQLITE_BUSY - is not helpful

Change-Id: Idbeed81b5b7349059e467b33a8641abf0b4aaeff
/external/sqlite/dist/sqlite3.h
ebc6b24ff37b903195b37f143a5791c9f02be8df 07-Jul-2010 Vasu Nori <vnori@google.com> latest sqlite with fix for WAL-caued corruption

Change-Id: I40056f72e4eecf8cbc39d91933cc604ab0c361c1
/external/sqlite/dist/sqlite3.h
176bf03af2edfb2a45b66dcb5daf822cc50c499e 29-Jun-2010 Vasu Nori <vnori@google.com> latest sqlite WAL code with fix for schema changes bug

Change-Id: I6ceffb2b2513de699774483b5e75d7a5dfedb9df
/external/sqlite/dist/sqlite3.h
71504cf29d6d55df7d2aac17ecb160f7e5470553 17-Jun-2010 Vasu Nori <vnori@google.com> sqlite with write-ahead-logging changes. alpha/beta quality

note to reviewers: this checkin is to see if write-ahead-logging
could work for android. this sqlite3 version still has bugs
but still checking in - to start testing the feature.

Change-Id: Ic401c78299e88fa864fe1adb345268b12457cac0
/external/sqlite/dist/sqlite3.h
d86d9905ede0a2a313e349e4d0b4ba43b64cf8c3 16-Jun-2010 Jim Shuma <jshuma@google.com> Revert "sqlite3 write-ahead-logging. alpha/beta quality code being checked-in"

This reverts commit 187750b12c5011b4ebfb35e76c12d50a52047227.
/external/sqlite/dist/sqlite3.h
187750b12c5011b4ebfb35e76c12d50a52047227 15-Jun-2010 Vasu Nori <vnori@google.com> sqlite3 write-ahead-logging. alpha/beta quality code being checked-in

why am I checking in alpha quality code? this is one of the latest code
drops from Richard Hipp (of sqlite.org) who is still developing this feature.
testing this feature to see if it will work for us.

Change-Id: Id64f1c5718cdaa04a8194bd7eeb374027c6c2cb0
/external/sqlite/dist/sqlite3.h
ebcc71fd53ce7cf46aff607df2d4bff793837176 23-Mar-2010 Vasu Nori <vnori@google.com> apply couple of bug fixes from sqlite

applying the following bug fixes
http://www.sqlite.org/src/info/82dd61fccf
Sync the database file after a rollback
http://www.sqlite.org/src/info/6f368b5448
Modify the sqlite3_log() interface and implementation so that it never
uses dynamic memory allocation - to avoid deadlocking when called
while holding the memory allocator mutex.

Change-Id: I93929d2dacd399ae9bd291404bcdf2c512691254
/external/sqlite/dist/sqlite3.h
049406b944167376e8973451e6a02846f26daaf3 03-Mar-2010 Vasu Nori <vnori@google.com> merge vacuum bug fix from http://www.sqlite.org/src/info/e534223435
/external/sqlite/dist/sqlite3.h
aae12b8a5af3a1ac77382b067d9ebb350fbd0644 02-Mar-2010 Vasu Nori <vnori@google.com> take # 2: update sqlite. now it builds on Mac also.

this is redoing the reverted CL
https://android-git.corp.google.com/g/#change,42672
/external/sqlite/dist/sqlite3.h
9d9edcf91e6d39f940ba1740956a12c0aef52334 02-Mar-2010 Vasu Nori <vnori@google.com> revert to old ersion until sqlite3.c builds correctly on mac

sqlite3 from DRH broke mac builds.
/external/sqlite/dist/sqlite3.h
cd1b5450506dc71940b94bc7f5a74c1cc29bb7da 26-Feb-2010 Vasu Nori <vnori@google.com> get latest sqlite from froyo branch created by richard hipp @ sqlite

this will remove a lot of android specific code from sqlite in
external/sqlite/dist.
we are getting closer to using the public domain sqlite.
******* NOTE TO REVIEWERS *********
to compare, don't use gerrit. that will compare this sqlite3.c with
the currently-checkin version, showing you the differences
between this sqlite version and the previous sqlite version.
you may not care about that.
if you just need to see what android changes to sqlite are,
then compare the following two files in this CL
sqlite3.c.orig
sqlite3.c
/external/sqlite/dist/sqlite3.h
a4356a0ea71404ae414a07eafd7b95b91cc88c8c 21-Jan-2010 Vasu Nori <vnori@google.com> upgrade sqlite from 3.5.9 to 3.6.22

you should notice the following from the Android changes in 3.5.9
1. Android Changes are grouped wherever possible.

To Do
1. sqlite3_get_pager_stats() needs to be completed
2. Android change lines 63480-63482 on master branch in sqlite3.c is
not ported yet. can't see where it goes in 3.6.22 code.
/external/sqlite/dist/sqlite3.h
7790ef5367fe6731048c3e3a1c067f94b321cb4d 04-Mar-2009 The Android Open Source Project <initial-contribution@android.com> auto import from //depot/cupcake/@135843
/external/sqlite/dist/sqlite3.h
9764acebd9bd23a5e72932accc18cbe31b47ee57 04-Mar-2009 The Android Open Source Project <initial-contribution@android.com> auto import from //depot/cupcake/@135843
/external/sqlite/dist/sqlite3.h
6005ac625aa553fe461b363385a8ed4a3c217a1f 21-Oct-2008 The Android Open Source Project <initial-contribution@android.com> Initial Contribution
/external/sqlite/dist/sqlite3.h
6ca1d4f32da73eda41ba4925e98de4411cbe75d3 12-Jan-1970 Upstream <upstream-import@none> external/sqlite 3.6.3
/external/sqlite/dist/sqlite3.h