bc97630313
Fix a harmless stray carriage-return character.
...
FossilOrigin-Name: 84a6c5f975de36ba93b888e01cc5188717b5644ab8384beb8fd8906bdfc8e227
2024-09-06 14:01:48 +00:00
deb6a60a84
Fix harmless compiler warnings.
...
FossilOrigin-Name: 60fb8ee153ec293b6b3a4170dafa305e4c16af575aced72daef46116d8dc2bb6
2024-09-06 11:21:53 +00:00
de30fb5fc2
Store the values of any UNINDEXED columns of a contentless fts5 table persistently in the database. Warning: This currently creates a (technically) incompatible file-format for contentless fts5 tables that have UNINDEXED columns.
...
FossilOrigin-Name: dcacb1a8ef359b4507b4733356d3150ba5dc105cc9867c103d16a0908a1a9f64
2024-09-03 18:55:38 +00:00
940cdc94f3
Fix ext/consio so that it works correctly with SQLITE_USE_ONLY_WIN32.
...
FossilOrigin-Name: efc6f3d7e92a25f440fb8d392daf325af5ca7dca104a5bb4bd59f7df93af53b0
2024-09-03 14:15:57 +00:00
e6e49bfef2
Fix harmless compiler warnings in the percentile extension.
...
FossilOrigin-Name: c5557f281c6294b6db6682349d245feac7c6ce7f4f61356f486afdf186c566c4
2024-09-03 12:41:21 +00:00
22cd1eec5a
Cause cfGets() (under SQLITE_USE_ONLY_WIN32) to better emulate fgets().
...
FossilOrigin-Name: 2d783524d1671d988ebb1b21c83de99c9f335963b6c20cf4df612f58c13da913
2024-09-03 02:09:13 +00:00
7c6f2880aa
Fix possible NULL pointer dereference following OOM in the new error reporting
...
logic of the percentile extension.
FossilOrigin-Name: 7891a266c4425722ae8b9231397ef9e42e2432be9e6b70632dfaf9ff15300d2c
2024-09-02 21:59:31 +00:00
70989b6f59
Fix a technically undefined signed integer overflow in fts5.
...
FossilOrigin-Name: e6bec37ea1ca51e1d048941ce4c5211d8fc5c5e3556a1441f9c79b036843f9e3
2024-09-02 18:41:59 +00:00
ef7c692baf
Make the percential extension easier to incorporate as a built-in on Windows
...
applications.
FossilOrigin-Name: 831e2be4117dc7f5113f66d3e484ca34e4405444ac7b0def12ee9a00608d40da
2024-09-02 17:27:10 +00:00
da52f11250
Remove some debug/test code from percentile. Make the extension easier to
...
statically link.
FossilOrigin-Name: 6e5f146e274b210749dd8923a2da56905eb098b5a66699ff9130e3e51b1ff662
2024-09-02 14:46:56 +00:00
d281889ac8
Improved error messages on percentile functions. More tests cases for
...
percentile and for ordered-set aggregates.
FossilOrigin-Name: e1bca168e70335fa2f9537632fd16e374c566a564fab4974c0b8f61cb63d08ce
2024-09-02 11:17:04 +00:00
a955ec806a
Change the name of the enabling compile-time macro to
...
SQLITE_ENABLE_ORDERED_SET_AGGREGATES.
FossilOrigin-Name: 3b1cdddf8339cc339ec74cd8be2bfa42e62b500048a444eb9e5d9817bc4702ae
2024-09-02 09:40:37 +00:00
b9a6e42a55
Improved documentation of recent enhancements to the percentile extension.
...
FossilOrigin-Name: 51e7b4c9cf19a5986432a76c5fd30cef715c170a403d7b4304a8c5888c445a91
2024-09-01 23:47:20 +00:00
ca447020ae
Implement percentile_cont() and percentile_disc().
...
FossilOrigin-Name: b1a93f67d6b21df6fe3247c9333fead61dd425574f66ea3eb06b80c2b06f616a
2024-09-01 20:24:24 +00:00
5d5d6194c9
Merge fixes from trunk into the ordere-set-agg branch.
...
FossilOrigin-Name: 7528ddcfdf155116353266e00e6408c526e29f04cb00ca2d9e84b105329b17c0
2024-09-01 18:57:52 +00:00
c97ad9b4e1
Improved sort function in the percentile extension.
...
FossilOrigin-Name: 9f84e8d59bcda642e732565e840f6a880a01b2fc65af2651248f6a8a6e1cb65a
2024-09-01 18:54:31 +00:00
41155d8885
Fix to the quicksort algorithm in the percentile extension.
...
FossilOrigin-Name: 54313f74b24c46f1afa1ff082ef569fa46938527095be358015e7047e17702ac
2024-09-01 10:52:20 +00:00
df2d14b86e
Add error checking: Do not allow functions other than those in the
...
percentile extension to use the ordered-set aggregate notation.
FossilOrigin-Name: 317d901429303340290334dbe7680a36339df0a50b586e3f71b6c5e5eba6d411
2024-08-31 22:22:24 +00:00
c1042cd133
Include percentile() and merge() in the fuzzcheck test utility.
...
FossilOrigin-Name: d1d0942a947803d45a1fd9068f3518cf412178b6b9bafcb82db44c52d5820c11
2024-08-31 19:24:17 +00:00
65b1244781
Omit the percentile_cont() function added by [095c22e62248f8ef] (and not yet
...
released) since its usage conflicts with the PG percentile_cont() function.
FossilOrigin-Name: 3fe0a852978f3f1218e37a58f0d3b54016d4116a3301aa32efa7c4c12c767755
2024-08-31 18:35:10 +00:00
ad8ec9db63
Avoid unnecessary sort operations when running one of the percentile
...
aggregates as a window function.
FossilOrigin-Name: 5d311536211eb1e3c887ceb7e6516d3900e6eebbccc8c445dd43cdd556182728
2024-08-31 16:55:14 +00:00
90fa4c7b2c
Enhance the percentile() and median() extension functions so that they can be
...
window functions.
FossilOrigin-Name: 4d0e3df4b9c609755977b8a462126242d2be1310c0122a8d4ba76d98d32a7230
2024-08-31 14:31:17 +00:00
50ca8af6f2
Fix a dropped error code in fts5.
...
FossilOrigin-Name: df55502e4f412e5b1daccf82f11fa4eb932047d9972dcd16e36be00cf09f78e1
2024-08-28 15:54:46 +00:00
f5a9b58c8b
Avoid reading the structure record from within the fts5 xConnect method.
...
FossilOrigin-Name: 6a6ce343b249e269229867b2c2f107a49ac8a8f24ad66801718ef01159655319
2024-08-27 20:37:30 +00:00
c8edf07ca7
Modify the implementation of "wrapper" tokenizers to make them more robust in the case where the database connection is closed before the tokenizers are deleted.
...
FossilOrigin-Name: 7c0001d6eb43f89144eb84d9e30f575a3feed401d685a0d1f260692e419b2df2
2024-08-27 19:27:40 +00:00
3c39f1f5d6
Add test code to drop an fts5 table with corrupt records in its shadow tables.
...
FossilOrigin-Name: ca21c942c30a3dbff0e7d118e105b847d80b5388c74d19c2eeea71581f8f40b8
2024-08-27 18:25:04 +00:00
8aa9135f2c
Only avoid all C-runtime I/O if the SQLITE_USE_ONLY_WIN32 flag is defined.
...
FossilOrigin-Name: 164b1e1962aa1e16bdf52e9e86d4cf9c9e09220c0821932ac8e390e82074185f
2024-08-27 14:25:52 +00:00
fcd65efcf1
Merge all the latests trunk enhancements into the win-dupe-crt-fio branch.
...
FossilOrigin-Name: 2d52db98f47fbcda0622c034b21c2fb19bf4345b88c5c565ae9e6f7128642e43
2024-08-27 13:57:43 +00:00
c013fa50db
Changes to documentation comments in fts5.h.
...
FossilOrigin-Name: 886545a8d0e9cbf4911ecf747da0ea8aad702d79cb065dad01a04aa4f51da12b
2024-08-26 19:08:54 +00:00
8ade1d2f97
Merge trunk into the wasm-build-rework branch.
...
FossilOrigin-Name: a1cf3095a87e101ff83ad64f20ae2e61858c7049181abfb18aece6f0a8451c15
2024-08-25 12:04:05 +00:00
cc902fd25e
Fix harmless compiler warnings in fts5V2toV1Tokenize().
...
FossilOrigin-Name: df65d00f104f31741056686f2ba41ecb192c552012bffb17c2a8b5d4db058328
2024-08-24 20:05:59 +00:00
789da35848
Fix a problem in the ext/fts5/extract_api_docs.tcl script.
...
FossilOrigin-Name: 9a9d0f6301faefe324261f03543023ffb6a90823349c6946abb0df2f69b31f96
2024-08-23 17:40:29 +00:00
8d4edd0d67
Add fts5 auxiliary function fts5_get_locale(). For querying the locale of a stored value.
...
FossilOrigin-Name: 396f720f36a937145ac727c2750acfd26e4eda350b46d648d82a7e9985545a9f
2024-08-23 15:18:02 +00:00
5804da0218
Enhance the generate_series() table-valued function such that it is able to
...
recognize equality and inequality constraints on the "value" column and
optimize its operating accordingly.
FossilOrigin-Name: d50b784807333c5461a2d027778c746c799285b95bb1952f142b317ea2846460
2024-08-22 18:12:10 +00:00
127812e645
Update some comments that are processed into the fts5.html webpage.
...
FossilOrigin-Name: 3e06ab218bbd1ed75a24afb44e8df9ce84e9fc24701428cb8b3459760f44006d
2024-08-19 20:35:30 +00:00
dd9a7e4540
Fix a problem with detail=none, content='' tables.
...
FossilOrigin-Name: 4b8070816ada3f269d53c9cee20669f59e19a23c31c8509fc397c21dd097ec9f
2024-08-18 14:46:13 +00:00
6c796631fc
Fix a broken assert() in fts5_storage.c.
...
FossilOrigin-Name: 01116e32797e1b127ba79059d890fbe5075eee2b6e3ce4468e82862b0fc3aa46
2024-08-17 19:40:15 +00:00
408a34925d
Merge trunk changes into this branch.
...
FossilOrigin-Name: 6a8ff9ba5e71d817489093d8dff0a8d77365b4222773b941accbd58558d24379
2024-08-17 19:11:09 +00:00
ef2401f669
Tests to improve coverage of fts5_expr.c.
...
FossilOrigin-Name: f4b839e5265700b1a89066d1b6e0d0d010852a69c5da3d75d2c41624dbf3c0af
2024-08-17 19:07:13 +00:00
b651084713
Add tests to restore coverage of fts5_tokenizer.c.
...
FossilOrigin-Name: 8f9257361b05e368bf433e56d0698923b0f97d12e7c0ad7760aaab6746c0e467
2024-08-17 17:22:49 +00:00
342984075b
Add tests to restore coverage of fts5_config.c.
...
FossilOrigin-Name: 9d971b31df7ad4d68eb348f95d8f996071cf87d41c47033bde3fcc4dba732e06
2024-08-16 19:05:47 +00:00
f0f240c0d8
Add tests to restore coverage of fts5_storage.c.
...
FossilOrigin-Name: 38841881a08f4d75c2dfcbc1b2b45e311d7dda1287780f8ba1c8388f7adc1629
2024-08-16 17:54:00 +00:00
db79dd1f88
Add tests to restore coverage of fts5_main.c.
...
FossilOrigin-Name: 681edd08ab7024ddcd6447a64d8aad581b47b039481b697d91d26e6c6660f373
2024-08-16 16:20:43 +00:00
41ebf965cd
Extra tests.
...
FossilOrigin-Name: fb257540d32ced4a5fe0759d3ad9c1b36fd2b7d64d93cb0a0ecdb48355a68b7a
2024-08-15 20:33:05 +00:00
189c41221d
Further tests and fixes for this branch.
...
FossilOrigin-Name: d27985245a0e8c0d6b04323c98b26b6a8fb4e489fa8f5f3234252c7c198f23c8
2024-08-15 18:50:13 +00:00
ff7200e75b
Doc typo correction reported in the forum.
...
FossilOrigin-Name: 48900a867cc4b6d733d2a3533a553af3dfadf96d3ef7ddf4c72bd432e7bf0f76
2024-08-14 20:00:03 +00:00
78f9ba9774
Improved documentation for the sha3() SQL functions in the shathree.c
...
extension in ext/misc.
FossilOrigin-Name: 0ce609103eb35cfa26d9b6fa1769679be7e2b9032c37cc8c00a194fe355b06a4
2024-08-14 17:58:46 +00:00
8ff952773d
Fix an assert() in fts5 that might fail with an expression like "... NOT ''".
...
FossilOrigin-Name: 317c91edfc69d1d47e233bb6ac13934241742fda1ba03a88fd51bdf98fcbc463
2024-08-14 14:26:02 +00:00
a7384e0de2
More tests for the new code on this branch.
...
FossilOrigin-Name: 00792e807f1dde750e6ac9f9b0095cf60b9fa6ff7cf4b14440600a21de2ee61a
2024-08-13 21:15:43 +00:00
797fcb8433
Add the sha3_agg() aggregate to the shathree extension.
...
FossilOrigin-Name: c4d7f9996ce4f5f6d08d83fc3abdb81b6825cfb556318f90c6896736a1da5175
2024-08-13 21:04:00 +00:00
