1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-06-26 20:21:09 +03:00
Commit Graph

9709 Commits

Author SHA1 Message Date
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
fc8c9f84ab Fix some problems in the fts3 expression parser with mismatched parenthesis. (CVS 6095)
FossilOrigin-Name: ccfe4580ac7ba9add0e69c786a9a3a43d69b7753
2009-01-01 14:06:13 +00:00
drh
b39187ae89 Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094)
FossilOrigin-Name: afac4293000f81410d105a99956605bf7102fa62
2009-01-01 12:34:45 +00:00
758bc07c43 Add a couple of extra tests for the fts3 expression parser to improve mcdc coverage. (CVS 6093)
FossilOrigin-Name: 13146b34935d339d7b8379083e024647af07e2c1
2009-01-01 07:42:49 +00:00
5973e6a30b Add pseudo-random tests of the fts3 expression parser. Revise the fix in (6091). (CVS 6092)
FossilOrigin-Name: 11c2d4686197fb3f0d601651d5bbb3492af8f0dd
2009-01-01 07:08:54 +00:00
49b4b4d84a Fix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091)
FossilOrigin-Name: d1a6a2edd799d65ff88510df951e909919e35b6b
2009-01-01 04:19:51 +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
eb9441eb06 Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)
FossilOrigin-Name: 96f3b62914adde34079f08428b4e2fe81c193612
2008-12-30 16:35:53 +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
13da67e5aa Add further pseudo-randomly generated test cases to where8.test. (CVS 6083)
FossilOrigin-Name: e01f6ef9d981d50a70c05edc4ef8135dbc473ba1
2008-12-30 16:13:04 +00:00
c1071e53e7 Fix a bug in where8.test causing a tcl exception. (CVS 6082)
FossilOrigin-Name: 495b569a3921042c36667a415c1353201760fa17
2008-12-30 15:51:40 +00:00
9357416a25 Add a few more tests to where8.test. (CVS 6081)
FossilOrigin-Name: ac28aa8b618d59628c5b8fc6fe649ec14f554b11
2008-12-30 15:26:29 +00:00
drh
239080fbd5 Still more test cases in where7.test. (CVS 6080)
FossilOrigin-Name: eb9ba5fe70df56ee00828f7dbaf71ae6f825737d
2008-12-30 14:40:06 +00:00
drh
1cfdce1c45 Add many new test cases to where7.test. (CVS 6079)
FossilOrigin-Name: 174985831f9c8f5c393556d3248b01852573abc7
2008-12-30 14:14:03 +00:00
6e10b39078 Do not run savepoint4.test (crash simulation tests) in permutations.test. It slows things down too much. (CVS 6078)
FossilOrigin-Name: 2df02b543edd77282aabff08327c3ab102139a24
2008-12-30 13:21:50 +00:00
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
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
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
fdc4019b46 Add test file where8.test. (CVS 6072)
FossilOrigin-Name: bff460ec2c3e250de034a6b34312b897bb2f3749
2008-12-29 18:33:32 +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
3460d19c85 Fix a problem with savepoint and incremental-vacuum. (CVS 6066)
FossilOrigin-Name: 08352f9ea9d2a1759320efc46e418079000855cb
2008-12-27 15:23:13 +00:00
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
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
1f58153a9a Add a test to savepoint.test that tests that nothing goes wrong if an incremental vacuum occurs inside a savepoint. (CVS 6057)
FossilOrigin-Name: fc4f0621535e27eceb0b4b900a8c59dc06e84487
2008-12-23 11:46:28 +00:00
a4124bdfb7 Fix a couple of assert() failures that can occur in btree.c and pager.c. (CVS 6055)
FossilOrigin-Name: ae44e7482476478c8eeacfb80b282f17894530e5
2008-12-23 10:37:47 +00:00
8a7adb0dc0 Changes to test scripts so that veryquick.test runs with SQLITE_TEMP_STORE=3 defined. Also a fix to stop the same switch causing a crash in the savepoint code. (CVS 6053)
FossilOrigin-Name: ee0e6eae9f984472e44d7ee8f195c6e5d33f2efd
2008-12-22 11:43:35 +00:00
f3107512f7 Add a case to permutations.test to run tests with the test_journal.c backend installed. Also many fixes to test_journal.c and one quite obscure fix to pager.c. (CVS 6052)
FossilOrigin-Name: bb177e3072ab61d0af7af91660ebe4dafa487b42
2008-12-22 10:58:46 +00:00
a0fc72967e Add a vfs backend that detects problems like the one addressed by (6043) and (6047). (CVS 6049)
FossilOrigin-Name: 49172e487610268662c39fc4038032779a41c47f
2008-12-20 18:33:59 +00:00
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
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
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
34cf35dac4 Increase test coverage of new savepoint code. (CVS 6040)
FossilOrigin-Name: d915718d0b346982d686d131a159b67e28fc02a8
2008-12-18 18:31:38 +00:00
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
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
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
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