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

19158 Commits

Author SHA1 Message Date
drh
7c2fbdeba2 Add new test cases to increase coverage of where.c. (CVS 6138) 
FossilOrigin-Name: 2e1ab51f05447f9c1f291636b53b1ec584003841
 2009-01-07 20:58:57 +00:00
drh
5bd98aef66 Fix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137) 
FossilOrigin-Name: fe90e9116b6e1e25cf3119d2777a8e9c135153ce
 2009-01-07 18:24:03 +00:00
danielk1977
f70c1fee96 Make the same change as (6121) (accidentally reverted). Also enhance test_journal.c to catch this kind of bug. (CVS 6136) 
FossilOrigin-Name: ccc9c211a285fd4da68b69e15594f080371be522
 2009-01-07 18:08:48 +00:00
danielk1977
a7c17af64d Change SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket #3567. (CVS 6134) 
FossilOrigin-Name: 1fe79ffd772900bdca85ec6cf072677be53cd5ff
 2009-01-07 16:15:42 +00:00
drh
ee03d629f5 Conjecture: a journal header with nRec==0 must be the last header in the 
journal.  Add asserts to make this conjecture explicit. (CVS 6132)

FossilOrigin-Name: 15b5b5f90c2ffa79155cdc2dbc4fb5583cb72017
 2009-01-07 15:33:45 +00:00
danielk1977
f90b7260b3 Fix for 'truncate file' operations on in-memory databases. (CVS 6131) 
FossilOrigin-Name: 83d1eafbde556f56969c6f285b6767d2c658dbfc
 2009-01-07 15:18:20 +00:00
danielk1977
9153d850cc Add a comment to the openSubjournal() function in pager.c. (CVS 6130) 
FossilOrigin-Name: 04387ae10ab3be24c93497f4af6f48d6832f37eb
 2009-01-07 10:52:56 +00:00
danielk1977
1fab7b6664 Fix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint on an auto-vacuum database. (CVS 6129) 
FossilOrigin-Name: 3a4bb83235e9a79297e7d5d47ac7674c9df960bf
 2009-01-07 10:35:18 +00:00
danielk1977
fc158bf920 Fix savepoint related bugs. A rollback caused by an IO error or "OR ROLLBACK" clause while one or more savepoints were open was leaving the sqlite3 structure in an invalid state. (CVS 6128) 
FossilOrigin-Name: e5d42c69a3b325ca12f53184e33964230acbdd1f
 2009-01-07 08:12:16 +00:00
drh
f2a84e3ca6 Add a HIGHSTRESS parameter to the sqlite3_config_alt_pcache debugging 
command in the test harness - to force calling pagerStress() more
frequently. (CVS 6127)

FossilOrigin-Name: e426860b94f5b47e3a265549dbac64a421cae425
 2009-01-07 03:59:47 +00:00
drh
d6e5e09816 Pager changes attempting to verify that ticket #2565 cannot recur. (CVS 6126) 
FossilOrigin-Name: 15b9dac455b3f457bb177fc4985b45957647cbec
 2009-01-07 02:03:35 +00:00
danielk1977
076dce5336 Reduce the number of paths in btreeCopyFile(). (CVS 6124) 
FossilOrigin-Name: df2c285cb99ac188c96dd1a4e6a30f689195a150
 2009-01-06 18:21:08 +00:00
danielk1977
cd1cbff38b Modify test_journal.c to verify the page data being written to the journal file. (CVS 6123) 
FossilOrigin-Name: 0d258956f8971c0af7853b836a7d6e7f3a800c37
 2009-01-06 17:52:43 +00:00
drh
30d537011a Cleanup of the PAGERTRACE macro. Other comment changes in pager.c. (CVS 6122) 
FossilOrigin-Name: ee7b4b60880e80e6fb0b2f93ebc6ee5ad6917f9d
 2009-01-06 15:58:57 +00:00
danielk1977
be9c0ab276 The fix in (6120) wasn't quite right. This fixes it. (CVS 6121) 
FossilOrigin-Name: ddc2ebfa529b15cdbdd3b6b6d4873cb085cfd3b9
 2009-01-06 15:28:34 +00:00
danielk1977
f9bce3c54d Fix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120) 
FossilOrigin-Name: 2cdbb468ed81d35a7e1a580683864de60e103083
 2009-01-06 15:20:58 +00:00
