database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
30,201 Commits 1,570 Branches 184 Tags
wasm-build-parallel
Commit Graph

5163 Commits

Author SHA1 Message Date
dan
48eecfb8b9 Support "ORDER BY rowid ASC". 
FossilOrigin-Name: b96b5e166990e4ec363b24f66e04cfa5f00f6342
 2014-07-10 20:21:12 +00:00
dan
a2b569f955 Add support for prefix queries to fts5. 
FossilOrigin-Name: 75ebd3cd5904a4f89f7f3a9b25d32b2a42a31310
 2014-07-08 16:27:37 +00:00
mistachkin
166c373779 Fix harmless compiler warnings in the fts3view utility program that can occur with MSVC. 
FossilOrigin-Name: 1cec1e030035e5253fb7ebbdfe5c1a3029e4e29b
 2014-07-07 18:03:38 +00:00
drh
42d3d37ad1 Fix a division-by-zero error in the fts3view utility program. Add the 
fts3view utility program to the "main.mk" makefile.

FossilOrigin-Name: 64f02699b4bd747e4c2f0debf72d37ec275137d8
 2014-07-07 16:07:43 +00:00
dan
103576dd75 Add support for AND, OR and NOT to fts5. 
FossilOrigin-Name: 8682b87e794767cefcaa080fd53c8973c24c556a
 2014-07-05 15:15:41 +00:00
dan
c2642d7c1e Add support for the "colname : <nearset>" syntax to fts5. 
FossilOrigin-Name: 004667106e552e832a564b77e242b86f183d4441
 2014-07-05 07:54:01 +00:00
dan
c18a8fe99c Add support for NEAR expressions to fts5. 
FossilOrigin-Name: 250ae8d40115e2e47cc5a1e8a427fa8c0a89124d
 2014-07-03 20:39:39 +00:00
dan
2eaf03d72b Change fts3/4 so that the "unicode61" is included in builds by default. It may now be excluded by defining SQLITE_DISABLE_FTS3_UNICODE. 
FossilOrigin-Name: 0cc0230ae9cfc9760fd8ef2c25e82576b052dbeb
 2014-07-03 12:18:22 +00:00
dan
1dfacb4675 Add support for phrase queries to fts5. 
FossilOrigin-Name: 2e5652e6526b8fb3f5c163168d95bc0bb4c93686
 2014-07-02 20:18:49 +00:00
dan
acf6642819 Change the position list format so that its size in bytes is stored at the start of the list itself. 
FossilOrigin-Name: 62f2ff20418702ed0fbf708369edf5638445b51b
 2014-07-01 20:45:18 +00:00
drh
f257b4c613 Merge the latest trunk enhancements into the sessions branch. 
FossilOrigin-Name: a5d94eaba6aa12ff16d2a0af2fc752bcdb461877
 2014-06-30 20:02:55 +00:00
dan
e369fe4352 Fix minor problems in term matching. 
FossilOrigin-Name: 94eeb077d08a1d2607f3ff3a9fbf18229ba475bb
 2014-06-26 12:31:41 +00:00
dan
22d43ec4e8 Begin adding query support to fts5. 
FossilOrigin-Name: 47a9f3cc92deefe163108e3507bd4614bf1f5da7
 2014-06-25 20:28:38 +00:00
dan
d0bfb36a08 Add simple full-table-scan and rowid lookup support to fts5. 
FossilOrigin-Name: 3515da85d09220c464979467b476c611da4a6a7a
 2014-06-24 16:59:06 +00:00
dan
e0fa4107c2 Add some code for an experimental fts5 module. Does not work yet. 
FossilOrigin-Name: 1e0648dcf283d4f1f6159db4d2433b6cc635992e
 2014-06-23 11:33:22 +00:00
drh
9740726121 A different approach to the autoindex problem that deletes query-planner code 
rather than adding it.

FossilOrigin-Name: f270fb6e9e0b5e77f918081962008c6195ab1e36
 2014-06-17 12:33:55 +00:00
drh
6b7ff748a1 Allow an automatic index on a WHERE constraint where the RHS is does not 
reference another table as long as the RHS is not a constant.

FossilOrigin-Name: 58acc2a8b38c5f13175c191697b4d2b663db1872
 2014-06-17 09:00:54 +00:00
drh
a2412c1613 Fix the extension01.test script so that it works on windows. Fix a 
harmless compiler warning in the fileio extension.

