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
17,749 Commits 1,785 Branches 392 Tags
list-pragmas
Commit Graph

1902 Commits

Author SHA1 Message Date
dan
adea0d1c39 Have fts3 virtual table cursors free internal resources when they reach EOF, 
instead of waiting until the xClose method is called.

FossilOrigin-Name: b6b14ab6c8f9758a64e5fd29203f8fa610b5c4ef917de9be51ae55e072fad4ed
 2017-07-05 18:48:07 +00:00
dan
7181395a4d Fix a problem in lsmtest causing one test to fail for multi-threaded LSM 
connections.

FossilOrigin-Name: 2bce64c8864b616f9ab0063f64d0ceb2f83e53e110970c6b3b11003cba5c8804
 2017-07-05 14:29:04 +00:00
dan
431a53fde2 Fix further OOM handling cases in LSM. 
FossilOrigin-Name: ca757c8665e27de884086b2aab2bd1db481e2d12f2afe136ec151bf5a0e65b91
 2017-07-04 19:23:32 +00:00
dan
038af0bdc6 Fix a couple of problems in handling OOM conditions within LSM. 
FossilOrigin-Name: 989a5c1745a7145c14c6d9b713176ecba6b99296de8bdd09f666eeef10da9c2e
 2017-07-04 17:25:45 +00:00
drh
518ee8f06f Fix compiler warnings in LSM1, especially in the test logic. 
FossilOrigin-Name: 9bd3be92b8add7bd0d7bc4b0742b2dd227ebb8d67a839b78f26f2b06b47490f2
 2017-07-03 21:09:28 +00:00
dan
45408a108f Fix a bug in lsm queries on levels undergoing incremental an merge that 
contain range-delete markers.

FossilOrigin-Name: b2c2487928becbea5a932895d153709c98a057a3c71c2600e165478562e9f7c5
 2017-07-03 20:19:28 +00:00
dan
05dda7ba8e Add more tests for LSM log file recovery. Fix a problem in recovering log 
files that contain range deletes.

FossilOrigin-Name: e34eafd4c5b2bbf2735e136ad69b67bb4288ad4d01a0128d8e107ac46209a182
 2017-07-03 09:00:18 +00:00
dan
24f6904e99 Fix a memory management problem in lsm log recovery code. 
FossilOrigin-Name: dd55af30b4440bba1b97c2155b9f499d791cd7d8bae8341972c41439fdc41edc
 2017-07-01 20:59:06 +00:00
drh
c7b1ee5f6e Enhance the RTree module to detect node truncation early and report an error. 
FossilOrigin-Name: 66de6f4a9504ec2670b7273de8fb6955c80e03f7f73414ea6b80fd8a99f75976
 2017-07-01 15:21:17 +00:00
mistachkin
04222ce52e Add some assert() statements in the Win32 interface for lsm1. 
FossilOrigin-Name: d076d58ff108d286f7ac1f81e1ce945d6f4a4f5f97e3b8d5cee6f8d9a6c48d8f
 2017-06-30 19:22:33 +00:00
mistachkin
88f769f967 Fix some minor typos in lsm1. 
FossilOrigin-Name: 0ef777d7474383c0211b19baa4a161cf7fce6570f384dfef368cdab45c1a0f01
 2017-06-30 18:12:09 +00:00
dan
a5b55e370f Avoid constantly freeing and reallocing small internal buffers associated with 
LSM cursors. Instead, allow them to persist for the lifetime of the cursor if
they are LSM_SEGMENTPTR_FREE_THRESHOLD (default 1024) bytes or smaller.

FossilOrigin-Name: bacfe8cb3e4d3be736c6789b2ce55ef5603e5c7a289b05b37cae2203cd7f2290
 2017-06-30 11:44:11 +00:00
dan
28508ddb42 Avoid reading or writing the 32 locking bytes at the end of the first 
meta-page of an LSM database.

FossilOrigin-Name: 2b5df3e8a80ae5c0415081dd9b29acaad1464be2e7971399e52c1c98408322d9
 2017-06-29 20:13:44 +00:00
mistachkin
97e8b3ea32 Fix issues in the POSIX and Win32 interfaces for lsm1. 
FossilOrigin-Name: 38ec41416679e8280d77c8a4913aa6a321784b1237a3fe409b8e256c5f4513de
 2017-06-29 19:08:52 +00:00
mistachkin
de680efbc3 More updates to the Win32 interface for lsm1. 
FossilOrigin-Name: cae647696769c9fcdc3beafdfdf74d8384217f4b22820e4545093bea7be58f7c
 2017-06-29 16:51:52 +00:00
