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
17,455 Commits 1,786 Branches 392 Tags
fkey-optimization
Commit Graph

1818 Commits

Author SHA1 Message Date
drh
ff6d50e973 Limit the depth of recursion for valid JSON in the JSON1 extension in order 
to avoid using excess stack space in the recursive descent parser.
Fix for ticket [981329adeef51011052667a9].

FossilOrigin-Name: 1f68c184596912d742b50b1ca38252a9e783aacf121619a27b17a7ae9f6df041
 2017-04-11 18:55:05 +00:00
drh
e12e24ded8 Change the JSON extension so that it disallows control characters inside of 
strings.  Fix for ticket [6c9b5514077fed34551f98e64c09a10dc2fc8e16].

FossilOrigin-Name: 475d8f82ec61a4ff3e6a7650731230ccecb6cc580d1397d189d0ba479d9bad4d
 2017-04-10 12:25:05 +00:00
drh
9fa866a8d9 Disallow leading zeros on numeric constants in JSON. 
Fix for ticket [b93be8729a895a528e2]

FossilOrigin-Name: 204e72f0080e8f08f99978870bd3cb9d59b068ecffee82192d707c650548b43b
 2017-04-08 18:18:22 +00:00
dan
5b09d13a58 Have the rtree module close any open blob-handle within the xSavepoint method. 
This prevents such an open blob handle from interfering with DROP TABLE
operations.

FossilOrigin-Name: fa4416adc2a9a3a80db1d5befc0b95c3d0fc41affe38f7f2f45cdfae3f1b49eb
 2017-04-08 13:52:41 +00:00
dan
be0bc8bb4d Have fts5 close any open blob-handle when a new savepoint is opened. This 
ensures that fts5 does not prevent DROP TABLE statements (which always open a
savepoint) from succeeding.

FossilOrigin-Name: a921ada89050ce1d162fd1b0056939573635e2cec7ac0c2a99ae924b3ae593f7
 2017-04-08 09:12:20 +00:00
drh
297e2bdb8e Make sure the RTree sqlite3_blob handle is reset prior to renaming the table. 
FossilOrigin-Name: 1cdae2db3c54970a1811e597065724578408c84d49d75b8fe25d56281ddc2e94
 2017-04-08 01:09:14 +00:00
drh
2fb79e9b04 Fix two harmless compiler warnings. 
FossilOrigin-Name: 32be9c3faaafd736da3f49d475dc9279af4e4ba38070b60033d898345080acf0
 2017-03-25 12:08:11 +00:00
drh
ba7cce317b Fix a harmless compiler warning in the JSON1 extension. 
FossilOrigin-Name: c2c3dd84534bb5ea81c974847b74a166c9cba1545fc749ce625929f303bf22e4
 2017-03-24 19:45:05 +00:00
drh
29c9969871 Fix an error in the new json_patch() routine discovered by Ralf Junker. 
FossilOrigin-Name: 9d5350418b2f6113e0b50c57e8a872006f27753067baf08ffdfa7943c0c9a148
 2017-03-24 12:35:17 +00:00
drh
37f03dfb1f Change the name of the json_merge_patch() function to just json_patch(). 
FossilOrigin-Name: 04d4100445a3373986ee962618bc03ec304f6ba2f867c8e9eee415daffb593fc
 2017-03-23 20:33:49 +00:00
drh
1fe162fd0c Avoid redundant edits in the json_merge_patch() function. 
FossilOrigin-Name: 4a8e6437dd610c5376a07867a73e5a7e2ea90357a018e1788ecce6f4e10bc939
 2017-03-23 12:56:44 +00:00
drh
0002d246a9 Fix harmless compiler warnings in the new json_merge_patch() logic. 
FossilOrigin-Name: 5d2cf5a2f8afd88d041d89b3936042ce5a43629d23c48738cb2791b24da3e6af
 2017-03-23 00:46:15 +00:00
drh
bb7aa2d85e Various fixes to the json_merge_patch() function. 
FossilOrigin-Name: f49fd2554b0723eb7cf2fd765d655c6820833ee7e5f7d7629d98c27a6fffa1d9
 2017-03-23 00:13:52 +00:00
drh
f07b249f92 Change the name of the new function to "json_merge_patch()". 
FossilOrigin-Name: 53bf70f37bbca319ea35f70849e2a34ae628a504486158fdad5c4bb7431c68e0
 2017-03-22 21:45:20 +00:00
drh
633647af75 Initial implementation of the json_mergepatch(A,B) SQL function. 
FossilOrigin-Name: a267444039af519f088dd8f8ee33f686cc3071c087677075af2364ebc2587514
 2017-03-22 21:24:31 +00:00
dan
119fc11eb0 Add short script ext/fts3/tool/fts3cov.sh. To help measure test-coverage of 
fts3 source code.

