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,542 Commits 1,785 Branches 392 Tags
server-edition
Commit Graph

17542 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
dan
6b0cfe5343 Fix bugs in test program tserver.c. 
FossilOrigin-Name: 093b9108ea3532437683547c82f756df2413013a50a2fddad3d928cf8d74f9eb
 2017-06-28 20:12:41 +00:00
dan
bab38cbc9a Ensure that test tool "tserver" finalizes all statements before attempting to 
close a database handle.

FossilOrigin-Name: d8568aacf083b63cdcf68d744ddb07a7615d14f169be6c632813a266a1e8a1cf
 2017-06-20 19:20:07 +00:00
dan
538ed8e376 Add too/tserver.c - the implementation of a simple multi-threaded server 
designed for interactive testing of concurrency between connections used by
different threads of the same process.

FossilOrigin-Name: 05b4fc4340011847c8585bb822d339dd7b8351266a12b26fdc85edce38fc9dd3
 2017-06-07 15:55:59 +00:00
dan
b4c4601adf Add code to this branch to emit a log message after each cumulative second 
that the WRITER lock has been held.

FossilOrigin-Name: a726d98122704e1e702cfa7ae61d680497df6a826d98082161e0823e115d40a5
 2017-05-22 08:01:58 +00:00
dan
60dd40a62c Avoid writer starvation by adding a RESERVED state to page locks. 
FossilOrigin-Name: 9b7f80246f2b9921483ab23457865e783ee70b93f67bcecc0c16516447a05875
 2017-05-15 19:32:58 +00:00
dan
2ac63b9812 Avoid running recovery while there is another read/write client. 
FossilOrigin-Name: a38858a24c6edaa05966b7e158e603bcbde8b05c6233e3bb005cfb32bc91ea06
 2017-05-13 19:07:10 +00:00
dan
bf431367f3 Require exclusive access to the db to wrap the wal file. Have "PRAGMA 
wal_checkpoint = restart" block for this.

FossilOrigin-Name: cbf44ed9758d577e1450b53e645b73c9ca1ee29d2354ce6375c234a41a063400
 2017-05-12 18:52:27 +00:00
dan
730859568d Fix a problem causing a lock to be held past the end of a transaction. Use a 
blocking lock to take the read-lock on page 1 taken by all transactions.

FossilOrigin-Name: 2584df3d42ece69d37f31f3655cd0d4760914bea73d4f4ccb7f2a7aa47f80f49
 2017-05-10 16:18:05 +00:00
dan
c9bcad12ea Use a blocking call to obtain the wal-mode WRITER lock in some cases. 
FossilOrigin-Name: 4464ca1d686b5c457995cc885d4a8704e402ad387aa4cc37de199276b28cc08e
 2017-05-10 13:46:29 +00:00
dan
e376cac1d1 Fix a problem with wrapping the log file in server mode. 
FossilOrigin-Name: 270b7d1eacb57827465946262b31c5c890d7fc5b5618ccd9e220bc2f9546de54
 2017-05-09 16:32:19 +00:00
dan
b7bcf5c16c Add some support for wal mode to the hack on this branch. 
FossilOrigin-Name: b733afc1d0abc09861903ce8e27a8f2462ec871967f5d3dc2847b31bb28b55f3
 2017-05-08 20:15:23 +00:00
dan
31349393ba Update this branch with latest trunk changes. 
FossilOrigin-Name: ed6bad67f530afa2fba1bce339a9772f281bd108666ca6c23642efcefa2d98e5
 2017-05-06 16:04:58 +00:00
drh
050b124ce2 Fix a collision of the "B0" identifier name between the termios.h header 
file and the SHA3 implementation in the shell.

FossilOrigin-Name: b9a58daca80a815e87e541cb5fff9bc8b93f131d223f322c5b83dd5a5f0c0312
 2017-05-04 11:13:50 +00:00
drh
30f01249a3 Remove the unused "sqlite3_stack_used" TCL command from the test harness. 
FossilOrigin-Name: e24b73820cdca07eee87853fe6dd9f60d76e039eeb4aebef03654db3c7c94f14
 2017-05-03 19:36:50 +00:00
drh
313e6fd222 Fix the sqlite3GetInt32() function so that it correctly returns 0 on a 
zero-length input string.

FossilOrigin-Name: 05eba9e3a5f9bb2a40af1dacd885e1915fbcd20b9af4cf0eed79ac16dbeba31b
 2017-05-03 17:44:28 +00:00
drh
ad012d09dc Always enable URI filenames when compiling with SQLITE_HAS_CODEC. Also allow 
plaintext keys using the key= query parameter.

FossilOrigin-Name: 31a51b4d168065fa59cc0e52ba798bd87ac82160c675bd531442b65133edb401
 2017-05-03 15:54:53 +00:00
drh
e780764b4e Fix the fts3EvalAverageDocsize() routine so that it returns errors from 
sqlite3_reset() rather than always returning SQLITE_OK.