danielk1977
401b65ed77 Fix a memory leak in test_journal.c (test code). Also remove function pager_truncate_cache(), a wrapper around sqlite3PCacheTruncate(), from pager.c. (CVS 6118) 
FossilOrigin-Name: a64f3db0b39af53c8d8f80c242baa8aa4b5bd04e
 2009-01-06 14:34:34 +00:00
drh
1c8781f43b Fix compiler warnings. (CVS 6117) 
FossilOrigin-Name: da770a8dff183b28aca287cafb9c8b82b98ea968
 2009-01-06 14:19:36 +00:00
danielk1977
f2c31ad8af Add some savepoint related test cases and fix a few problems. (CVS 6116) 
FossilOrigin-Name: 8c62ea4fded2251e9daf16f2a050f94359299d76
 2009-01-06 13:40:08 +00:00
drh
813f31eafe Fix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114) 
FossilOrigin-Name: a7015625610624be1645e918d0a62cf85bec86ce
 2009-01-06 00:08:02 +00:00
drh
de58ddb709 The fix in (6111) was not quite right. This version works better. (CVS 6113) 
FossilOrigin-Name: 5f80140a2df48fd43a7cbc0990de0205004541b0
 2009-01-05 22:30:38 +00:00
drh
66cd1822fe Reenable fuzz testing for all.test. Make sure the query flattener copies 
over aggregate information from expressions on outer query terms while
flattening. (CVS 6112)

FossilOrigin-Name: e02323b3629545a3e7e7db0d4edc76807ae903aa
 2009-01-05 19:36:30 +00:00
drh
68ac65ecdc Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111) 
FossilOrigin-Name: b2131e868a3a948ba81f7458270493085da1ae60
 2009-01-05 18:02:27 +00:00
danielk1977
0d519ca883 Fix some test code problems in "permutations.test journaltest pager.test". (CVS 6109) 
FossilOrigin-Name: cf627752c4537f709acae26a1e335731d55bddb2
 2009-01-05 17:15:00 +00:00
drh
853799a26e When the commit_hook calls a query recursively, make sure the commit_hook 
is not invoked recursively.  Ticket #3564. (CVS 6107)

FossilOrigin-Name: 27ae406537c07073db46ecde40c65c78fbb73170
 2009-01-03 14:04:38 +00:00
drh
a8a71bac3f Fix a typo in a comment. (CVS 6106) 
FossilOrigin-Name: 50f57cd1456f18919a8c90efa05da446ae12788d
 2009-01-03 12:55:17 +00:00
drh
7539b6b81a Memory allocation failure in Bitvec are probably all benign. Still, add 
code to check this, just to be sure. (CVS 6104)

FossilOrigin-Name: 4688e1c8b1203c3538aa862421ed344888059fe2
 2009-01-02 21:39:39 +00:00
drh
9f0bbf9cae Reinitialize page 1 of the database file following a ROLLBACK TO of a 
transactional SAVEPOINT on an initially empty database. (CVS 6103)

FossilOrigin-Name: 3e9efb763875b20c856d748c19e449080a3ae97c
 2009-01-02 21:08:09 +00:00
drh
49b9d33892 Fix compiler warnings in pager.c (CVS 6102) 
FossilOrigin-Name: 78dd7909da15a9b2cbcdb9cbe86798cfc24f3230
 2009-01-02 18:10:42 +00:00
danielk1977
cd38d520d1 Modify the (transaction) method of the tcl interface to use savepoints. This makes nested calls to (transaction) work more intuitively. (CVS 6101) 
FossilOrigin-Name: f047758de9b499866aa4ddf16011498b12a7b963
 2009-01-02 17:33:46 +00:00
danielk1977
c81806f3ed Fix a (benign) valgrind error that can occur following malloc failure while executing a 'ROLLBACK TO savepoint' command. (CVS 6096) 
FossilOrigin-Name: 9ff8598f3be123a244f71b45e77af913b836504a
 2009-01-01 15:20:37 +00:00
drh
04bbcd5ce9 Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" 
commands from test scripts. (CVS 6086)

FossilOrigin-Name: b090d5736d7eaec17a39d3133e1587b1d2a42acb
 2008-12-30 17:55:00 +00:00
drh
46129af9fb Get EXPLAIN QUERY PLAN working with the multi-index OR optimization. 
Added new test script "where9.test". (CVS 6084)

FossilOrigin-Name: 4b6460221011e02bedb724169e8e4793e539e65a
 2008-12-30 16:18:47 +00:00