FossilOrigin-Name: ee9588e873ffebcaa177957950cbb14924e154c391ed7f687116065064ff11b0
 2017-03-21 17:19:31 +00:00
dan
74869e5e52 Avoid passing NULL as the second argument to memcpy() in fts3. 
FossilOrigin-Name: 49b93d972de9649abfd6235b65dda1c9d468956671e50704afde6181ffa56dea
 2017-03-20 19:35:30 +00:00
dan
6b904f5e01 Avoid a technically undefined right-shift of a signed value in rtree.c. 
FossilOrigin-Name: a144875fe44ff3a30bab299d50b7dbec2ee21f8c73e692a71ee1f7c54b5f0c76
 2017-03-20 19:26:27 +00:00
dan
920c83f18f Fix some problems in fts3 found by address-sanitizer. 
FossilOrigin-Name: 16a8e84fa7f67a467f824bdd7f72cbd6a6e95dab8cc7aa1e0e751720b98f3e31
 2017-03-20 18:53:32 +00:00
drh
6f25936c9c Updates to README files under the ext/ hierarchy. No changes to code. 
FossilOrigin-Name: 029bc5d224bcbdcca2307710539b133c39e2a27b971c28b294a1f517b80cb418
 2017-03-15 20:27:46 +00:00
drh
9c4527e57d Improved header comment on the shathree.c extension. No changes to code. 
FossilOrigin-Name: 84f2e3d5f611b35de16684956d842df6c93d858e8187f17eb27452758a752c57
 2017-03-15 13:47:39 +00:00
drh
d3bc75fb94 Fixes to the dump logic. All appears to be working in preliminary tests. 
FossilOrigin-Name: 007b11e301d444361c8eff8734dc2fb968a64343c177ff30cec74a0cf76099e8
 2017-03-13 21:49:48 +00:00
drh
473af4fe03 First draft of the complete dbdump.c library. 
FossilOrigin-Name: 84ea4fcc52d0af02648c52989c2e69f4961071e1620382555ec59a39161a7a7d
 2017-03-13 21:26:41 +00:00
drh
688633cb9e Infrastructure for an extension C-library to implement sqlite3_db_dump() and 
a corresponding "dbdump" command-line utility - both of which do the same
work as the ".dump" command of the CLI.

FossilOrigin-Name: 74c5ace498f72d7f5495203678bedd0bc540211131a4e4db7b62115d5322a288
 2017-03-13 19:26:34 +00:00
dan
1ba30db8bd Remove the rbu_round_trip.tcl script. It is now part of project "test-dbs". 
FossilOrigin-Name: b5bf2957677e8f2acd7426b302229a966de08fd9
 2017-03-10 18:36:34 +00:00
drh
4146b4e34a Improved comments explaining the sha3_query() format. Fix a performance #ifdef 
error in the sha3 implementation.

FossilOrigin-Name: 54ef7abd7f5b16f4b29c9519d283e142c9340fbf
 2017-03-08 15:03:12 +00:00
drh
acc83d2e4f Add the shathree.c extension for implementing SHA3() and SHA3_QUERY() SQL 
functions.

FossilOrigin-Name: f7ca9193ddafd3676406bdfeb1b7d21182c2a3c1
 2017-03-08 13:50:40 +00:00
dan
5cc95ebf37 Add test script ext/rbu/rbu_round_trip.tcl. Uses "dbselftest" to test that 
"rbu" and "sqldiff" work together.

FossilOrigin-Name: 961e79da73b4550b3e5b0f9a617133a76485db67
 2017-03-07 20:03:25 +00:00
dan
0e9b43ff85 Before beginning an incremental checkpoint in RBU, sync the directory 
containing the target database file. This ensures that the new directory entry
created by renaming the *-oal file to *-wal is synced to disk.

FossilOrigin-Name: 915a9a28783fbb2f4c0794eb4264ce8c0b9d42f7
 2017-03-03 16:51:46 +00:00
dan
1d62a66230 Fix another RBU case similar to the previous. This one for systems where the 
sector-size is larger than the page-size.

FossilOrigin-Name: 4012bb3aa91927156ba149caa4e5c622b0729d79
 2017-03-02 16:56:48 +00:00
dan
cb1b0a693a When saving the state of an RBU update in the incremental-checkpoint phase, 
sync the database file. Otherwise, if a power failure occurs and the RBU
update resumed following system recovery, the database may become corrupt.

FossilOrigin-Name: edee6a80e1cc7e6a2b8c3c7f76dd794fc8ab9a72
 2017-03-02 14:51:47 +00:00
dan
81415257ec Improve performance of fts5 writes by writing the "averages" record once at 
the end of each transaction instead of every time the table is updated.

FossilOrigin-Name: 2b210d691462b463796e7948399133c296e89ebf
 2017-02-27 17:06:56 +00:00
dan
9c58b63c18 Add an sqlite3_set_last_insert_rowid() method. Use it to work around fts4 and 
fts5 modifying the last-insert-rowid unintuitively from within commit
processing.