FossilOrigin-Name: 430f539cbb3f806fb89191e0b759a5f8b49d9e5b6c95fe9a4b55a1aa0875762a
 2017-05-02 18:00:31 +00:00
drh
3f4df4c6f3 Reuse the same materialization of a view when that view appears in a query 
more than once, such as in a self-join.

FossilOrigin-Name: 9e35c89dbe744312f612e507b51ff9a5bb656def75392d25bc19fc638548cd1e
 2017-05-02 17:54:19 +00:00
drh
a1f5c0c90b Move terms of the HAVING clause that reference only columns in the GROUP BY 
clause over to the WHERE clause, resulting in a faster query plan.

FossilOrigin-Name: 47cbb471d056c8e1834a5ca72491404a3bfb273b5ff7bdd84b98d263938ea874
 2017-05-02 16:55:07 +00:00
drh
ab314001b8 Additional comments on the sqlite3ExprIsConstantOrGroupBy() routine. No 
code changes.

FossilOrigin-Name: 8424492eac506866d2918e5fe03c8f65fef960215d56012a3b52ed42789ed35a
 2017-05-02 16:46:41 +00:00
mistachkin
8d5cee166e Fix typo in comment. No changes to code. 
FossilOrigin-Name: 6674814afb9e763e7f7060776586e26da28040b3208ce06c8a285dd647e5a53d
 2017-05-02 01:30:44 +00:00
dan
8df9974169 Update this branch with latest trunk changes. 
FossilOrigin-Name: 83b1e163ef6ac01d252268415f26a2a999670de583491becc091d294075980bc
 2017-05-01 20:07:59 +00:00
drh
c478c8daec Remove an unnecessary branch. 
FossilOrigin-Name: a33179596f534067a58d68b77160f11ab13272b29f912d7cbe15ea00bbf03ade
 2017-05-01 19:53:12 +00:00
dan
4b2667c8b8 Enhance "PRAGMA integrity_check" to detect duplicate rowids within a leaf 
page.

FossilOrigin-Name: adcad37b001d255299be716b16003b56ec1fba349ef73261ee0e543186c4f311
 2017-05-01 18:24:01 +00:00
dan
874080bbb6 Clear the BTCF_ValidNKey flag set if a cursor is moved by 
sqlite3BtreeInsert(). Fix for [f68dc596c4].

FossilOrigin-Name: a6727eef6d757a39ad23e5c8cbe960f5d909e5d37cb4e90bc3bdbb8bf58cd6f8
 2017-05-01 18:12:56 +00:00
drh
ed71298085 Futher bug fixes to the function that determines when a materialized view 
can be reused.

FossilOrigin-Name: c64fe3a1695925693385d313e9ad2a1d8cb37ddaa8cc19920ae0978c91bc4c2c
 2017-05-01 17:04:35 +00:00
drh
33543c237b Minor bug fixes and performance enhancement. 
FossilOrigin-Name: b2aae559581d05e4e8caaddfbd137cb275d582e82d58872c6f42e462dc859b1c
 2017-05-01 16:37:20 +00:00
drh
e08e8d6b61 Initial implementation of an optimization that attempts to reuse the same 
materialization of a view on a self-join of the view.

FossilOrigin-Name: 478c34b9a8b5127d13024e10307aa832f160b89720c46424dd17555bd36f590d
 2017-05-01 15:15:41 +00:00
dan
181a1167dc Add extra tests for the optimization on this branch. 
FossilOrigin-Name: 4921cd9520080f9baff70e548f64a56e2204b398b8397a2d318a98c32ec4b00c
 2017-05-01 14:09:32 +00:00
dan
ab31a8450b Automatically transfer terms from the HAVING clause to the WHERE clause of an 
aggregate query in cases where the result of evaluating the term depends only
one one or more of the GROUP BY expressions (and on no other inputs).

FossilOrigin-Name: 5375a3ce56f1d993b13b469fe33ec7679948f53940f62a15ddbaeb8aaa26a22c
 2017-04-29 20:53:09 +00:00
drh
7555581fc1 Add a single testcase() macro to the subquery processing logic. 
FossilOrigin-Name: 4e1df76e3d85922648e0e1cce73a266c3b1ed4511ace259ec0a01d7693af9e6f
 2017-04-29 19:29:49 +00:00
drh
bb6783b86f Improvements to opcode documentation in the bytecode engine. 
No changes to code.

FossilOrigin-Name: e54c9f8db5b2fa8ea82c6eab7482255431af16901f7992c9667b56a0e50a9f4f
 2017-04-29 18:02:49 +00:00
dan
f427296520 Avoid reading the file-size before page 1 is read-locked. 
FossilOrigin-Name: f6b025bf632501f51e691a05d309225671fd78bc62c9a43dd916d35ba4cf6d0e
 2017-04-29 15:48:32 +00:00
drh
bc43995f99 Evaluate WHERE clause terms that reference only the index before evaluating 
terms that require the table, and thereby avoid seeking the table row if
index terms are false.
This is called the "push-down" optimization in the MySQL world, we are told.

