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
20,204 Commits 1,786 Branches 392 Tags
begin-concurrent-wal2
Commit Graph

20204 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
dan
d55e8f5ff0 Merge documentation changes from branch "begin-concurrent" into this branch. 
FossilOrigin-Name: 41e742bd0f94894b096b30474fb548f58951756d1ea47d0afb717a54802888f4
 2019-01-11 15:22:27 +00:00
dan
77428e6055 Add new documentation file begin_concurrent.md. 
FossilOrigin-Name: fdbf97e611ed23f86dc0df9d53421fb04226af0d1c7171d55c11acd0dbe935f0
 2019-01-11 15:06:39 +00:00
dan
4853110e61 Merge latest wal2 changes (documentation only) into this branch. 
FossilOrigin-Name: 820ba1cc7e374409f27d0f1e62ed17c9670ce0e1f6e1d39a02fa8d48319745e8
 2019-01-11 14:59:24 +00:00
dan
f552a23740 Add new file doc/wal2.md to this branch. 
FossilOrigin-Name: b495dce153f7f886f3dba09593f29ce2375718bf6508f2cfffd1af8071a995ae
 2019-01-11 14:58:03 +00:00
dan
b93ce6d4a6 Reinstate assert() statements in os_unix.c that were removed to allow 
wal-mode SHARED locks to be taken over more than one locking slot
(this branch no longer does that, so the assert() statements can go
back in).

FossilOrigin-Name: fcb7348ba190e48112a681f704313a733f7a377456e7c1d6845ba34c270d86b6
 2019-01-02 17:08:06 +00:00
dan
3eeda95d36 Reinstate assert() statements in os_unix.c that were removed to allow wal-mode 
SHARED locks to be taken over more than one locking slot (this branch no
longer does that, so the assert() statements can go back in).

FossilOrigin-Name: 8445fb6d5dae98a0129514a10a15f08412bac5a1d8114b12e592c744ea2bc4c9
 2019-01-02 17:00:00 +00:00
dan
2cdce9c105 Merge latest wal2 changes into this branch. 
FossilOrigin-Name: c31eeb3c87f260fa192638b3610a4d3b84b2c26cfaefc97ed63910495403f8c9
 2019-01-02 16:30:10 +00:00
dan
1f3762607d Merge latest trunk changes into this branch. 
FossilOrigin-Name: 87ef68f9174b5e21fa2fb4f2fa23e0ecd6a0ea854422c8aa74cd7306a1ed8427
 2019-01-02 16:15:02 +00:00
dan
2da2a2698b Merge latest trunk changes into this branch. 
FossilOrigin-Name: 5bf212f1a754fde90af0af82dd76f636754829c7372e19df1fd4fa579f0926aa
 2019-01-02 16:08:14 +00:00
dan
ca076bf26e Add another test case to vacuum-into.test. 
FossilOrigin-Name: 0465d2fc0d3f8beaa1b6b0bd7bd51d69a524f30d889c9402e7d02cc06164a310
 2019-01-02 16:01:59 +00:00
dan
992e927281 Add test cases for commit [6c6fb1c6]. 
FossilOrigin-Name: 3961995cb56b43f1753c53fc869edf336f1c17ec994d67dc74e44e8e02493894
 2019-01-02 15:27:27 +00:00
drh
ee751fab4c Raise an error if the argument to VACUUM INTO is an identifier. 
FossilOrigin-Name: 6c6fb1c6ea452c70b56fd4ac796affebee21512adba0455ae81c291b715f544f
 2019-01-02 14:34:46 +00:00
dan
9b0da8319c Fix another fts5 problem caused by a corrupt database. 
FossilOrigin-Name: 911342f7512145a8a189bb0ec59e70e4c9ddc9f20f3e84816ab25139ead5dc45
 2019-01-01 19:17:42 +00:00
dan
97c8cb3ed8 Ensure that when a new cursor is opened by OP_OpenDup, any existing cursor 
with the same id opened by a previous OP_OpenDup is closed first.

FossilOrigin-Name: 5c188361a91407805c0feb4bf6d3214522ce3e55013efcf63a4613ecd416bcbc
 2019-01-01 18:00:17 +00:00
dan
fff1dc8e05 Fix another case in fts5 where a corrupt database could cause a buffer 
overread.

FossilOrigin-Name: f7e6cdc5625664f449d0edbe39af2d45910c4137bfd856ae1f770dd826c138ff
 2019-01-01 13:59:34 +00:00
drh
f9231c34eb Fix harmless compiler warnings. 
FossilOrigin-Name: b57c545a384ab5d62becf3164945b32b1e108b2fb4c8dbd939a1706c2079e18b
 2018-12-31 21:43:55 +00:00
drh
f01dae1f32 Additional steps to help ensure that scalar subqueries are only evaluated 
once even if they are used in multiple places within the query.  This fixes
a performance regression reported on the mailing list and caused by
check-in [531eca6104e41e43] which was a fix for ticket
[787fa716be3a7f650c]. Think of this check-in as an improved fix for
that ticket.

