database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
12,361 Commits 1,785 Branches 392 Tags
save_sorter_stmt
Commit Graph

4743 Commits

Author SHA1 Message Date
dan
937490d4b4 Add further tests for the extension APIs with "ORDER BY rank" queries. 
FossilOrigin-Name: 37a417d27e4ebafd4783f62728d7467316b75b17
 2014-07-31 11:57:59 +00:00
dan
3fc4a856a2 Fix things so that the fts5 extension API works with "ORDER BY rank" queries. 
FossilOrigin-Name: f1b4e1a98d49ecaba962beba16f8224175e4ba59
 2014-07-30 20:26:24 +00:00
dan
fdb4a30af2 Add hidden column "rank". Currently this always returns the same value as the bm25() function. 
FossilOrigin-Name: 4cc048c3651e830a6aeded924c7f3a60b634e133
 2014-07-30 19:41:58 +00:00
dan
454b5ce524 Add tests and fixes for bm25() function. 
FossilOrigin-Name: 71d32f53e81921e43c933cc968cb1c18d83fe1e0
 2014-07-26 18:38:51 +00:00
dan
700b33d7a5 Add extension apis xRowCount, xQueryPhrase, xSetAuxdata and xGetAuxdata. And a ranking function that uses all of the above. 
FossilOrigin-Name: c4d50428ab97f77e6721c4f8d03eaaf3ea91f3eb
 2014-07-25 20:30:47 +00:00
dan
b30860abe2 Add a snippet() function to fts5. 
FossilOrigin-Name: bdc58fd28a63ac9632c3df6c7768a9a236566605
 2014-07-23 19:31:56 +00:00
dan
a5983da6e1 Fix DELETE and UPDATE operations on fts5 tables. 
FossilOrigin-Name: d44d3a8518ff7a1a3e2c0ab97493aa590676ee8c
 2014-07-21 15:45:26 +00:00
dan
5c1b820460 Add the xTokenize extension API. 
FossilOrigin-Name: 8c6b0aff3443fae4b7f0b9adcbf1514992b70653
 2014-07-21 14:22:38 +00:00
dan
84d6fb394f Fix the xColumnSize() extension API. 
FossilOrigin-Name: 19504c4108472d2ad1281221642b8bd06eb69f4e
 2014-07-21 11:44:47 +00:00
dan
e1c77bcfcd Add simple tests for the xColumnText() extension api. 
FossilOrigin-Name: 1e9053abdaf5e128d44504ee00dfd909dc25f378
 2014-07-19 20:27:54 +00:00
dan
4a165c0af4 Fixes for the xColumnSize() fts5 extension API. 
FossilOrigin-Name: 43fcb844726cfeeb1c8a0dbfaa0d2ca22e6ac16c
 2014-07-19 15:35:09 +00:00
dan
30b650e2f4 Fix issues with position lists and NEAR constraints. 
FossilOrigin-Name: 16352d3654d5672cd0251db51dbe19f779373feb
 2014-07-18 19:59:00 +00:00
dan
c5b44f3d90 Fix a problem with position list processing for OR queries. 
FossilOrigin-Name: 5808f30fae0d844c52a785bf18872be371d4af68
 2014-07-17 15:14:07 +00:00
dan
18689f1bd4 Fixes for tcl list generation in fts5_test(). 
FossilOrigin-Name: c1f9a4b76c0bbc1ef9f6cdb5d62aa5d536fdf38e
 2014-07-16 20:07:59 +00:00
dan
9cfd51f587 Begin adding interface for auxiliary functions. 
FossilOrigin-Name: 1e2a7ba0889093416455f488fca893eaeb195d45
 2014-07-16 19:15:57 +00:00
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
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
1dfacb4675 Add support for phrase queries to fts5. 
FossilOrigin-Name: 2e5652e6526b8fb3f5c163168d95bc0bb4c93686
 2014-07-02 20:18:49 +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
f9944b5053 Prevent an automatic index from taking the place of a declared index. 
FossilOrigin-Name: 0a52bddd9db49b2b79fc24888b50023d0fe74f7b
 2014-06-18 15:11:54 +00:00
drh
dabe36d9dd Prevent an automatic index from taking the place of a declared index. 
FossilOrigin-Name: 4ece839d445ff578a449a339ab579a32e64c9d28
 2014-06-17 20:16:43 +00:00
drh
03202a97f8 Add the likely() function for symmetry with unlikely(). The likely(X) 
function means the same thing as likelihood(X,0.9375).

FossilOrigin-Name: 38965484199153e3e5b999f5196c1d66e5296f60
 2014-06-17 16:11:28 +00:00