FossilOrigin-Name: baf95a190907d05a847ae8b6a3dd60625c2a078a
 2014-06-16 12:51:56 +00:00
drh
40e75cb6f6 Add the fileio.c loadable extension, that implements readfile() and writefile() 
SQL functions.

FossilOrigin-Name: 0ca104d821d5841ab0754113be074c520cf07f23
 2014-06-13 13:43:25 +00:00
drh
0b93058b0e Add an extension that implements compress() and uncompress() SQL functions. 
FossilOrigin-Name: d5c17d1a423321f766616d82c9b27ef87c1d5afd
 2014-06-13 13:08:21 +00:00
dan
33b7bcb319 Fix a problem that was causing the FTS4 integrity-check command to fail if the table had one or more "notindexed" columns. 
FossilOrigin-Name: 7123bb2605216396f65db5d156431b3613f313b5
 2014-06-05 11:15:56 +00:00
drh
cbabb20390 Merge trunk changes into the sessions branch. 
FossilOrigin-Name: 9f18e78f039ffa89a8806810ad385bdc51bc88ed
 2014-05-29 20:29:13 +00:00
drh
3c559a8d3c Fix harmless compiler warnings. 
FossilOrigin-Name: 20b75460c0661b5dc071177b4a0791aceccda029
 2014-05-27 19:18:36 +00:00
drh
b7231a8cf0 Fix a harmless compiler warning in the FTS4 logic. 
FossilOrigin-Name: 64a869ad2388d9d62601b93d5139f2dc57f260f7
 2014-05-27 11:54:48 +00:00
drh
aff0fbb6a5 Merge recent trunk changes into the sessions branch. 
FossilOrigin-Name: a769c7e03e6d4163986d49652687de34d15906a0
 2014-05-26 20:00:00 +00:00
dan
cde81d5fd0 Fix a problem in FTS4 where columns with names that are prefixes of any notindexed column were also being (incorrectly) marked as not indexed. For example in "CREATE ... t1(abc, bc, abcd, notindexed=abcd)", both abc and abcd were being treated as notindexed. 
FossilOrigin-Name: d90c4964fcf46b0b043dbfd58267098582267001
 2014-05-26 16:40:02 +00:00
drh
d963982049 Merge recent trunk changes into the sessions branch. 
FossilOrigin-Name: 2d33afe0c43cb99caa521c48b721c3b0971e967c
 2014-05-20 00:20:23 +00:00
mistachkin
02c1e264a9 Fix harmless compiler warnings. 
FossilOrigin-Name: 7e60347e21a7473974061965a8d1f2eadde987e2
 2014-05-16 23:38:59 +00:00
dan
a7b9e7d2d9 Fix a bug causing an incorrect segment size value to be stored if both an old and new FTS version performed work on the same incremental merge operation. 
FossilOrigin-Name: a9a2aeab298ba2ac0b8835e61406e2d83bf7e39b
 2014-05-16 10:30:44 +00:00
dan
157c957a65 Fix a problem with the handling of delete markers by automerge on large databases. 
FossilOrigin-Name: 2b09bd17eb85ea3c682e930d2aabc6441f2265e0
 2014-05-15 18:36:39 +00:00
dan
5b34f15a82 Do not search for promotable segments following an FTS 'optimize' operation or creation of a new segment on the oldest existing level. 
FossilOrigin-Name: 34f6b4b8e4cb8ea45fd518672dc96335d1ce06ab
 2014-05-14 19:49:17 +00:00
dan
a0b7ca90b7 Fix a problem to do with loading the value of the FTS automerge setting from the database. 
FossilOrigin-Name: 7268119f74602929b372b88eca7b3c3b4964f7d5
 2014-05-14 18:45:27 +00:00
dan
9e83e465eb Fix various problems to do with segment promotion. Add test file fts4growth2.test, containing tests to check that the FTS index does not grow indefinitely as the table is updated. 
FossilOrigin-Name: 21491a9bc686e63bec32f1a67103622f1160a2f9
 2014-05-14 15:58:47 +00:00
dan
c0caea21de Fix a problem preventing delete markers from ever being removed from the FTS index. 
FossilOrigin-Name: 7f47ae5c5ddb1227484ddae7c6960183932a052a
 2014-05-13 20:11:37 +00:00
