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

19187 Commits

This Branch
This Branch
All Branches
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
1615c37e48 In the CLI, allow comment lines that begin with '#', but only in a context 
where a dot-command is allowed.  In other words, '#' at the beginning of a
line in the middle of an SQL statement is just part of the SQL.

FossilOrigin-Name: 4ee136d6d2e029dad8371faf659d3a0bc0ac6ae76940db81d333848545bc990f
 2018-05-12 23:56:22 +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
fc29a86eee In the CLI, return non-zero if there are errors on the command-line. 
FossilOrigin-Name: 13e7300a37e379eac564594d78d3f039fd25737493b3b627ef02fab57a6c98e1
 2018-05-11 19:11:18 +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
drh
003edba0da Fix a typo in the help message from the ".sha3sum" command in the CLI. 
FossilOrigin-Name: dba87a201806f93a1736c1ee81d9c9cf9848e401a237dc2af3b4376402976c32
 2018-05-11 15:10:43 +00:00
drh
f2072d136d Make sure the open_db() routine in the CLI does not invoke access() with 
a NULL filename.

FossilOrigin-Name: 20a8c61122f37a43c418ca4415b3d26e0f7a27a6faea9048aa9fbb1a56e9d629
 2018-05-11 15:10:11 +00:00
drh
84e9ac2aa3 Fix a typo in the help message from the ".sha3sum" command in the CLI. 
FossilOrigin-Name: e76f676c120cd503e4a7b7cc636250ace68f4eafbbe304a8fcf503614e1b9ad0
 2018-05-11 14:02:17 +00:00
drh
18824abaea Make sure the open_db() routine in the CLI does not invoke access() with 
a NULL filename.

FossilOrigin-Name: 2b8fd3b49724a613d95e1fe2c6898b6f82188b680a668c9e9b4189156cb84a5e
 2018-05-11 14:00:17 +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
59161f1d4f Merge from trunk the ability to use sqlite3_sql interfaces in extensions. 
FossilOrigin-Name: 5bb9e6a9f19f9d73314b08afbecb13f46b0cf7b27bfb567960d8f60e3a7a74a1
 2018-05-09 15:19:41 +00:00
drh
f0f9dbd384 Add 14 new interfaces to the loadable extension mechanism. 
FossilOrigin-Name: 0e809cdcbd1bb1e269298814d6bb1dcdaea48c5b0bb20e0e1caa4dba27654873
 2018-05-09 15:17:02 +00:00
drh
0568e41012 Add the geopoly_json() interface. Untested. 
FossilOrigin-Name: 25695c80a01d18bc533d6c741076452dfc0063b1e632da346e254062ec01acbe
 2018-05-09 15:00:36 +00:00
drh
3edbdc1480 Merge trunk changes, and especially the newly published sqlite3_str interface. 
FossilOrigin-Name: f3609aefe877544c93c556840fe9a129f0680681eea0c64c084b20217dd2191e
 2018-05-09 14:33:54 +00:00
drh
446135d724 Fix minor problems with the sqlite3_str interface. 
FossilOrigin-Name: 43ea8a6836ccb9910314d35e07d881694200c97ef5969629f62e49f7a2a42f92
 2018-05-09 14:29:40 +00:00
drh
0cdbe1aee0 Make the internal dynamic string interface available to extensions using 
the new sqlite3_str object and its associated methods.  This is mostly just
a renaming of internal objects and methods to use external names, through
there are a few small wrapper functions.

FossilOrigin-Name: 87f261f0cb800b06ad786f6df16f2c4dddd0d93dfdcc77b4a4eaa22920b56bf1
 2018-05-09 13:46:26 +00:00
drh
721e8539c3 Fix a typo in a comment used for documentation. No code changes. 
FossilOrigin-Name: b866693e6a50b5c41ca54b56bb20753efb94980ad3365c511cccf23ac43a1c23
 2018-05-09 10:11:44 +00:00
drh
4c54045372 Correctly format the STAT1 and STAT4 content in the output from the 
".fullschema" command in the CLI.  Fix for ticket
[e63a34a0045832dc850367552].

FossilOrigin-Name: 0c3f128fd7d5738a8e9da706f5f30aa1985ef5efab70ddaad28ef6b641b04f4a
 2018-05-08 23:17:36 +00:00
drh
c18132313b Experiments with routines for processing GeoJSON. 
FossilOrigin-Name: d22fbff2a3dcda4bd5febd36325e4d543b8756eb9c96891ff0c610e16a52ef52
 2018-05-08 22:47:54 +00:00
drh
f2cf412a0a Fix a harmless compiler warning in fuzzcheck. Add new OSSFuzz test cases 
to the test case library.

FossilOrigin-Name: d2619746cb233f4be127a77988548dd1d90eebddf0d0ac9107913b240553e5d0
 2018-05-08 13:03:31 +00:00
drh
5ecf9039b0 Fuzz test cases for UPSERT. 
FossilOrigin-Name: fd11fbd21893d520de5a2249f825ecb5839fa4943f5c207e9e9bf8b52f4e2695
 2018-05-08 12:49:53 +00:00
drh
89ee229810 Activate the cell-overwrite optimization for index b-trees. 
FossilOrigin-Name: a68697d10ef17d452c8279181186faad7bc54e3a35858a336552f717449065ea
 2018-05-07 18:41:19 +00:00
drh
d720d394d0 Improved comments on the cell-overwrite optimization code. 
FossilOrigin-Name: a4fe966da2fc479b18bf521ff596000410af3a611f7d8723d126795e595ccf22
 2018-05-07 17:27:04 +00:00