drh
2daa64cd63 Add the autoindex2.test testing module. 
FossilOrigin-Name: ffe3fea47b8ba8ec4557f68243ef3ef5aac00dfd
 2014-06-17 13:23:36 +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
mistachkin
6fe0338ca9 Fix CSV import issue, reported via the mailing list, in the shell when the file to be imported ends with an empty line. 
FossilOrigin-Name: fc918f7d332b8f7cabc79a0f1586bd6760d14d40
 2014-06-16 22:45:28 +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
51ed298364 Add test cases for the fileio extension. 
FossilOrigin-Name: 8634333127c4d868d3ec27e88b5818f6479774f3
 2014-06-16 12:44:32 +00:00
drh
69e9782f23 Add a test case to ensure that estLog() works for negative numbers. 
FossilOrigin-Name: 813469d98519b609669a004b7b604af78ef40c02
 2014-06-06 20:49:19 +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
d0dc5d4984 Avoid closing a pseudo-table associated with sorting in a co-routine since 
that pseudo-table might be used again in an outer loop.

FossilOrigin-Name: 6d81805298ea882f5fee99504d5a95f1a762a90b
 2014-06-03 14:42:34 +00:00
dan
5a0b8b124b Add a test to double-check that [1cbe7a0883] did not affect anything. 
FossilOrigin-Name: c6b512a724aebcd084aad2a80d020b95773b3012
 2014-06-03 11:32:38 +00:00
drh
974db61d9d Fix a typo in a requirements mark comment in a test script. No changes to 
code.

FossilOrigin-Name: 75ff459b06e1a5c180d316d227ce2f73c99a1f52
 2014-06-02 18:24:55 +00:00
drh
2504c6c632 Fix the query planner so that it once again knows that queries without a 
FROM clause will never return more than one row and hence do not require
sorting.

FossilOrigin-Name: 9f18b303cd1bc5779d82669884f802c7889b4947
 2014-06-02 11:26:33 +00:00
dan
5f43812af8 Add the "valgrind-nolookaside" permutation to permutations.test. 
FossilOrigin-Name: 8e8472d9b689d128eb11d3111e009161cf4580f7
 2014-06-02 09:39:24 +00:00
mistachkin
110e0ebe6d Revise locking retry semantics in Win32 VFS to abort early if the file handle is reported as invalid. 
FossilOrigin-Name: a4df4a5b34111f755ffd9ee6f089ff05d03ebc7a
 2014-05-30 21:01:41 +00:00
mistachkin
ff9fcd5a14 Add extra checking of the database extended error code. 
FossilOrigin-Name: f2906c44519d76db5bc36013369ae498b80655a8
 2014-05-30 16:54:09 +00:00
mistachkin
6b98d67b2b Add tests for the invalid file handle detection logic in the winLock() function. 
FossilOrigin-Name: ed5a9eb4f30a395bc641e79254217c7d7cf0aa5d
 2014-05-30 16:42:35 +00:00
drh
c2ce0bea88 Improvements to error messages for errors in the dot-commands of the 
command-line shell.  Add the ".once" command.  The output of ".help"
now goes to the designated output channel.

FossilOrigin-Name: 48dce821a07ac29da6ce05e92cf3f6e52b6eb388
 2014-05-29 12:36:14 +00:00
dan
3b21f6d62d Add an extra test to verify that the FTS notindexed option is working. 
FossilOrigin-Name: c461c0fe051d33cc8b4fede4eca13cd71f28126a
 2014-05-28 10:00:38 +00:00
dan
c2070c7d96 Add a test to whereI.test that uses a multi-column PK. 
FossilOrigin-Name: aa183e60929bdbbcea3c436dd8cc674fc44ad09a
 2014-05-27 11:42:23 +00:00
dan
f97dad8849 Enable the OR optimization for WITHOUT ROWID tables. Use a temp table instead of the RowSet object to track the rows that have already been included in the result set. 
FossilOrigin-Name: 2c7e277bbebd5c93dec53d381d9737909d40d846
 2014-05-26 20:06:45 +00:00
dan
6a8ac852aa Fix a problem in the shell when importing CSV files. If the leftmost field of the first row in the CSV file was both zero bytes in size and unquoted, no data was imported. 
FossilOrigin-Name: 856d44a206d82e96265103556dedda39ca3602b1
 2014-05-26 18:27:12 +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
dan
e96f2df3dd Changes to the output of EXPLAIN QUERY PLAN to make it clearer when a query uses the PRIMARY KEY index of a WITHOUT ROWID table. 
FossilOrigin-Name: 9268df305b90ac11e44b3107bbab5becf38860b7
 2014-05-23 17:17:06 +00:00