database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
19,187 Commits 1,786 Branches 392 Tags
geojson
Commit Graph

2270 Commits

Author SHA1 Message Date
drh
0bc7e8bf43 Add test cases for geopoly_overlap(). 
FossilOrigin-Name: 3920925128c2a91661dea5591c5d1c3762dd2c294782d5d24fe3f06546849f46
 2018-05-12 23:59:28 +00:00
drh
7dab4879d9 Merge changes from trunk. 
FossilOrigin-Name: 715740e3025f7575c1dc7cf220da6bf899d1e1b565eecbc38d2e9ec406fc97b8
 2018-05-12 23:56:48 +00:00
drh
f675c5560e Resolve issues with floating-point round-off error in the geopoly_overlap() 
routine.

FossilOrigin-Name: a3c6696f2f39554e968dcd86c87296b0d54e5a1683c2b309071ca70e7631b178
 2018-05-12 23:31:55 +00:00
drh
e65b394d6b Add the geopoly_svg() SQL function. 
FossilOrigin-Name: 318ba5f0c52596fc5ceed23a2b7b1ca18644449809890bfed47ab4ee01075060
 2018-05-12 21:09:31 +00:00
drh
e6082fcc85 Preliminary tests show geopoly_overlap() is working. 
FossilOrigin-Name: 77bb7b7d7278725e4e02935d485c3540bb41f4fc29ca8da679b2a380ebc38d7d
 2018-05-12 20:28:51 +00:00
drh
71a499d7a1 An initial attempt at an overlap function in the geopoly extension. 
FossilOrigin-Name: c857976efba79bd24befec1bd1597cc967dd2f0a39e66087cc9b1663154a05a8
 2018-05-12 16:05:45 +00:00
drh
fb0bd73a69 Add the geopoly_within() SQL function. 
FossilOrigin-Name: 927d52a93c82ae408cb1651fd1326772f0be7442b6673e89f20567e633d39af3
 2018-05-11 16:50:57 +00:00
drh
7685a67973 Add the geopoly_read() SQL function to the geopoly.c extension. 
FossilOrigin-Name: b37625e8e469f8856b19acabe9a6628322cba2e76d478da18caff4d9613ab5e6
 2018-05-11 15:38:03 +00:00
dan
cb38809159 Add a test case to check that the fts5 unicode64 tokenizer is dealing with 
codepoints greater than 65535 correctly.

FossilOrigin-Name: 9f7a6ae878cd17ff4de7c55e654406773e0ea2b9fe1c4e2a9fc2b0da84d059a4
 2018-05-09 16:32:00 +00:00
drh
f2374e1ffa The translation in and out of GeoJSON automatically adds or removes the 
redundant last vertex, as necessary.

FossilOrigin-Name: 2653bedd9f8237d9ddef533a05e161a6afe6fa4af86fac47407b3df09dc2a9eb
 2018-05-09 15:27:35 +00:00
drh
62f426093c Fix the geopoly_json() SQL function so that it works. 
FossilOrigin-Name: 236588d573a007c9c9eb8e337387d3b6318d19c8b8f260fa7324ed8c4e17060b
 2018-05-09 15:20:47 +00:00
drh
0568e41012 Add the geopoly_json() interface. Untested. 
FossilOrigin-Name: 25695c80a01d18bc533d6c741076452dfc0063b1e632da346e254062ec01acbe
 2018-05-09 15:00:36 +00:00
drh
c18132313b Experiments with routines for processing GeoJSON. 
FossilOrigin-Name: d22fbff2a3dcda4bd5febd36325e4d543b8756eb9c96891ff0c610e16a52ef52
 2018-05-08 22:47:54 +00:00
drh
5d72d9245d Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines 
associated with the OR-optimization.

FossilOrigin-Name: 75ac7b4e4fd0811ca80c719badacff207e0bbd00ac64dde3b3d4ec676fad472d
 2018-05-04 00:39:43 +00:00
drh
98b677f2cb Overhaul of EXPLAIN QUERY PLAN. The output is now in the form of a tree. 
More details of the query plan are shown, and what is shown is truer to what
actually happens.

FossilOrigin-Name: ff01bbdabc4b9db3db8b928979442c91b32d72082158e4f5fe62ae51a73649d2
 2018-05-03 19:56:50 +00:00
drh
cdf88760da More test case updates. Tests are all running now. 
FossilOrigin-Name: dab5e5294813891469660cceb211ac1a1e526715bb57dcdbb1ab90321e6a4dad
 2018-05-02 19:42:33 +00:00
drh
b3f0276b9e Fix test cases so that they work with the new EXPLAIN QUERY PLAN output 
format.  Only some of the cases have been fixed.  This is an incremental
check-in.

FossilOrigin-Name: 5f0e803e33aa557865d5fc830d9202d628de9a94c9757058ca48f1a560702cd3
 2018-05-02 18:00:17 +00:00
