database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-24 22:22:08 +03:00
Code Activity
30,154 Commits 1,566 Branches 182 Tags
empty-table-optimizations
Commit Graph

5135 Commits

Author SHA1 Message Date
dan
5289b01524 Modify fts3rnd.test to run tests for both "ORDER BY docid ASC" and "ORDER BY docid DESC" with both order=ASC and order=DESC FTS tables. Fixes for some bugs found. 
FossilOrigin-Name: 89f2f482e077241ac29a58eadf44a72a9c01f98c
 2011-06-06 14:51:50 +00:00
dan
9aab071780 Clean up the code for processing FTS4 options a bit. 
FossilOrigin-Name: 0425138a2365d23b07d88fda2b1f458f112f389d
 2011-06-06 06:55:38 +00:00
dan
76e04431ef Remove some unreachable code. 
FossilOrigin-Name: 650e1a79eda5a2134a1fbd305ab1f205a57c0892
 2011-06-04 20:13:24 +00:00
dan
b46ee91729 Allow the "order=DESC" and "order=ASC" parameters in FTS4 "CREATE VIRTUAL TABLE" statements. Tables created with "order=DESC" store all doclists in descending order, which allows optimizations normally applied to "ORDER BY docid ASC" queries to be used with "ORDER BY docid DESC" queries instead. 
FossilOrigin-Name: f6a0193f5a32603eb48bddc6297042dbd2ffe96e
 2011-06-04 20:04:35 +00:00
dan
126ba6c0ac FTS changes: Remove unreachable code. Fix bugs. When processing a large doclist incrementally, read from disk incrementally too. 
FossilOrigin-Name: a4c7e2820824e82580730c36f85aede2efa66754
 2011-06-03 18:00:19 +00:00
dan
e414854800 Changes to improve performance and support LIMIT clauses on fts3 tables. This branch is unstable for now. 
FossilOrigin-Name: 28149a7882a1e9dfe4a75ec5b91d176ebe6284e9
 2011-06-02 19:57:24 +00:00
drh
bf0ed47d82 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 832886b1e6edb916d9824924c7d88202f4eb1969
 2011-05-30 13:39:20 +00:00
dan
382874fc5c Minor changes made while planning a larger change. 
FossilOrigin-Name: 84097a4c759b1d65890af885f137d3cb16eef584
 2011-05-28 15:57:40 +00:00
drh
7ee4fdd7ba Fix some minor and harmless compiler warnings. 
FossilOrigin-Name: a4755e7088c3cc7c5ea191ce37f3950472f523ec
 2011-05-25 23:18:02 +00:00
dan
98b08e71f2 If a prefix index of size N is not present, use a prefix index of size N+1 along with the terms index for queries for prefixes of length N. 
FossilOrigin-Name: cc83991caae7c7d647432d5711b6cd80228c3002
 2011-05-25 19:17:32 +00:00
dan
73ae6e5e76 Merge trunk changes into experimental fts3-prefix-search branch. 
FossilOrigin-Name: f0f0a03db214b68a37069f64c27ae8520220c900
 2011-05-25 18:47:26 +00:00
dan
9d1f874ab3 Change fts4 so that the prefix= parameter is passes a comma-separated list of integers. For each integer N, a separate index of all prefixes of length N bytes is created. 
FossilOrigin-Name: be59bf49402d2e2f4b95fb6668849f3745cb7bf2
 2011-05-25 18:34:53 +00:00
drh
346506f97b Changes to savepoint in virtual tables for simpler and more consistent 
operation.

FossilOrigin-Name: 92f26a8b8f18832cb1f8ba7dd8e5b020e71a5883
 2011-05-25 01:16:42 +00:00
dan
09643ab745 If the fts4 option prefix=1 is specified, have the fts4 module maintain an index of prefixes as well as terms. 
FossilOrigin-Name: b5bdc639898ee22eebedeb560810e94e74de8aa4
 2011-05-24 18:49:45 +00:00
drh
e485522462 Do not invoke the xRollbackTo or xRelease methods of a virtual table without 
having first invoked an appropriate xSavepoint method.  Add assert() statements
to FTS3/4 to verify that this is happening in all cases.