mistachkin
c2586f77ad Correct typo in the Win32 interface for lsm1. 
FossilOrigin-Name: 1b4facb1ad0085aa52e63d4d432179467ddc2a69b668d49d86e65ead66a73f57
 2017-06-29 15:57:42 +00:00
drh
01e6d540a7 Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the 
extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as 
one bit in that argument.  Use the new option in FTS3, FTS5, and RTREE.

FossilOrigin-Name: 03977248e6fdaa9b35c15e5dd9bb89552f2f0a913cc31609b5af1e2347b67d38
 2017-06-29 15:24:57 +00:00
mistachkin
14e61df283 Further corrections to the Win32 interface for lsm1. 
FossilOrigin-Name: 4df6e2476ce93b9ca7a6959c8c2d6ef2c30395984b007d74166031dcf09d54b4
 2017-06-29 15:13:48 +00:00
drh
c6603af755 Rename the "stmts" virtual table to just "stmt" without the final "s". 
FossilOrigin-Name: adfdb80105c46ac42b71132c80a91dbd5b1c9ff241fb4fbb5d04641a88898d90
 2017-06-29 14:33:51 +00:00
mistachkin
3881d23c72 A couple fixes for the Win32 interface for lsm1. 
FossilOrigin-Name: ebbd98e941d8a8ea97b434c29b70095515af0adab1977aa4d37fe74a7401f846
 2017-06-29 14:17:48 +00:00
mistachkin
2ca62cb102 Compilation fix for lsm1 using MSVC. 
FossilOrigin-Name: b7794cc5d5abc13c6301c8d5c1b330405432c047f154083430fd15823221e552
 2017-06-29 13:35:44 +00:00
drh
e4b45f536e Add the LSM1 extension. 
FossilOrigin-Name: 824e83274c04d24fd854bc7376c958ea6b05862efc562a3dfed0fc888fd96cc2
 2017-06-29 13:19:55 +00:00
mistachkin
d90dbb8c1c Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. 
FossilOrigin-Name: 680cc064c9e809ddc643074b5e65677f484d904b3d52826f6def480ddaa8f0ab
 2017-06-29 12:54:58 +00:00
drh
00d11d400b Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN options to 
sqlite3_stmt_status().  Use this for two new columns in the stmts virtual
table.

FossilOrigin-Name: b0b0c8f8d548ef78584ab714ab120b01c1b83fc0d8ae2fd7626b970bab9fca58
 2017-06-29 12:49:18 +00:00
mistachkin
cffbd543d3 Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. 
FossilOrigin-Name: 93c9aa7d9aea46b331c53ff579ef704e88ce90f96600b69479a87a4bb4ca2a91
 2017-06-29 00:20:42 +00:00
mistachkin
44ab70db7e Implement xLock and xTestLock for lsm1 on Win32. 
FossilOrigin-Name: 9112117dad8085c385aa614cd982b307f5822761607ba358f34df7848c549134
 2017-06-28 21:36:40 +00:00
drh
d0bbe4e9c2 Incorporate recent trunk changes. 
FossilOrigin-Name: 62b8269ba2ff71e2daaa86688698896badd6f6e34ab42fbf92dda7fcda73a230
 2017-06-28 15:56:58 +00:00
drh
f00f530b7d Build the "stmts" virtual table into the amalgamation. It is active only 
when compiled using SQLITE_ENABLE_STMTSVTAB.  That option is supplied to the
command-line shell.

FossilOrigin-Name: 0ff057d86e42e518fda22bfbf5f1977ab6bd0a74a9211ff259ee7e8a7ce98b58
 2017-06-28 15:47:29 +00:00
drh
2fb960b545 Fix harmless compiler warnings in the CSV extension. 
FossilOrigin-Name: f02a54599de7620438aecd3753199fc52ce8919d7503bb8b2f5592b0e51dbf8c
 2017-06-28 15:17:31 +00:00
mistachkin
ec99c0f632 Improve a local variable name. 
FossilOrigin-Name: d0f6973d93c36451bf64f47de9a88abec613a624603033bf6717f5071139b6d2
 2017-06-27 22:33:06 +00:00
mistachkin
b5fdc26c21 Initial work on porting lsmtest to Win32. 
FossilOrigin-Name: 7e669d9bfab237ff7ece821cf95cfd3bb753b1882b9a86044b7d4579808aecf4
 2017-06-27 22:27:54 +00:00
mistachkin
59b1dd3830 Implement xFullpath for Win32. 
FossilOrigin-Name: dbe9c8aa8d70051fafec569054eeda6c02efe9d036ab6beada00da3ed42e52d9
 2017-06-27 18:15:38 +00:00
dan
210ec4c855 Fix a virtual table problem that can occur when the vtab is on the RHS of a 
LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab
is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH
constraint in the WHERE clause of the sub-query.