FossilOrigin-Name: fe41bb5632a5d438acfd682809f1bd12315b970a
 2017-02-27 14:52:48 +00:00
dan
70cdf38232 Add an 'extern "C"' block to header file sqlite3userauth.h. 
FossilOrigin-Name: ffd61fb449a510b2fc90caf86b266733051cc365
 2017-02-25 20:57:46 +00:00
dan
f0e808c60b Fix an FTS5 problem that could cause a crash when certain queries were 
interrupted using sqlite3_interrupt().

FossilOrigin-Name: e400909f313c317b7b67be6eb867ed61df7383dc
 2017-02-21 17:52:58 +00:00
drh
dc5ece86ae Remove the CLANG_VERSION macro, since we have learned that version numbers in 
clang are "marketing" and are inconsistent and unreliable.  Builds using clang
will still use the GCC_VERSION macro since clang works hard to be gcc
compatible.

FossilOrigin-Name: 810d29320b853b3a01aa50d8f2a0bceacf79e0aa
 2017-02-15 15:09:09 +00:00
drh
ac279be98e Avoid a duplication #define in FTS5 
FossilOrigin-Name: c447441cff1884d6fe5f0a76d64b3e7d908584a1
 2017-02-13 13:20:02 +00:00
drh
a39284bfa8 Cleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option. 
Remove the SQLITE_RUNTIME_BYTEORDER compile-time option.  Use
-DSQLITE_BYTEORDER=0 instead.  Fix a bug in R-Tree that occurs when compiling
on a known little-endian machine without the use of intrinsic byteswapping
functions.

FossilOrigin-Name: 798fb9d70d2e5f95e64237b04d6692360133381a
 2017-02-09 17:12:22 +00:00
dan
18fdde21b8 Avoid preparing a SELECT statement each time an UPDATE or DELETE 
by docid is executed against an fts3 table.

FossilOrigin-Name: 9962c10a5c6672bd82b2bf640d878fcdac0b815a
 2017-02-08 19:10:47 +00:00
dan
9fcb6ddc1e Fix a build problem affecting non-amalgamation rtree builds. 
FossilOrigin-Name: bb7f445ba1df53cd4a169612b18fc533016102b7
 2017-02-07 14:45:18 +00:00
drh
364ca6a90e Fix SQLITE_BYTEORDER #defines in R-Tree when compiled separately from the 
amalgamation.

FossilOrigin-Name: a136609c98ed3cc673c5a3c2578d49db3f2518d1
 2017-02-07 13:51:48 +00:00
drh
edd9bcb372 Make the cellMargin() routine of R-Tree slightly smaller and faster while also 
fixing a harmless compiler warning.

FossilOrigin-Name: 07fe6228208684d579c4f6c334c90eb6262a9233
 2017-02-07 12:58:38 +00:00
drh
b18bf843f7 Fix a minor typo in a comment in R-Tree. No changes to code. 
FossilOrigin-Name: f77ee9e941f22b0b2e88871df4466fdde9cde131
 2017-02-07 00:55:47 +00:00
drh
04128ace8d Remove a small amount of unnecessary code from R-Tree. 
FossilOrigin-Name: e5aea894267addb4dc9b21de24a20417b0be508a
 2017-02-06 16:52:32 +00:00
drh
9630f3ba08 Remove incorrect testcase() macros from R-Tree. 
FossilOrigin-Name: 853a58a75ecbd01ebbf7e07fbd8c4fc9bef54a99
 2017-02-06 01:19:07 +00:00
dan
ff677b20fc Allow sqlite3session_apply() to apply changesets to tables that have been 
extended using ALTER TABLE ADD COLUMN.

FossilOrigin-Name: b20ff81ff9c8af500ea96e0ba9d34524220a89f1
 2017-02-04 17:33:30 +00:00
drh
fe05491b87 In RTREE, use an sqlite3_blob object rather than an sqlite3_stmt object 
for reading content out of the %_node shadow table.

FossilOrigin-Name: 97ccf3e4de11ffea46993cb7fb7ab559b9810705
 2017-02-04 14:24:05 +00:00
drh
010e312f8f Close sqlite3_blob objects on xSync rather than waiting until xCommit. 
FossilOrigin-Name: 95ee745fceb4a48c683f34c404c380fe5e7d684a
 2017-02-04 13:12:12 +00:00
mistachkin
07b139b8c1 Fix issues in the sha1 extension seen with MSVC. 
FossilOrigin-Name: 5a0da77c22ebc7db5e63b1520d30f3ad97b9bb3b
 2017-02-02 19:24:05 +00:00
drh
3accc7e1af Remove the unused pReadNode prepared statement from each RTREE object. 
FossilOrigin-Name: e51dc0ec60d45cd57564735b6b2bb254a588533e
 2017-02-02 16:30:25 +00:00