database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-18 10:21:03 +03:00
Code Activity
29,836 Commits 1,610 Branches 185 Tags
json-opt
Commit Graph

9709 Commits

Author SHA1 Message Date
drh
def3367e50 Add the percentile() SQL function as a loadable 
extension in the ext/misc directory.

FossilOrigin-Name: a64d760d9290b1be78cdda7ae66d4f02c3b3fa53
 2013-05-28 20:25:54 +00:00
dan
87ddfeb079 When writing to an FTS table, take an exclusive shared-cache lock on the %_segdir table before writing. Otherwise, an xCommit() call may report an SQLITE_LOCKED error. 
FossilOrigin-Name: 3cd2da42e9403b1e6243ad53f3f2bbf89c0fb9b0
 2013-05-27 10:11:53 +00:00
drh
7c4ac9860c Merge the latest trunk changes into the NGQP branch. 
FossilOrigin-Name: 7c8f992c04504a132686ad0652efdff19e43480d
 2013-05-24 13:55:23 +00:00
dan
7a7083cf70 Have the "make fulltest" command run the "mmap" permutation test. 
FossilOrigin-Name: 82ad373f85aa0a87d24c6dbb2ea7dca8c5aff56a
 2013-05-23 10:15:46 +00:00
drh
34e258c942 Cause the mmap_size PRAGMA to immediately change the mmap space if the 
database connection is already active.  In particular, reducing mmap_size
will immediately free up process address space.

FossilOrigin-Name: 761177927cb51e4f5e66061ca39cf37edbe8346b
 2013-05-23 01:40:53 +00:00
drh
ef86637655 Use the NGQP plan for EXPLAIN QUERY PLAN output. This change causes 207 
errors in veryquick.test, many of which are benign.

FossilOrigin-Name: f783e8e6b10de44029c7c5f57e4648a4a677ca1b
 2013-05-22 20:49:02 +00:00
drh
a50ef114f4 Improvements to ORDER BY handling in the NGQP. Fix an "exit" mistakenly 
left in a test script during the previous check-in.

FossilOrigin-Name: 12c709b4369c7d94d7fb743d0d0da7a9350a3d16
 2013-05-22 02:06:59 +00:00
drh
d15cb17174 Enhanced "wheretrace" output in the NGQP solver routine. 
FossilOrigin-Name: 04dfb85a2a7025d4b5056b73fa8477691323919f
 2013-05-21 19:23:10 +00:00
drh
85b303df54 Update the sessions branch to the official 3.7.17 release code. 
FossilOrigin-Name: fc88f7311ba888015634b89b5909890208f543f5
 2013-05-20 13:01:19 +00:00
dan
cf8489fe2f Add extra "PRAGMA mmap_size = N" statements to mmap1.test and mmap2.test. 
FossilOrigin-Name: cec0a06c17435d5a35e76b52d6901ecda98f9916
 2013-05-17 12:25:00 +00:00
drh
466af9baae Update the sessions branch to the latest 3.7.17 beta. 
FossilOrigin-Name: af8057ef5dcaa72dc0d2ab5d1553b06757449fa1
 2013-05-17 10:58:08 +00:00
dan
4c5aeecc90 Fix minor test script issues causing releasetest.tcl to fail. 
FossilOrigin-Name: d8ded9d8a1052885ce223c70efa55c0dd8b9920e
 2013-05-16 19:15:07 +00:00
dan
5b04dc517a Several releasetest.tcl related fixes to test cases. No code changes. 
FossilOrigin-Name: e97d744ba1138e6c4c1fc657c32f4391ea7479f1
 2013-05-16 14:28:47 +00:00
dan
617dc8602d In sqlite3_close_v2(), do not attempt to roll back a transaction if there exist active statement objects. Any open transaction will be rolled back when the last of these statement objects is finalized. 
FossilOrigin-Name: d11e76072a17fe833b87595d9d79f2c4b0b09cb3
 2013-05-16 11:57:28 +00:00
drh
ad1818d9ed Update the sessions branch with the latest trunk changes. 
FossilOrigin-Name: d09355050a74344c1cb6d303af9f601cd41e2368
 2013-05-15 18:45:14 +00:00
dan
11f71d6ae4 Fixes to allow testfixture to be compiled with SQLITE_OMIT_VIRTUAL_TABLE defined. 
FossilOrigin-Name: 00231fb0127960d700de3549e34e82f8ec1b5819
 2013-05-15 18:34:17 +00:00
drh
f7d2573d7c Merge the shared-cache-fixes branch into trunk. 
FossilOrigin-Name: 5cc1cc55d28a73d390d51fdf6f2c026f1cab1d75
 2013-05-15 17:08:46 +00:00
