database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,154 Commits 1,570 Branches 183 Tags
empty-table-optimizations
Commit Graph

9780 Commits

Author SHA1 Message Date
danielk1977
ecfef98536 Fix the crash-followed-by-corruption bug revealed by savepoint4.test. This is actually the same bug as was fixed by (6043). The fix was not entirely correct. (CVS 6047) 
FossilOrigin-Name: 688336266f0aa5630f4f550ae3787a64f39f9cfa
 2008-12-20 08:39:57 +00:00
danielk1977
47e23024b1 Add extra crash test cases that stress the savepoint mechanism to savepoint4.test. Currently, these tests are causing database corruption which (obviously) needs to be fixed. (CVS 6044) 
FossilOrigin-Name: e06a968aa5b17ce12ea179b36a99ad74d274fd2c
 2008-12-19 18:45:52 +00:00
danielk1977
488af09972 Add some crash-tests for savepoint. Fix a bug revealed by these tests. (CVS 6043) 
FossilOrigin-Name: 6f36c16678b6e3baa5a9d9ceba1a756a8034f3e1
 2008-12-19 16:31:11 +00:00
danielk1977
34cf35dac4 Increase test coverage of new savepoint code. (CVS 6040) 
FossilOrigin-Name: d915718d0b346982d686d131a159b67e28fc02a8
 2008-12-18 18:31:38 +00:00
danielk1977
12dd54962d Add savepoint2.test, a file containing savepoint tests similar to tests in trans.test and avtrans.test. And a few savepoint bug fixes. (CVS 6039) 
FossilOrigin-Name: 98a53d91f6c0c2692d3b56687fdaba8eeab0959d
 2008-12-18 15:45:07 +00:00
danielk1977
fd7f045225 Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) 
FossilOrigin-Name: 34b56600ec0c5cd7b5faab265750252bc9850e3e
 2008-12-17 17:30:26 +00:00
danielk1977
33e8903540 Modify fts3 to support a more complex expression syntax that allows parenthesis. The new syntax is not entirely backwards compatible, so is disabled by default. Use -DSQLITE_ENABLE_FTS3_PARENTHESIS to enable it. (CVS 6034) 
FossilOrigin-Name: 7389b9ecb80294569845c40a23e0c832d07f7a45
 2008-12-17 15:18:17 +00:00
drh
a4835e9a45 Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029) 
FossilOrigin-Name: 4685ffccd37456fc527a7f7178885a060b474ad8
 2008-12-15 16:33:29 +00:00
drh
e99fa2af71 Convert the "~" and "NOT" operators to be two-address instructions. 
Ticket #3541. (CVS 6028)

FossilOrigin-Name: ea9b747efb22fd3f679c3ef86ed51986c5ad9436
 2008-12-15 15:27:51 +00:00
danielk1977
01ecbeeb57 Add the example from #3359 to the test suite. (CVS 6027) 
FossilOrigin-Name: 84f8417c0794d3e5cec88f59ea71a7d557044409
 2008-12-14 14:45:20 +00:00
drh
e13fab3ccf Fix the name of the source algorithm in the comments of the script generators 
for the recently checked-in test cases for integer boundary-value testing. (CVS 6026)

FossilOrigin-Name: adba0f3c01ba2407466d0120c411c398218bdaeb
 2008-12-14 02:55:16 +00:00
drh
0dc5124391 Add many new integer boundary value tests. Ticket #3536. (CVS 6025) 
FossilOrigin-Name: 45277238d355caa1fbeea67c6c6d1a8f231eabda
 2008-12-12 19:19:22 +00:00
drh
959403f894 Rework the rowid lookup logic in the query optimizer to fix various 
boundary value problems.  Ticket #3536.  Renamed the OP_MoveXX opcodes
to OP_SeekXX. (CVS 6024)

FossilOrigin-Name: e545490a2828f7f703172dda6d2b9f3342dc134a
 2008-12-12 17:56:16 +00:00
drh
e1991d2a8d Additional test cases for nested subqueries in a WHERE clause. (CVS 5999) 
FossilOrigin-Name: 4f10f19dd1e66cd29b0e1e26506154d670c3bc46
 2008-12-09 13:12:56 +00:00
drh
2bf90f1e64 A subquery in the result set of a SELECT should be able to look into outer 
queries to find variable references.  But a subquery in the FROM clause
should not be able to do this.  Ticket #3530. (CVS 5998)

FossilOrigin-Name: be03fa0543044dc46952695e963d9b82afed892b
 2008-12-09 13:04:29 +00:00
drh
555f8de7ef Fix a segfault associated with the column cache that occurs on nested VIEWs. 
Ticket #3527. (CVS 5989)

FossilOrigin-Name: 490138a2012fcb4c859e1cf12a35e314ec1060d2
 2008-12-08 13:42:36 +00:00