FossilOrigin-Name: e130319317e761193890ef75787a3c114b61166f518df019697be8e2c820ec54
 2018-12-31 20:39:37 +00:00
drh
d471bcb396 Remove an optimization that can no longer occur, being superceded by the 
subquery-reuse optimization.  Put an assert in place of the optimization
to detect if the need for this optimization ever returns.

FossilOrigin-Name: 4fcdc7a2939457e51aab37cab168677cd7f464a9a0aff4f8981e864a30828b3b
 2018-12-31 20:13:12 +00:00
drh
0de6efe59e Merge enhancements and bug fixes from trunk. 
FossilOrigin-Name: 9fb646f29c05bca5f677a2c7c4f45c36bfe0a0c6a88cb7968b4a0459bdd63bb2
 2018-12-31 18:30:41 +00:00
drh
d0fb7960ce Small changes to the OP_OpenEphemeral opcode to improve testability. 
FossilOrigin-Name: f856676c8438dbf52d299e78f6dd6148d929755dc05cdcabafd17d9a86439435
 2018-12-31 17:58:05 +00:00
drh
4afdfa195b Fix the OP_OpenEphemeral opcode in the bytecode engine so that if it is called 
a second or subsequent time, it merely clears the existing table rather than
creating a new one.  Proposed fix for ticket [d0866b26f83e9c55e30de0821f5d].

FossilOrigin-Name: 4678cb1044f0b4dc813e48f3bd0f85240a66e2ecf8763280d66726cc031c93a7
 2018-12-31 16:36:42 +00:00
dan
d080e84c81 Merge latest begin-concurrent changes with this branch. 
FossilOrigin-Name: 1625887c0240eb1cb37e41d79e789c4ff311352c5708e6a2d3ed1b223ff382e3
 2018-12-29 20:47:45 +00:00
dan
ff9e9b27d5 Fix a problem causing a corrupt pager-cache if an OOM or IO error was 
encountered while committing a concurrent transacation.

FossilOrigin-Name: 48ca30f9d7817d87a5e9a069fdc51b1a34e00585f8a35771895dd743c7bfe07c
 2018-12-29 20:42:12 +00:00
dan
71fad44b38 Increase coverage provided by permutation "coverage-wal" on this branch. 
FossilOrigin-Name: f664f940a7eb6938b1ee171143a691e2f497aec921f979be63ef844d38053f56
 2018-12-29 16:34:22 +00:00
drh
d1d158bf5a Additional small performance increase and size reduction to the 
sqlite3VdbeMakeLabel() mechanism.

FossilOrigin-Name: 1bdee199a71e0a6c247b85e72de9e3a3099b7179c33288735721facef3b96459
 2018-12-29 14:23:22 +00:00
drh
ec4ccdbcb1 A new implementation of sqlite3VdbeMakeLabel() is faster and makes fewer 
memory allocations by deferring memory allocation until 
sqlite3VdbeResolveLabel() is called, at which point the code generator has
a better idea of how big the relocation table needs to be.
The sqlite3VdbeMakeLabel() routine now takes a Parse* parameter instead of
Vdbe*.

FossilOrigin-Name: 4a0929ac76d8aa5dd65eac3b83d6bbf41e505e01d175ca0fb2b19ba02d439415
 2018-12-29 02:26:59 +00:00
drh
01e92df41e Merge performance enhancements from trunk. 
FossilOrigin-Name: 0f1b9ff9e1e6f13e03045fcb7d0907227085054f9eb0b0b8471fb26b0094b13a
 2018-12-28 21:32:35 +00:00
drh
81f9159b5e Faster allocation of new sqlite3_stmt objects. 
FossilOrigin-Name: 891f1f72187f0f9ec0d24fda98cc08be3ae3c3ff8b27c4e409ee7135c3106398
 2018-12-28 20:48:07 +00:00
drh
b6991796b4 Move the nOpAlloc field from Parse into Vdbe to avoid an extra pointer 
deference on the fast path in sqlite3VdbeAddOp3().

FossilOrigin-Name: 8f10efc29dea7b816b1ba401726c268950d6671d890f686911269082a241d8d9
 2018-12-28 20:14:03 +00:00
drh
64919e9b00 Merge patches and enhancements from trunk. 
FossilOrigin-Name: da53f3d3ff26cc32d3a5ac788b6785baa3d1688e50d9354025a3130dc7e71a38
 2018-12-28 19:23:20 +00:00
dan
4177c8a2b7 Fix another problem with loading the structure record from a corrupt fts5 
database.

FossilOrigin-Name: c4d44542d259bbec11aea60ae94fcb4acd53e97e125723cae078cf0f8873f8ef
 2018-12-28 18:09:45 +00:00
dan
1d4b16405b Fix a problem causing the sqlite_master entry corresponding to a virtual table 
to be removed by a DROP TABLE even if the call to the vtabs xDestroy() method
failed.

FossilOrigin-Name: 0140f6dbfbea93eadcd7f727d84064a0c0d1f0806dbe3e5ef1017da603157e3b
 2018-12-28 17:45:08 +00:00