dan
d58792e0f0 Extra test for commit [6dae62c4e5]. 
FossilOrigin-Name: b10b9e758b171b0f514592bba70c3ecd17c8c47f
 2013-05-15 16:24:46 +00:00
drh
2ab2d55f01 Fix the sharedA.test module so that it does not attempt to run TCL callbacks 
on a different thread from where the interpreter was originally created.

FossilOrigin-Name: 65ff754e3521aa8ee9135d235166cac2a8f57ebd
 2013-05-15 16:08:33 +00:00
dan
d5dd3305a1 Do not run sharedA.test if the system is not threadsafe. 
FossilOrigin-Name: d484eaf8d6dfaf2c1065b93b2a52a6db91c09fa4
 2013-05-15 15:53:52 +00:00
dan
91cf9ba339 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 47dd65a890955f333d431e275f3f4d95d34a5ba5
 2013-05-15 15:42:14 +00:00
dan
911ce41818 When loading a database schema that contains an index definition that includes a COLLATE clause for which the collation sequence is unavailable, do not assume that that index uses BINARY instead. Fix for [0fc59f908b]. 
FossilOrigin-Name: 6dae62c4e505a9a1a22c2771ef3e1921407c4748
 2013-05-15 15:16:50 +00:00
dan
6743081784 When closing a connection, avoid tripping active cursors belonging to a different shared-cache client. Also, if sqlite3_close() is called while there are still active statements belonging to the connection, return SQLITE_BUSY and do not roll back any active transaction. 
FossilOrigin-Name: 6071b7cce067c807e040283fc4b7449dc6eca498
 2013-05-15 10:21:50 +00:00
mistachkin
1654256ac8 Merge updates from trunk. 
FossilOrigin-Name: 6fbad957259eb8c15eaf7e5657240ae24aaf343e
 2013-05-15 08:00:44 +00:00
drh
35cbe7f523 Merge together the fork in this branch. 
FossilOrigin-Name: 164e3d4da20cc16d2a04d602b5a8229e0db99d9d
 2013-05-14 23:13:41 +00:00
drh
85ec3b63d8 Fix an assert() in unlockBtreeIfUnused() so that it checks for the existance 
of an untripped cursor, not for the existance of any cursor at all.

FossilOrigin-Name: a6f851d0fe01d8c8d44a2fe0b716ff7a5194c63b
 2013-05-14 23:12:06 +00:00
dan
bf0e57a7d0 Avoid deleting a b-tree "has-content" vector belonging to another shared-cache connection from within sqlite3_close(). 
FossilOrigin-Name: 93462df78247f5634b9f53752cf80056bbfe9aac
 2013-05-14 20:36:31 +00:00
dan
cd7b91a7f1 Candidate fixes for problems revealed by notify2.test. Notify2.test is still failing at this point. 
FossilOrigin-Name: ea0428f9b6e63066e7444a2ba2f8c12a2e3ab7e4
 2013-05-13 18:23:15 +00:00
drh
644abec3a4 Merge trunk changes into the sessions branch. 
FossilOrigin-Name: 512f8a1ef8c4cf50723cfc4a78b7370dc37358d9
 2013-05-09 23:40:58 +00:00
drh
b3129fa560 Do not move WHERE clause terms inside OR expressions that are contained 
within an ON clause of a LEFT JOIN.  Fix for ticket [f2369304e47167e3e].

FossilOrigin-Name: 1128575d0ab24f7023a0f6e6ce4828b9a09a7c6c
 2013-05-09 14:20:11 +00:00
mistachkin
0bf3bc6c64 Refine and reform all Windows OSTRACE macro usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. 
FossilOrigin-Name: 610425f19008b8b5d4bf027c8b14d97ec3115a54
 2013-05-09 00:40:13 +00:00
drh
2464dee6bc Merge all recent trunk changes into the sessions branch. 
FossilOrigin-Name: ae6c4a0906ad8caabd8c605bb39c5fb979ab39a2
 2013-05-08 18:50:04 +00:00
drh
c01b7306ae Make sure the ORDER BY collating sequences are compatible with the 
comparison collations before using the merge algorithm for compound
SELECT statements.  Candidate fix for ticket [6709574d2a8d8].

FossilOrigin-Name: fc3630cdef6e2cdbfb4e7b373d1a094753e55016
 2013-05-07 17:49:08 +00:00
dan
e8dee7d1ed Modify the fts3tokenize table implementation so that it does not use the SQL function fts3_tokenizer. The user may have installed an authorizer callback that prohibits this. 
FossilOrigin-Name: 0ba67b64de258883e4c43db09e131bb67083855e
 2013-05-07 12:16:48 +00:00