FossilOrigin-Name: d7bb79ed3a40419d143fbe35c310e51fe7b384a22f082a61ad788671d2d33ee0
 2017-04-29 15:27:04 +00:00
drh
6ab3eb5d0e Minor size and performance improvements to the push-down optimization. 
FossilOrigin-Name: 91dfb61a1a25763bb0b5c1e353a9d584bc6de3f6eb445f54202ffe7f6fee6e8d
 2017-04-29 14:56:55 +00:00
dan
6f654a40e8 Within a loop that uses a non-covering index test, test non-indexed terms that 
can be tested without seeking the main table cursor before those that cannot.

FossilOrigin-Name: afe68f0a8060dc5c92cb1fb32a9f22bd36140cd2c0bb5b6cea853e169c5ed444
 2017-04-28 19:59:55 +00:00
dan
920a129de3 Fix various bugs revealed by running performance tests. 
FossilOrigin-Name: a40b42c422a53aa99280eca7ba419a3937699e273efa3377e0fefe52582cbbd4
 2017-04-28 17:32:57 +00:00
dan
34d02325be Add a missing releasePage() call to the server-mode free-list management code. 
FossilOrigin-Name: a5a085483c66b17727cf4d2a15165621016031ab78990cb5977ccdbd231d13ac
 2017-04-28 14:09:55 +00:00
dan
aa189cf00f Use a different free-list format for server-mode databases in order to reduce 
contention.

FossilOrigin-Name: 778e8a102d8dc7b0fa006c2d90b0a8cd36ebc1e16bd17477f2d536fc0cef4bf3
 2017-04-28 10:20:03 +00:00
dan
2dab053e22 Do not write master journal filenames into server-mode journal files. Use 
SQLITE_MUTEX_STATIC_APP1 to protect critical sections in server.c.

FossilOrigin-Name: 3144ae40d2eb63dfd5587579a49163ea1add5947d624daa478ada13339495af4
 2017-04-27 14:12:43 +00:00
dan
0561247d07 If possible, delete the journal file when a database connection is closed. 
FossilOrigin-Name: d5b5326df25b85b1c3926cd693bcde1ca08e6e03b8aea151a82d222fc9c23dd6
 2017-04-27 13:05:43 +00:00
dan
1381bbc262 Experimental implementation of pessimistic page-level locking based on 
rollback mode.

FossilOrigin-Name: 64ecf7c7e512827e8a5a42f9f3ad92ff57ec868820e3943dbc74d5823f9a889d
 2017-04-26 20:45:00 +00:00
dan
4b17369579 Add new test file cachespill.test. 
FossilOrigin-Name: 2d0b64316d66a362f5891ceb71a1fd8e4607732274b09b0a8472b97eef68ebc2
 2017-04-26 17:21:33 +00:00
dan
b9e6a73866 Replace <fts5.h> with "fts5.h" in test file fts5_test_tok.c. 
FossilOrigin-Name: 63d9ca5c7392e1efe3330689fe750310a952287e843b3242178724e8561fae0e
 2017-04-26 14:34:04 +00:00
drh
69bfa55279 Fix a subtle bug in Lemon discovered and reported on the mailing list 
by Kelvin Sherlock, who also suggested the correct fix.

FossilOrigin-Name: 304689f8acb53d68e1afed6e6c4332e78132e3d57071b8f94df0d13515b3b3d8
 2017-04-26 04:32:17 +00:00
dan
a1188d6d93 When building an ephemeral table of integers, do not assume that the table 
does not already contain N if the insert cursor points to N-1. Fix for ticket
[61fe9745].

FossilOrigin-Name: 1c1b0862236f564283be08338790d6494e705f1198547a59499e3f8c07f2cd99
 2017-04-24 14:16:55 +00:00
drh
0c3233be0b Fix an assertion fault found by OSSFuzz. 
FossilOrigin-Name: e39769f442ea86273f8fb7bd2f249b7d760b2fe4bf9ec191ff91def8231f3f35
 2017-04-22 00:20:49 +00:00
dan
39c9d3a367 Remove a NEVER macro for a condition that may be true as of [a47efb7c]. 
Problem reported by OSSFuzz.

FossilOrigin-Name: bdc50d8d127266d02b291f6bfcd4e35eb07994ce23987d6e3921124cd881929a
 2017-04-21 17:03:32 +00:00
dan
0619838c55 Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a 
database that contains delete-markers to return extra, non-matching, rows.

FossilOrigin-Name: 840042cb2bed2924e2263f21887317f661e5a585c4466c3af25b91ed57a6b49b
 2017-04-21 16:04:18 +00:00
dan
dc62daca86 Further improvements to coverage of fts3 module. 
FossilOrigin-Name: 6b21d0fdebdccfaf63590d9ca9a279c22b8baec07c1a669b9f617f25bd857384
 2017-04-19 13:25:45 +00:00