dan
fa5c69f5cb Fix a problem in the xBestIndex method of the closure extension causing it to 
allocate non-contiguous argvIndex values in some cases (an "xBestIndex
malfunction" error).

FossilOrigin-Name: 0c67150749cb3d067e14b2dcac9c3489e0f14bd18c0387f1d9bc93d21fc96fe5
 2018-05-02 08:12:22 +00:00
dan
2b137d65f5 Fix an RBU problem causing spurious SQLITE_CONSTRAINT errors when restarting 
an RBU update in which more than one source table writes to a single target
database table.

FossilOrigin-Name: 564ae8297d417ba4b7978e430d41f125007177673163f6ed9adc3a3974f73d24
 2018-04-28 18:20:01 +00:00
drh
6bfd973ce6 Fix compiler warnings in FTS3. 
FossilOrigin-Name: de508e831a43f02c3b354a24ea34798da03c163bae5521c852c9ddd252723739
 2018-04-28 04:10:55 +00:00
dan
03db962ab5 Update test script fts3expr4.test so that it always creates fts3 tokenizers in 
the "en_US" locality.

FossilOrigin-Name: 576a8f69ae25883f752e58953624e9f7126db998bebaa1f07f7c2ec47aaecabe
 2018-04-27 18:05:01 +00:00
drh
ef9e3d78f2 Enhance the comments in the templatevtab.c implementation. 
FossilOrigin-Name: 05f6278a02e5cde89f76ced5af7d508e26576d7291dad7ee9e06b1a3be516cb0
 2018-04-27 15:17:08 +00:00
drh
fc0ec3e5e8 Add new interfaces for accessing the list of SQL keywords: 
sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check().

FossilOrigin-Name: 7dd34e3776fed90a49344d54a1b68bb59f7957b5a8a1a367087b7cafb63111c1
 2018-04-25 19:02:48 +00:00
drh
7eabc44dee Add the new DO and NOTHING keywords to the keyword lists maintained 
by various extensions and auxiliary programs.

FossilOrigin-Name: 77a98a0781cd8450e2100111e70526db6a51d7e58e3c505ea87f685388099e82
 2018-04-25 17:10:30 +00:00
drh
cd90ca7ded Update the expert extension test cases to account for the fact that 
EXPLAIN QUERY PLAN now shows the start of each trigger in its output.

FossilOrigin-Name: 8acb42f48929d908fe67a8536e240ca252a9ab780dce79eaa85b8fba35d52250
 2018-04-24 16:51:38 +00:00
drh
4d3e61403a Fix a memory leak following failure to open an external CSV file in the 
csv.c extension.

FossilOrigin-Name: 526ee07d19dbc8fd1af3a02a8da12b337020a4be40e045da9a19d0a7c2b6ab54
 2018-04-24 10:57:10 +00:00
dan
340e9e125b Enhance the "rbu" command line utility a bit. 
FossilOrigin-Name: 61eb516f83d1a7fe44f72bebe2a2745ab904a02e06e38fb6d932348c49607976
 2018-04-20 20:37:25 +00:00
drh
55a3490cf2 Add the ext/misc/tmeplatevtab.c template for virtual tables. This is a 
work-in-progress as it still needs improvements to the comments in order to
be useful as a template.

FossilOrigin-Name: 22358fb5495c727a4dde129128fe409a7b929a5ffa143b1e2879f84d7680ec3c
 2018-04-19 16:14:59 +00:00
dan
67ecf1f5c2 Fix the fts5 xBestIndex method so that it is not confused by "IS", "!=", 
"REGEXP", "GLOB" or "LIKE" operators.

FossilOrigin-Name: a0ca4ddbbf179b8f0a5f30c127f2f8c92b6d45a08be3e1ef2194e44ebcc28120
 2018-04-09 14:26:44 +00:00
dan
fe55da387a Add a "flags" parameter to experimental API sqlite3changeset_apply_v2(). Also 
add the SQLITE_CHANGESETAPPLY_NOSAVEPOINT flag.

FossilOrigin-Name: 3d29631fa7270b18f51de8cfe1285959e42ad9a673d5d2d5c016126f5f1b31a8
 2018-04-09 11:43:58 +00:00
dan
3e259bcd96 Fix a problem in the sessions module causing sqlite3session_apply_strm() to 
allocate enough memory for the entire input buffer - which defeats the point
of a streaming interface.

FossilOrigin-Name: 7594e60935b0b5dcf764476dccdf9b403303818a0419a30bc2c16d58e44f6d04
 2018-04-06 16:22:25 +00:00
mistachkin
33fc27790a Fix segfault in 'eval.c' extension when used with 'empty_result_callbacks'. 
FossilOrigin-Name: e8b87bd4954437041139344d6d1ce3e4aace40ea6891b70f9c20cd95671270e7
 2018-04-04 12:21:33 +00:00
drh
92a2ec00eb Fix the generate_series virtual table so that it correctly returns no 
rows if any of its constraints are NULL.
Ticket [fac496b61722daf28].

FossilOrigin-Name: 3328e828e28ca7198fd1ce84503e649ab2278913a2cf85a0f0391f31d0c9c8d7
 2018-04-03 14:25:51 +00:00
drh
58bd03320d Fix a bug in the spellfix extension causing it to compute suboptimal answers. 
The problem was introduced by check-in [afd6fbc01052ccfc9].

FossilOrigin-Name: 3bf28fd9a70ebefc464dceda124d6ed342dd83f71eeeb0568f79e34e731a073e
 2018-03-30 16:34:04 +00:00
drh
9f95e48d94 Fix an off-by-one error in the dist3 algorithm of the spellfix extension. 
FossilOrigin-Name: 5c34af7b975598bbe20751dfdd346f43031cb2bcb6b78f1bbdb2b51b398de182
 2018-03-30 15:59:54 +00:00
drh
43a9385def Fix a typo in the README file for ICU. No code changes. 
FossilOrigin-Name: 79c4383b66fee9d43a75eef30ed0364573fc99e6d3be12267a99773ab8f57a9f
 2018-03-27 22:58:45 +00:00
mistachkin
43ff906d3e Fix a couple issues in the 'session' module tests. 
FossilOrigin-Name: ccf734f7d2bf8f99f3c55124b05c1835e4371bc269f27700f40afc26e7c1bc55
 2018-03-24 23:16:05 +00:00
mistachkin
2c42c34df5 Fix harmless compiler warning seen with MSVC. 
FossilOrigin-Name: e9508ab1f86ac70a3ca5622ce44141bc05186b199bf32fb8739aef36b95aa05c
 2018-03-24 20:06:52 +00:00
dan
cbeee957e5 Fix typos in sqlite3session.h preventing documentation webpages from being 
generated. Also mark all new sessions functions (those related to rebasing) as
experimental.

FossilOrigin-Name: de974235a8fefab0d08673c1b1da4e425e1d8bbfc8c35dac30943c05337b2950
 2018-03-23 17:36:31 +00:00
dan
3f2cebb6b4 Fix minor problems with passing NULL pointers to memcmp() and memcpy() found by -fsanitize=undefined. 
FossilOrigin-Name: 0b06ce6d8e7cff5cd5d467a94522dfef5593d7c26663ce03c2c2b663a2641551
 2018-03-23 16:31:34 +00:00
mistachkin
ce2052bc39 Fix harmless compiler warnings seen with MSVC. 
FossilOrigin-Name: 2f2be1b1811e6b83fc8945da06e57b8b54233ff8a6ebd9d71b22c6bab2e74afb
 2018-03-23 00:31:53 +00:00
dan
a968e74fdc Add APIs to the sessions module for "rebasing" changesets. 
FossilOrigin-Name: 509506c76b7c104961826721013889d6c6b2ed9b563dcd029e0cb5cb5c34693a
 2018-03-22 20:35:20 +00:00
dan
8cb83bee0f Remove some unused code from sqlite3rebaser_rebase(). 
FossilOrigin-Name: 07cc955eab0e993a75be82d58e17ca53c8abbcaf851983d235049599c19e582f
 2018-03-22 20:11:14 +00:00
dan
f231e18c6b Fix another problem with rebasing updates against multiple remote changes. 
FossilOrigin-Name: c8e7b5a061a3f2fbd9072530177b80f917b39ab5d7cd6acb0a221ab33e78a5cd
 2018-03-22 19:52:22 +00:00
dan
516c35a72a Fix an RBU problem causing errors when updating tables with default collation 
sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on").

FossilOrigin-Name: eb4f452e354065d610ff57a6a9312ad119b6b0cc467f9dff105f0718bc27ef01
 2018-03-22 17:13:44 +00:00
dan
fc50a71be1 Fix a test script problem causing rbuvacuum.test to fail when run along with 
other tests.

FossilOrigin-Name: 901cb3b6a2c8d0cc33bd34ec1dbeea49c779ae1ac3ed6733dd9826c8e0eb80c8
 2018-03-22 17:02:37 +00:00
dan
3fa5463c03 Add tests to ensure that patchsets are handled correctly by the session rebase 
APIs.

FossilOrigin-Name: 0e45baaec01947f6cbf47d5d5922a4cabe7d27181c04c0a08259c952fd023947
 2018-03-22 14:07:36 +00:00
dan
b880a7b1f0 Remove some unused code from the sessions module. 
FossilOrigin-Name: a09518ab63a1ef1b7f56b9f9b16269fd83920469d4c4e179b1f68b35df4e0c4b
 2018-03-22 11:15:59 +00:00
dan
f3f6a5dec3 Merge latest trunk changes into this branch. 
FossilOrigin-Name: d00b71ecf857bc6d903442d91418d5a313c584dcdd8e9c8ff3b5d940dd45bcc5
 2018-03-21 20:13:56 +00:00
dan
95ccb6dc8e Fix some documentation and other issues with the code on this branch. 
FossilOrigin-Name: a9ec68627a4533ca6aa7cc1b73f864db615a80e86eda9e33660f22d269a1ba1e
 2018-03-21 19:46:36 +00:00