FossilOrigin-Name: 651ef24249d8c22c4f13e4c0bb98a60099cfd23a
 2011-05-24 15:36:01 +00:00
drh
4ec233f12a Merge all the latest trunk changes into the sessions branch, especially 
the disappearing WAL transaction fix.

FossilOrigin-Name: 5b1b536cf828850d0e8ac2ab08e8696082715877
 2011-05-19 02:48:46 +00:00
dan
133d7dab17 Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent. 
FossilOrigin-Name: 8844e8bfb87314fb40ecb92705e8fff88f72bb38
 2011-05-17 15:56:16 +00:00
dan
807d0fcaba Avoid including fts3_term.c in the amalgamation, as it contains test code only. 
FossilOrigin-Name: f392b7ae0266b4c694836583cb91b10f2b6c0752
 2011-05-17 14:41:36 +00:00
drh
e578b5967c Increase the iVersion for sqlite3_module needed for the xSavepoint, 
xRelease, and xRollbackTo methods from 1 to 2.  This is so that it will
conform to published documentation.

FossilOrigin-Name: 0f4954e9793332573d4ffa0c1e199180f4cb990a
 2011-05-06 00:19:57 +00:00
drh
0576a30dad Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 6883580e6c8973010a42d1d2c5bde04c6b2f4eb7
 2011-05-05 15:46:16 +00:00
dan
7b0ced74c0 Merge vtab-conflict branch with trunk. 
FossilOrigin-Name: 8f9666af5f9459cbd0305a86281d745ea6163acf
 2011-05-04 17:23:19 +00:00
dan
62d6c7e32b Fix a couple of compiler warnings in the FTS code. 
FossilOrigin-Name: 1a113359705d307efa1833b1dfa5542b045dae43
 2011-05-04 16:30:05 +00:00
dan
e1c8e13bf6 Fix a performance problem in queries that use "ORDER BY rowid DESC" and one or more FTS auxiliary functions. 
FossilOrigin-Name: 95e09b20e9aad28f829c8950f3632debe473070a
 2011-05-04 15:41:18 +00:00
dan
0f599faa29 Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables. 
FossilOrigin-Name: 13395121e3d17ab6581dc5f6736ea324321a374c
 2011-05-04 12:52:59 +00:00
dan
c6055c7374 Have r-tree virtual tables support on-conflict clauses. 
FossilOrigin-Name: 822ab52f1023b1c4973c806cc75454acd4e95fd0
 2011-04-28 18:46:46 +00:00
dan
3480a01dad Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index. 
FossilOrigin-Name: abdd70ae0424ccadb7edaf16e970c78b5257d23c
 2011-04-27 16:02:46 +00:00
dan
a311b80392 Extra tests for fts3. And fixes for conflict-handling related problems in fts3. 
FossilOrigin-Name: fb4a355871d9482ccb28b6ba03b842b3cc87b696
 2011-04-26 19:21:34 +00:00
dan
b061d058cb Add support for on conflict clauses to fts3/fts4. 
FossilOrigin-Name: 6d2633a6d0a9bb88fb1a6adac0827dc51df2d4d2
 2011-04-25 18:49:57 +00:00
dan
355c53b6ef Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer. 
FossilOrigin-Name: 0dd09fc034c127718366d3a3183e367d2f9fd82d
 2011-04-19 06:43:22 +00:00
dan
77fc1d5bb4 Fix further missing comments and other minor issues in the session module code. 
FossilOrigin-Name: 99f0f35092b0b78b7016b21c242da263ab64b77b
 2011-04-18 15:47:08 +00:00
dan
798693b2b1 Fix some missing comments and other issues with session module code. 
FossilOrigin-Name: 20d7c280235201e519f296372f269e7cecda24da
 2011-04-18 12:05:03 +00:00
dan
80fe2d9310 Further coverage tests for the session module. 
FossilOrigin-Name: 69a01c708bf044eacf21a8951fe9e7d9fb4332c5
 2011-04-18 07:36:27 +00:00
dan
6734007d75 Improve test coverage of session module. 
FossilOrigin-Name: f46d4b641d613c39a80b12106e6a6ac0efc8be83
 2011-04-16 19:23:10 +00:00