drh
e3c05a5597 On an UPDATE, try to overwrite an existing btree cell with the modified 
content, if the old and new cell are the same size.  Use memcmp() first
to avoid dirtying pages that are unchanged.

FossilOrigin-Name: 5887d8beb502ad62689d31b850f46ab50831a1e9db36adf20d55ad45619d207e
 2018-05-07 11:48:22 +00:00
drh
e2188f0b0f Fix harmless compiler warnings associated with the new EXPLAIN QUERY PLAN logic. 
FossilOrigin-Name: 374d8e264487b0437a8d995ced1bc026a92d495a2d0568f65f033e9ebe11d0e2
 2018-05-07 11:37:34 +00:00
drh
30f7a25325 Fix harmless compiler warnings in the cell-overwrite logic. 
FossilOrigin-Name: 3e11dc3183bc3e8ec49af244a8e8b3e07d12f7a2e59028b2bf64ce0ab589a91f
 2018-05-07 11:29:59 +00:00
drh
60208c34bb Backout change [05fee1a21ea398f1e4d6f1cf3] because it does not take into 
account the LD_LIBRARY_PATH environment variable used by dl_open().

FossilOrigin-Name: b348d1193a7a3ed4d3e656b6cc95a41f87eae29222e0723850a5eb5ffabffd00
 2018-05-07 02:50:38 +00:00
drh
c6f36fa33a In an ORDER BY LIMIT, make sure the ORDER BY expression evaluator does not 
try to reuse values from the result set if the result set has not yet
be computed.  This fixes a bug in the recent deferred-row loading 
optimization, check-in [c381f0ea57002a264fd958b28e].
OSSFuzz discovered the problem.

FossilOrigin-Name: 5d61e75f32de09c81dbe844443209f063cccb005d60b846900de5b023643fc3b
 2018-05-05 16:50:35 +00:00
drh
6fcf83a503 Fix a slightly incorrect corruption detection branch in the btree logic. 
FossilOrigin-Name: 9191ff670cb7f36e0b2dac4a22888679b639845687aef8edcc3c05e35ba71eda
 2018-05-05 01:23:28 +00:00
drh
cb737dc29e Merge enhancements from trunk. 
FossilOrigin-Name: 9650f71b82ca1b3759e776bbd8a2e8ca61c51f80038e37c9c9a675a8c13b0b06
 2018-05-04 19:18:27 +00:00
drh
e3d511c078 Fix requirements marks. No code changes. 
FossilOrigin-Name: 7fdad122a21e4b01bd678198fd5131dc32febe3af366bd6368505398255f9822
 2018-05-04 18:32:11 +00:00
drh
e632ae796a For the amalgamation-tarball, enable FTS5 and JSON1 by default and 
provide a new --enable-debug option that actives debugging facilities.

FossilOrigin-Name: 03edecaf9dcfc927aa60c2a17590a432b17de1647d480d277b4aafc8018c2d20
 2018-05-04 04:49:55 +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
4388522561 In ORDER BY LIMIT queries, try to evaluate the ORDER BY terms first, and it 
it becomes clear that the row will not come in under the LIMIT, then skip
evaluation of the other columns.

FossilOrigin-Name: c381f0ea57002a264fd958b28e4921cb9c9e73a10fb592f6bb64e6bc9bd16d39
 2018-05-03 23:20:06 +00:00
drh
5e8b9853da Fix a branch that has become unreachable due to recent enhancements. 
FossilOrigin-Name: 81ab5e0d106fb9f2de80d17c8167d8542c6721b8d7ec69c43e1571c2dcadeddd
 2018-05-03 22:52:56 +00:00
drh
34b27edc80 Improved security for VACUUM. This check-in combines the fixes 
of [ab0d99d0b5ede] and [27754b74ddf646] in a way that is less likely to
to be broken by future changes.

FossilOrigin-Name: 260fc696538b195e8decabaab46771f664fb829b539efa86fb0b8170db01fa0a
 2018-05-03 21:51:30 +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
4d79983ca5 Optimizations to the new EQP framework. 
FossilOrigin-Name: 956fef361a795bd081d8e23ce4075dc8aafcee63ab7275d13b657b529d185b30
 2018-05-03 19:47:14 +00:00
drh
d5aa9262a6 Fix various error handling conditions on the cell overwrite optimization. 
Fix a test case so that it works with the new optimization.

FossilOrigin-Name: f89b54f41405ed7e28132f66b8a0c690a087c2412c8f55790c2beabb0b521645
 2018-05-03 16:56:06 +00:00
drh
da65fc6e32 The BtCursor.info fields are only valid if info.nSize!=0. 
FossilOrigin-Name: 54c537eead5b08104cfaf0d5b1e2706e53d6f74be2ca02e06229024fd889fc94
 2018-05-03 14:07:18 +00:00
drh
4f84e9c7e2 Add more corruption checking to the cell overwrite logic. 
FossilOrigin-Name: 58d14afe1e1288d114ea213458b3121e0a95670887861928858b7f143c76f789
 2018-05-03 13:56:23 +00:00
drh
9b03192e15 Bug fixes in the overwrite optimization. 
FossilOrigin-Name: 0cb6cd2a6a596afaa1cca6c5f5abc2ea75d04f254c7debaf36ecd6a90b66aed6
 2018-05-03 12:57:48 +00:00
drh
3de5d16cf7 The sqlite3BtreeInsert() routine tries to overwrite an existing cell with 
modified content if the new content is the same size.  Pages are only dirtied
if they change.  This prototype works some, but still has issues.

FossilOrigin-Name: 489451b378819621537231c1c8a07704437e11c1f5384fd53b09f3977d2213a4
 2018-05-03 03:59:02 +00:00