dan
6bb9889ef0 Experimental code to prevent FTS indexes from growing indefinitely as the table is updated. 
FossilOrigin-Name: b3b505a4dd0c679437a4272109f1188175088cd1
 2014-05-12 20:04:48 +00:00
dan
d2d8ca600e Fix the way parenthesis in MATCH expressions are handled by FTS if the tokenizer considers them to be token characters. 
FossilOrigin-Name: e21bf7a2ade6373e94ea403c665f78e1ad22143f
 2014-05-07 19:59:36 +00:00
drh
65e6b0dd12 Add the sqlite3_rtree_query_callback() API to the RTree virtual table. 
(Cherrypick from the sessions branch.)

FossilOrigin-Name: af2cbe64adab5f9e3b0f3da00d06428088589d7f
 2014-04-28 17:56:19 +00:00
drh
c686929914 Enhance the sqlite3_rtree_query_info object to report on the number of 
elements in the priority queue at each level.

FossilOrigin-Name: f7dad408dd46a1e3612b6142a3afb1d0d4fcda00
 2014-04-25 16:29:03 +00:00
drh
98cf9d74f8 Fix the generation of sqlite3_rtree_query_info.iRowid and add test cases 
to verify that it is fixed.

FossilOrigin-Name: eba95ead49f8f8ce45d400186562ff0066537c5c
 2014-04-21 18:13:37 +00:00
drh
74188329ce Be sure to initialize the sqlite3_rtree_query_info.iRowid field for the 
leaves of the R-Tree when doing a query callback search.

FossilOrigin-Name: 4394693882c04c19ebe87ef7547c57e679554397
 2014-04-21 15:53:45 +00:00
drh
a6ca7f2c1b Fix an off-by-one error in setting the "iLevel" field of the 
sqlite3_rtree_query_info structure passed into the RTree query callback.

FossilOrigin-Name: d708f159abfb3b87e2844463088d4fb7f8da9c97
 2014-04-21 15:21:19 +00:00
drh
ec7c03a08b Further improvements to the RTREE_DECODE_COORD() method, to take advantage 
of known processor byte orders when available.  This makes the code 3% faster,
according to valgrind.  Also add test cases to make sure the on-disk
representation is correct.

FossilOrigin-Name: 6f3e94f4b1b403cd7bfc5e8e0ffbd61b5174d3a4
 2014-04-18 01:37:08 +00:00
drh
a5db90fc8e Performance optimization on byte-swapping in R-Tree. 
FossilOrigin-Name: 444084fd620fc3f45cfb87b83f532d76bd2744e7
 2014-04-17 23:23:29 +00:00
drh
1821cbacf1 More test cases with very long priority queues. 
FossilOrigin-Name: 71692aa97c78676f0ba80eaeec0ad9ac225f4427
 2014-04-17 15:34:58 +00:00
drh
b640595f97 Test cases and bug fixes for the sqlite3_rtree_query_callback() 
mechanism.

FossilOrigin-Name: 1ccaaed6b516ec2ce953c1b31025a82ba76d00e7
 2014-04-17 14:52:20 +00:00
drh
78b486ea12 Refactor the constraint checking logic in RTree. The new-style constraint 
callbacks created by sqlite3_rtree_query_callback() are now hooked up from
end to end, though still untested.

FossilOrigin-Name: 32a13870175a1dd1d33af3572dde09ff607a04b6
 2014-04-17 13:15:33 +00:00
drh
18b5142b29 Performance optimization on nodeGetCell() in R-Tree. 
FossilOrigin-Name: 5d20ff9ec837ad35bc44d6c25d13764b350e81dd
 2014-04-16 21:02:28 +00:00
drh
933a5ff2d4 TCL tests now all pass. 
FossilOrigin-Name: f864baccd3fe0ee939ac1ec20069792f649cddc0
 2014-04-16 17:15:14 +00:00
drh
ab908cfcb4 Fix a bug in rowid=? query handling. More problems remain. 
FossilOrigin-Name: 5b0e6ba4a5050cf81cf41b977b28d714163569e0
 2014-04-16 14:45:11 +00:00
drh
f247982e37 Bug fixes to the priority-queue implementation for R-Trees. Improved tracing 
capability.  Some queries work now, but still many problems.

FossilOrigin-Name: a439ddd629c6bb5ea2e7e274673fee4f5c207acf
 2014-04-16 13:00:08 +00:00