dan
b08a1efae5 Improve coverage of session module. 
FossilOrigin-Name: 3dfd1d63bddfa9bd9018eb00bee1d496379630b5
 2011-04-15 19:18:57 +00:00
dan
1756ae10e1 Add tests and fixes for OOM handling in sqlite3changeset_concat(). 
FossilOrigin-Name: df0b2d21dcd81679e55b24866f97568019932983
 2011-04-15 16:03:32 +00:00
dan
f29123b572 Have sqlite3changeset_concat() return SQLITE_SCHEMA if an attempt is made to concatenate changesets based on incompatible database schemas. 
FossilOrigin-Name: 343b64517d244b75097e38342dc273eb5a52915b
 2011-04-15 15:04:31 +00:00
dan
29e03e977c Add documentation for sqlite3changeset_concat() to sqlite3session.h. 
FossilOrigin-Name: ada9efa53a6ea55f89d237cfd530f1d180343e19
 2011-04-15 12:04:50 +00:00
dan
6cda207f5f Add further tests for the sqlite3changeset_concat() function. Also fixes. 
FossilOrigin-Name: 1fc3f15d88c160b45642b46d1d54c591af058ba2
 2011-04-14 18:01:41 +00:00
dan
5d607a6e06 Start adding the sqlite3changeset_concat() function to the session module. 
FossilOrigin-Name: 8927b2260b8d84f53776cb29e1d2fa41b6b0de0e
 2011-04-14 11:16:21 +00:00
drh
36828bd9bb Add a missing "extern C" terminator to the end of sqlite3session.h. 
FossilOrigin-Name: 29090b695a95feaba1b74f9894997083a060263a
 2011-04-06 23:40:28 +00:00
drh
cfdbde214b Fix VC++ compiler warnings. 
FossilOrigin-Name: 7b7c8d366c51e89aefc6efc9dcffe3f62c7e1d25
 2011-04-06 23:39:28 +00:00
drh
d7162fa64e Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 45f20261720dcd73eb887f7e3df100723000418b
 2011-04-05 22:13:49 +00:00
drh
fcd71b6010 Suppress many harmless compiler warnings, mostly signed/unsigned comparisons 
within asserts or unused parameters in extensions.

FossilOrigin-Name: 3eeb0ff78d04891b5fd1a3d99a9fb8cfbed77a81
 2011-04-05 22:08:24 +00:00
dan
5d8a298495 If the sessions module is being built as part of the amalgamation, do not try to include sqliteInt.h and vdbeInt.h. 
FossilOrigin-Name: f87bfe6e12093e5958b658a49d3766fb29562cbb
 2011-04-01 15:30:39 +00:00
drh
9b1c62d416 Add the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. 
FossilOrigin-Name: 6634521461e6acff7cc778590e62d57831f9230d
 2011-03-30 21:04:43 +00:00
dan
e5754eec26 Improve coverage of session module a bit more. 
FossilOrigin-Name: 4255a9f609c4fd43582a0874143eabe211199726
 2011-03-25 19:06:09 +00:00
dan
f51e5f6c99 Improve coverage of session module code. 
FossilOrigin-Name: 666123c8d07be87d477e67b1cebef2b0fba5b4bc
 2011-03-25 10:52:01 +00:00
dan
a9605b9125 Fix handling of schema changes mid-session. 
FossilOrigin-Name: 76d2d2ad3b2a5171393b7894f35f463ff284e53b
 2011-03-24 16:53:57 +00:00
dan
ca62ad57f0 Fix handling of schema mismatches in sqlite3session.c so that it matches the docs in sqlite3session.h. 
FossilOrigin-Name: 506a0d7a710e1ff2f367821e73f5080fcf63fbc5
 2011-03-24 16:04:54 +00:00
dan
244593c846 Store primary key definitions for modified tables in changesets. Add the sqlite3changeset_pk() API to extract this data from a changeset iterator. 
FossilOrigin-Name: 54298ee5ed183d1f1c49524f25e8ae1407f3d4b5
 2011-03-24 11:22:59 +00:00