dan
d445ed094a Add new test file wal2rollback.test to this branch. 
FossilOrigin-Name: 85a376fc6c77117b96814df800b3d68a441d69602ffc2eb8cd7dba29f25d69aa
 2018-12-28 16:20:53 +00:00
dan
eefc72d12f Avoid an undefined left-shift operation in fts5 caused by malformed utf-8 
text.

FossilOrigin-Name: c3a3a11194586bef80a9d7ca54caae8af30d4e7b464b8bb3d257ba2d2ec4791f
 2018-12-28 14:33:55 +00:00
dan
666636b6de Fix a buffer overwrite in fts5 triggered by a corrupt database. 
FossilOrigin-Name: a385298df264dbfa6765f63ad8708f74bc8e8a1404239c1049890b39a1bda888
 2018-12-28 13:57:30 +00:00
dan
b163b57212 Fix problems in fts5 found by ASAN. 
FossilOrigin-Name: c564bf870106faef297594a51995619c80311d06bd5f8a0c7644f666f22ba576
 2018-12-28 07:37:22 +00:00
dan
593c716781 Fix another problem with corrupt database handling in fts5. 
FossilOrigin-Name: fb0d7fba07865ff557bfcdacfda7b625d099ac8b4dcbe0c08cd2d4b84a068bb9
 2018-12-27 20:12:02 +00:00
dan
30db882a87 Merge latest wal2 changes with this branch. 
FossilOrigin-Name: ea96001e801fbf228d1fb63b9d3c73fd9da54994d3cfe383ea76edfa6da83b8d
 2018-12-27 17:11:59 +00:00
drh
aa243aa7cd Modify the btree02.test module so that it does not depend on whether TCL 
interprets a value as a string or as an integer.

FossilOrigin-Name: d9e4f9574659c6285deba3dca68eca9989e615971cea3a901ffcda12fb4ee36f
 2018-12-27 16:55:01 +00:00
dan
ce909d1aae Increase test coverage of wal.c provided by permutation "coverage-wal" on this 
branch.

FossilOrigin-Name: 2f7f893a702728745445f6ef5f914c1157058a8fbdfd1a58cfb8906e5566729d
 2018-12-27 16:49:33 +00:00
dan
e80834f6ff Fix another problem in fts5 caused by a corrupt schema record. 
FossilOrigin-Name: ff45f9dd69fe1e1c7875e5bb73ac3dde2a31746475d3765cda9233f8e06e26ca
 2018-12-27 15:36:16 +00:00
drh
57e141bc28 Fix the filename normalization in the dbtotxt utility program. 
FossilOrigin-Name: 29a00a05dd40ff59be340969e1aca4fee41e092f2faa1cea85a3448265a83c2c
 2018-12-27 13:52:45 +00:00
dan
cd80dc3667 Fix a null-pointer dereference that could occur in fts5 with a corrupt 
database.

FossilOrigin-Name: b0a49d5e6df116bb5eacb60a0bb0f482760aec38bd417d4250d9e57d43bdbb13
 2018-12-27 07:46:37 +00:00
drh
bdefaf08ee Fix a problem in which nested CTEs with the same table name trick the 
code generator into thinking they are the same CTE, which then tries to
use the manifest them both into the same transient table.

FossilOrigin-Name: 202dd033019dd27428e3cc5f6e164c95b37efe39e2753515112b201ddefca67b
 2018-12-27 02:16:01 +00:00
drh
7eb2c9176a In the treeview debugging output, 
provide additional details for the Table object
associated with each FROM clause term.

FossilOrigin-Name: 11d4682d2eec133ccca99ca9cf2620cd249b4afe55918f3ebf93b454431f9c55
 2018-12-27 00:30:42 +00:00
dan
0f297b6e50 Improve testing of the wal.c changes on this branch. 
FossilOrigin-Name: 63483e22c775183e01924b5cb3d0f3655b63c3cdd06faf26cacd4d0913c0055c
 2018-12-26 20:42:32 +00:00
dan
2d111c8bbb Merge latest trunk changes with this branch. 
FossilOrigin-Name: 404f9d99d325ddf82fde6d957860d30b2fb67f232c0878a3cf6df9596541f16e
 2018-12-26 19:10:59 +00:00
dan
f6febee0e2 Update the coverage-wal permutation to cover branches enabled by 
SQLITE_ENABLE_SNAPSHOT.

FossilOrigin-Name: 6821c61f1d71be2be7f867e59fd94582a1eaf45a4d1fb88be995807a77cc22ea
 2018-12-26 18:34:56 +00:00
dan
89dec01e48 Add a few more test cases to walvfs.test. 
FossilOrigin-Name: 14a64df36efe0dc36795311d58385f9c65dc465b214059e07c2ee6b95ea99c87
 2018-12-26 17:49:57 +00:00
dan
0f55a571fc Avoid an "unitialized value read" problem in fts5 that can occur with a 
corrupt database.

FossilOrigin-Name: 6cae81cd1ffb0180e0260d5ba921502c7dee2f54637bff3558a4d1cb5dfd3f32
 2018-12-26 16:57:47 +00:00