FossilOrigin-Name: 87b381663398f029f52cb5598aadd069b03034b6f833ce80ba762b406075a44e
 2017-06-27 16:39:01 +00:00
mistachkin
8e1ddde079 Minor corrections to the previous check-in. 
FossilOrigin-Name: e1cf8a78a0bbd7b05cefab22a5c9676098887ee9811d37330ce89b3367856f92
 2017-06-27 06:28:00 +00:00
mistachkin
02679b0466 Work in progress porting lsm1 to Win32. 
FossilOrigin-Name: 2017636e93cf810fe4d1247c18de9f316fca037035a026f77c4588563d7bf0cc
 2017-06-27 05:59:47 +00:00
drh
d5fbde80a2 The ".import" command of the shell, and the csv virtual table extension both 
ignore a single UTF-8 BOM at the beginning of their input.

FossilOrigin-Name: 7c15d762d99c2e3e534cd35dfe25ddcd317637eb1f2655fd24c2dd5f9d5a7613
 2017-06-26 18:42:23 +00:00
dan
4261a4065f Remove an invalid assert() from lsm test code. 
FossilOrigin-Name: ca8a7e995c3da10ba05e3b7d4818c633fe5ba6d6f9351b67017a2603b50b903d
 2017-06-26 11:46:01 +00:00
dan
3a31c67aae Fix another problem with multi-threaded mode in the LSM test code. 
FossilOrigin-Name: 461ced77d93e84f09bfb4291999cd0245506fa9a8369049fd68968bbcf18d41b
 2017-06-26 08:24:35 +00:00
dan
e6f98bcf09 Update a test case to reflect the fact that the lsm blocksize is configured in 
KiB. And defaults to 1024, not 2048.

FossilOrigin-Name: d7015475f121db1f56060716cd8adb73e9b52016890ec9018b620ef9d7d4fbff
 2017-06-26 07:31:28 +00:00
dan
07cae6ae74 Fix some compiler warnings in lsm_file.c. 
FossilOrigin-Name: 23f16382ed47a90bf5e6c1684d54d28484dca46fea20ca0f131bd477cf222bfb
 2017-06-26 06:53:24 +00:00
dan
f417f28bd7 Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. 
FossilOrigin-Name: 603838fc9a65adda831a6a17b31b2e80f5b56e5946a9f0c1fa2c83d2f2a67f6a
 2017-06-17 16:39:10 +00:00
drh
b74013300c Merge the latest changes from trunk. 
FossilOrigin-Name: 60105c2253d0b617037e975b0d0b729bcb59b950aa2c33d8891394ad45aabb69
 2017-06-15 15:06:26 +00:00
dan
2ebf8f474e Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. 
FossilOrigin-Name: c433672dd8ab625628bde2f4f40a2dc000ed915dbe91833d3f753d8ab51baf25
 2017-06-13 16:52:34 +00:00
drh
e46c63d565 Fix the sessiondiff test module so that it does not run if the session 
extension is not enabled.

FossilOrigin-Name: 8f92b7a6223a69304dc8a6ab3b43a49cbb87f572a1e65d8a0c6dc09fca38e1a8
 2017-06-11 19:40:34 +00:00
dan
41ac439dbe Fix another lsmtest build problem. Add the "-trans BOOLEAN" option to "lsmtest 
speed2".

FossilOrigin-Name: 61853bc171e7c3af1db6a33ac8b1ad21e1c08e8d6b317fe061fdcd89c9a42e88
 2017-06-07 19:46:18 +00:00
drh
0282c03abc Merge in trunk enhancements. 
FossilOrigin-Name: f8bbb608cbf6c245628e3d362e9181fb3dc402b1d8241bcb687caf395f63c916
 2017-06-07 16:25:25 +00:00
dan
3b328522f4 Fix a threading problem in lsm test code. 
FossilOrigin-Name: 501238b9fbb4eece084b4bfce84a5f37a986f34db8081df517e60ef81f357454
 2017-06-06 16:14:49 +00:00
drh
59ce97a013 Merge all recent trunk enhancements. 
FossilOrigin-Name: 1d23294d88b1a80fe1f5403ea4fd75e61bb4932d5b714ea450d1b4b84f0896ab
 2017-06-02 23:44:38 +00:00
drh
6c2d94f928 Fix a typo in the header comment of the "series.c" virtual table extension. 
FossilOrigin-Name: d637feb4e3032ee0067c204b56d2af5f7eab228e645f2e77b0b043c2b299724d
 2017-06-02 13:16:54 +00:00
dan
38d6985509 Add test code for LSM to the ext/lsm1/lsm-test directory. 
FossilOrigin-Name: bb7436e84a315baf05f00e6cab396017e3f287ea404d32e0cc4f389fa1194dec
 2017-06-01 16:13:57 +00:00