danielk1977
9357416a25 Add a few more tests to where8.test. (CVS 6081) 
FossilOrigin-Name: ac28aa8b618d59628c5b8fc6fe649ec14f554b11
 2008-12-30 15:26:29 +00:00
danielk1977
5f0ff5d527 Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077) 
FossilOrigin-Name: 35c87585b81866e73a58adffe6af79ddcac57cf6
 2008-12-30 12:00:12 +00:00
danielk1977
992347f2ed Fix a bug in where.c causing a malfunction when an INDEXED BY clause specified an unusable index on other than the leftmost table in the FROM clause. Ticket #3560. (CVS 6076) 
FossilOrigin-Name: f8ff0212129ce602a1e1e9ad702c47b9302f2f21
 2008-12-30 09:45:45 +00:00
danielk1977
ab9b703fde Invoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE commands. (CVS 6074) 
FossilOrigin-Name: e49807b16f7f86d3f2290d6c1f7562f3db6330f9
 2008-12-30 06:24:58 +00:00
drh
954701a054 Always make sure WhereClause objects are initialized to zero when they 
are first allocated. (CVS 6073)

FossilOrigin-Name: 7d0ae55d6b2d263382f034eb89bbc368fab6a9bc
 2008-12-29 23:45:07 +00:00
danielk1977
fdc4019b46 Add test file where8.test. (CVS 6072) 
FossilOrigin-Name: bff460ec2c3e250de034a6b34312b897bb2f3749
 2008-12-29 18:33:32 +00:00
danielk1977
381a4a4882 Remove an old variable declaration that was commented out using a C++ comment. (CVS 6071) 
FossilOrigin-Name: 0b972f14f00340cbd4e310dea6d1a4f1c05f5628
 2008-12-29 14:51:05 +00:00
danielk1977
f73ab8b8a9 Set the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070) 
FossilOrigin-Name: 03d0350441ef5fa5a9f22fcb0b760200614cf9f9
 2008-12-29 10:39:53 +00:00
drh
ca8c4667a8 Multi-index OR optimizer response to ORDER BY rowid. 
But fix in sqlite3_stmt_status(): report a full table scan
when "ORDER BY rowid" is used without constraints. (CVS 6069)

FossilOrigin-Name: 3464d369d3b6899ec726cf5b42b68b1dac2ba982
 2008-12-28 20:47:02 +00:00
drh
294352578e Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands 
of an OR. (CVS 6068)

FossilOrigin-Name: 67cf24b30e087796cfb0fccf47328e72ade5ecdc
 2008-12-28 18:35:08 +00:00
drh
6df2acd216 Simplify the VM code that implements WHERE claues. (CVS 6067) 
FossilOrigin-Name: fa95f843e179a38f663978d675607c4c3037928d
 2008-12-28 16:55:25 +00:00
danielk1977
3460d19c85 Fix a problem with savepoint and incremental-vacuum. (CVS 6066) 
FossilOrigin-Name: 08352f9ea9d2a1759320efc46e418079000855cb
 2008-12-27 15:23:13 +00:00
danielk1977
45783d0148 Reset the column cache before coding each step of a trigger program. Candidate fix for #3554. (CVS 6065) 
FossilOrigin-Name: a1b1f6cd7d2c060bd75ce39347e1220b872806ed
 2008-12-26 07:56:39 +00:00
danielk1977
8044294743 Fix a virtual table related assert() that can fail following a malloc failure. (CVS 6064) 
FossilOrigin-Name: c6fd3b8f29927c0fc634f82885f144c78f0105d9
 2008-12-24 11:25:39 +00:00
danielk1977
a641748220 Fix a couple of problems in test file test_journal.c that were causing segfaults when running all.test. (CVS 6063) 
FossilOrigin-Name: 416c9efb49ba207a9a79d06d0b13854695a8876c
 2008-12-24 09:30:22 +00:00
drh
23d04d5a20 Continuing improvements to the multi-index OR-clause optimizer. Added a 
few simple test cases. (CVS 6062)

FossilOrigin-Name: 55d4f493e7df8515574a75caec9967d6c71b6012
 2008-12-23 23:56:22 +00:00
danielk1977
67ddef6922 Fix a problem with the savepoint code and in-memory journals. (CVS 6061) 
FossilOrigin-Name: 26ceebf38e7ae7bbda3284995b03f829a2d2493f
 2008-12-23 19:15:56 +00:00