drh
2722898c6c Make sure the authorizer callback gets a valid pointer to "ROWID" for the 
column-name parameter when doing an UPDATE that changes the rowid.
Fix for ticket [0eb70d77cb05bb2272].

FossilOrigin-Name: 26a59bb88d4082758eb281b365b57f9a0c059d89
 2013-05-06 13:22:50 +00:00
drh
ec7ecb8c9a Merge all recent trunk changes into the sessions branch. 
FossilOrigin-Name: 3879ab1b532828fcc12a50a95b6730faebcb69e9
 2013-05-03 18:29:22 +00:00
drh
4ee09b4bcc Allocate 4 bytes of unused header space for an "Application ID". Add 
the "PRAGMA application_id" command to set and query this identifier.
Add the "magic.txt" file to show how the posix file command might use
this application id.

FossilOrigin-Name: 28c9e7fdee2471a3026ee05ff591194d5f398131
 2013-05-01 19:49:27 +00:00
drh
3c449c6b6b Make sure extra parentheses around subqueries in the FROM clause are harmless. 
Ticket [28c6e830f239ea5].

FossilOrigin-Name: 1c79569226db3d5a73e65a35877635ea8b478866
 2013-04-30 14:06:57 +00:00
dan
181f4f789d Fix an off-by-one in the code for limiting the depth of FTS expression trees. 
FossilOrigin-Name: 72ac73189c3577740a77d2ea2fc7118391c0703f
 2013-04-29 17:12:06 +00:00
mistachkin
a3514f1027 Merge mmap test fix from trunk. 
FossilOrigin-Name: 95811877fdcbede4f61269ff1c7a6d9554f669cd
 2013-04-29 09:20:06 +00:00
dan
f054396b38 Fix mmap1.test so that it passes on windows as well as unix. 
FossilOrigin-Name: 52417eac3ecaec2dbbde170334358f5ddbd32501
 2013-04-29 09:17:42 +00:00
mistachkin
56749cd1ba Adjust a WAL test result due to changes in the corresponding return code name. 
FossilOrigin-Name: 9272009f7932b3f18006f73776e36b8ef8770d3e
 2013-04-29 08:58:00 +00:00
mistachkin
4eb9b72151 Update 'fuzzerfault' test for its new module loading command. Fix several test names in 'io.test' and make sure the database gets closed between tests. 
FossilOrigin-Name: e81e9ca11db09424dd310bbc91686a5daa618cb1
 2013-04-29 07:01:23 +00:00
dan
8e4714b303 Avoid unnecessarily reseting the pager cache after committing a transaction that takes advantage of the SQLITE_IOCAP_ATOMIC related optimization. 
FossilOrigin-Name: c47144e98c0a0f9e09780c945de10c57b6a495ea
 2013-04-26 18:36:58 +00:00
dan
0d02dd8292 Merge latest trunk changes. 
FossilOrigin-Name: 4d08e74d34e82f3be588049c9576a5c1008435e7
 2013-04-26 06:58:06 +00:00
dan
aa29c86e49 Rebalance FTS expressions after parsing to limit recursion during evaluation. Avoid recursion when deleting FTS expression trees. Enforce a limit on the depth of an expression tree. 
FossilOrigin-Name: f968d43f80cc2f236e7d09ba1e8278343e2b6976
 2013-04-25 20:34:02 +00:00
drh
ea41dc44c5 Added the nextchar.c extension. Minor changes to the spellfix.c extension 
so that it can be appended to an amalgamation and compiled without duplicating
symbols.

FossilOrigin-Name: 56b9a417f5451631f11c5206d625f11472ee65f9
 2013-04-25 19:31:33 +00:00
drh
c140a6b40d Merge the std-ext branch into trunk. This merge adds several new extensions 
to the ext/misc folder, including transitive_closure, ieee754, and amatch,
and it convers some older src/test_*.c file into extensions in the ext/misc
folder.

FossilOrigin-Name: bbe607c7d17c50b667990360e2ccfab8dd22f161
 2013-04-25 16:52:19 +00:00
drh
8416fc7fc7 Added the transitive_closure, ieee754, and amatch extensions. 
FossilOrigin-Name: 84018099c8715b982cd24ce9221f93c7379e8c08
 2013-04-25 16:42:55 +00:00
drh
b7045ab2ed Move the test_spellfix.c module to ext/misc/spellfix.c. 
FossilOrigin-Name: de556add10150140981a2e34b3712e96a7c262e3
 2013-04-25 14:59:01 +00:00