drh
da55c48a9a Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979) 
FossilOrigin-Name: 06d206ef7d5e433ccde347d63dfcd2177545e1fd
 2008-12-05 00:00:07 +00:00
drh
947bd8091b Make sure dot-lock is fully enabled when SQLITE_ENABLE_LOCKING_STYLE is 
disabled.  Fix compiler warnings when SQLITE_ENABLE_LOCKING_STYLE is
disabled. (CVS 5976)

FossilOrigin-Name: 4697249fcc6041ba7d2fb89589c855a8bec71eb2
 2008-12-04 12:34:15 +00:00
drh
715ff30e27 Reorganize the proxy-locking method in os_unix.c. Additional cleanup. (CVS 5971) 
FossilOrigin-Name: 31f6090e22b54d657afc8c23171d000d47850205
 2008-12-03 22:32:44 +00:00
drh
9b35ea62c7 Continuing to refactor os_unix.c. This is an incremental check-in. (CVS 5967) 
FossilOrigin-Name: c13df0311ef4f6a510f42105293f7c53c323fda8
 2008-11-29 02:20:26 +00:00
drh
c5053fb922 Add 19 new assert() statements in btree.c that attempt to detect writing to 
a cache page which is not writeable. (CVS 5964)

FossilOrigin-Name: f9c7359065829b016d8cd04304c02509c254fe05
 2008-11-27 02:22:10 +00:00
pweilbacher
5a1841a18c expected error message has trailing space (CVS 5963) 
FossilOrigin-Name: 165bc2d7658e14eda8b375329e4286dc4d048f3a
 2008-11-26 20:09:14 +00:00
drh
a9bce108be Fix the test condition for the test cases added to prevent regressions of 
ticket #3508. (CVS 5957)

FossilOrigin-Name: 4e94aa3bedc6dba003a2a4ecbba9c11c465eab4f
 2008-11-26 13:44:30 +00:00
danielk1977
36e20936f6 Fix an obscure memory leak that can follow an IO error. (CVS 5956) 
FossilOrigin-Name: 8271229c66c72c344ad7afb901b88d9cdaaa6f43
 2008-11-26 07:40:30 +00:00
shane
481e9f2089 Added test case to in4.test to try and duplicate crash reported on the mailing list. (CVS 5951) 
FossilOrigin-Name: 8502fba37bb13c019252d0a65973a78982ec44aa
 2008-11-24 15:32:00 +00:00
drh
17d46fc7f1 Make sure the error message handler is able to deal with NULL expression 
spans. Ticket #3508. (CVS 5949)

FossilOrigin-Name: ce36b6474a62f0a5b8d82968ca9a171f7143ae31
 2008-11-22 18:28:50 +00:00
drh
107886abe8 Factor out and simplify the canonical pathname logic in the VxWorks OS 
interface. (CVS 5943)

FossilOrigin-Name: adb0aafaa6b1ea06541f653a2559f099fb1b2795
 2008-11-21 22:21:50 +00:00
danielk1977
f730075312 Fix a segfault that can be caused by an INSTEAD OF trigger on a view that includes an expression of the form "table.column" in the select list. (CVS 5940) 
FossilOrigin-Name: 88a09dbb4b54be4010aae767157a1e2002237909
 2008-11-21 16:22:18 +00:00
danielk1977
956f4319be Fix an assert() failure that can occur after an OOM error. (CVS 5939) 
FossilOrigin-Name: 4c765758c18d7aeffe6e1cf658d2847f9460a956
 2008-11-21 09:43:20 +00:00
danielk1977
b247c21c15 Fix the problems demonstrated in tkt35xx.test in a different way to (5936). (CVS 5938) 
FossilOrigin-Name: ddf980a50127a9de35edeca5549f4b51e3f733e6
 2008-11-21 09:09:01 +00:00
danielk1977
3e168ebec2 Add another test case to tkt35xx.test showing that a statement rollback can also trigger the problem. (CVS 5937) 
FossilOrigin-Name: 74c08b8dd9577d1997b4bc8147beed786150f22b
 2008-11-21 08:50:50 +00:00
drh
c047b9f74d On a ROLLBACK, if there page cache entries which are dirty but not in the 
rollback journal, make sure they get reinitialized in the btree layer. (CVS 5936)

FossilOrigin-Name: faded96f36229ee85039276db693391d0f10648c
 2008-11-21 03:23:43 +00:00
aswift
aebf413d9a Added support for proxy file locking style 
Added pragma support for controlling proxy file locking
Added file control access to last errno and proxy locking
Added support for TMPDIR environment variable
Extended unit tests to cover new proxy locking pragmas and file control features (CVS 5934)

FossilOrigin-Name: b9bc36d3d5e35821ef69c0881a84c0afed253c9e
 2008-11-21 00:10:35 +00:00
drh
1e9db16c55 Force the corruptC.test script to use file format 1. (CVS 5930) 
FossilOrigin-Name: deadc2548d1e43cbbfe3af049cc5f59ee55bda46
 2008-11-19 18:43:07 +00:00
drh
1feb7dd391 Update the SECURE_DELETE code to track the latest changes in the pager. (CVS 5928) 
FossilOrigin-Name: e058f509374e98e48eafeba2f1dadff9633d1190
 2008-11-19 18:30:29 +00:00
drh
b232c23297 Add an alternative application-defined pcache implementation and add test 
cases to permutations.test to invoke it.  Added the SQLITE_CONFIG_GETPCACHE
method to sqlite3_config(). (CVS 5920)

FossilOrigin-Name: 16f1e6ec2ad92f68c0079a0c2b5ca08a3b4af816
 2008-11-19 01:20:26 +00:00
shane
dcc50b74e6 Fixed several more crashes due to corrupt db files. Added corruptC.test to soak.test. (CVS 5905) 
FossilOrigin-Name: 9b7a52e952c81e50611e04d2d79003b0ddc57ee5
 2008-11-13 18:29:50 +00:00
shane
ec21707dd7 Fixed typo in tkt3472.test that prevented the test from running. (CVS 5903) 
FossilOrigin-Name: 428a5479200dc24e2ee9b4a85ef6caadacbdbbd7
 2008-11-13 18:02:51 +00:00
danielk1977
ac8d7b35fa Minor changes to get memsys5 compiling and its tests passing. Ticket #3495. (CVS 5901) 
FossilOrigin-Name: 96453ca16e90bc0c0cbfb75b3e39899f56d6ea66
 2008-11-13 16:21:50 +00:00
danielk1977
0d0654119f Avoid some buffer overreads detected by valgrind while running corruptC.test. (CVS 5898) 
FossilOrigin-Name: faa6bd7b615837c920b5b3b027115caa2f56ec15
 2008-11-12 18:21:36 +00:00
danielk1977
ef988b47a4 In corruptC.test, explicitly set "PRAGMA auto_vacuum = 0". (CVS 5895) 
FossilOrigin-Name: b6563af8f9517760c2346a820e241b0517a10fe0
 2008-11-12 14:22:25 +00:00
drh
0d7f4fc4b0 Omit the threadOverrideEachOthersLocks tests for builds that non-unix 
or non-threadsafe. (CVS 5893)

FossilOrigin-Name: ab418656dbf3d2e055b2462a155d90863fef6582
 2008-11-12 14:07:51 +00:00
danielk1977
ab396298c4 Modify a failing test case in corruptC.test. The test case was failing only because the integrity_check was returning a slightly different error message than expected. (CVS 5891) 
FossilOrigin-Name: 0953f300f8e8b2bed79ef3189a1cb29f058f388b
 2008-11-12 11:57:41 +00:00
danielk1977
259a455f71 Make sure affinities and implicit collation sequences are correctly used by comparison expressions in the select-list or having clause of an aggregate query. Ticket #3493. (CVS 5889) 
FossilOrigin-Name: b8ceaa00500f29bbbd0cc5aec71a6ffa91ae6b43
 2008-11-12 08:07:12 +00:00
shane
0af3f8935f Fixed a few more crashes when dealing with corrupt db files. (CVS 5888) 
FossilOrigin-Name: f8bb34e40917e55696376d2def932a41ad43d0ae
 2008-11-12 04:55:34 +00:00
shane
34ac18daf5 Fixed crash during an UPDATE when free cell size is corrupt. (CVS 5887) 
FossilOrigin-Name: ec18667e2d2826a27f2c052ba3790ab5b8cf0bc4
 2008-11-11 22:18:20 +00:00
shane
826d5b7e1c Prevent a crash during an UPDATE when the cell offset is corrupt. (CVS 5886) 
FossilOrigin-Name: 99d4172ed6825c7efb6cbb28eb00d98323a13954
 2008-11-11 20:51:50 +00:00
danielk1977
41a6a61d94 Change the way threadsOverrideEachOthersLocks() works to avoid trying to write-lock a (potentially) read-only files. Also, assume that on non-linux systems threads do override each others locks. Ticket #3472. (CVS 5883) 
FossilOrigin-Name: 8ecae0943b06102fe22133db0dcaf58ecbd39545
 2008-11-11 18:34:35 +00:00
drh
a78c22c433 Cleanup in flattenSubquery. Add OOM tests for flattenSubquery. Fix issues 
with OOM errors causes problems for flattenSubquery.  Ticket #3485. (CVS 5882)

FossilOrigin-Name: ea5f4baa041aed934600f0f96b84afb92a14bc47
 2008-11-11 18:28:58 +00:00
shane
5780ebdf79 Fixed crash in integrity_check with corrupt content offset size in page header. (CVS 5881) 
FossilOrigin-Name: 0659a666ff0a9fc81ee4df3c35e535164c79e588
 2008-11-11 17:36:30 +00:00