]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agoAdd test file savepoint6.test. Contains pseudo random tests of savepoint related...
danielk1977 [Sat, 3 Jan 2009 10:41:29 +0000 (10:41 +0000)] 
Add test file savepoint6.test. Contains pseudo random tests of savepoint related commands. (CVS 6105)

FossilOrigin-Name: 2946fbb7183d597b4db1db203eb5fd57c9762dc4

16 years agoMemory allocation failure in Bitvec are probably all benign. Still, add
drh [Fri, 2 Jan 2009 21:39:39 +0000 (21:39 +0000)] 
Memory allocation failure in Bitvec are probably all benign.  Still, add
code to check this, just to be sure. (CVS 6104)

FossilOrigin-Name: 4688e1c8b1203c3538aa862421ed344888059fe2

16 years agoReinitialize page 1 of the database file following a ROLLBACK TO of a
drh [Fri, 2 Jan 2009 21:08:09 +0000 (21:08 +0000)] 
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

16 years agoFix compiler warnings in pager.c (CVS 6102)
drh [Fri, 2 Jan 2009 18:10:42 +0000 (18:10 +0000)] 
Fix compiler warnings in pager.c (CVS 6102)

FossilOrigin-Name: 78dd7909da15a9b2cbcdb9cbe86798cfc24f3230

16 years agoModify the (transaction) method of the tcl interface to use savepoints. This makes...
danielk1977 [Fri, 2 Jan 2009 17:33:46 +0000 (17:33 +0000)] 
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

16 years agoAdd fts_expr.* files to Makefile.in. (CVS 6100)
shane [Fri, 2 Jan 2009 15:47:01 +0000 (15:47 +0000)] 
Add fts_expr.* files to Makefile.in. (CVS 6100)

FossilOrigin-Name: 524c8634dfa5926f38fac8bac1da6a14178c7764

16 years agoMany of the boundary tests depend on a working 64-bit implementation of TCL, so skip...
shane [Fri, 2 Jan 2009 15:45:47 +0000 (15:45 +0000)] 
Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

FossilOrigin-Name: b1a4a17f8752d27f3b360019490ab3f15a1f629f

16 years agoIncrement the version number to 3.6.8. (CVS 6098)
drh [Fri, 2 Jan 2009 12:35:03 +0000 (12:35 +0000)] 
Increment the version number to 3.6.8. (CVS 6098)

FossilOrigin-Name: 7509641a4c410b1eaaf1edba259fbe01cd60b108

16 years agoDo not display matches against
drh [Fri, 2 Jan 2009 01:10:42 +0000 (01:10 +0000)] 
Do not display matches against
the right-hand side of a NOT operator in the output
of the FTS snippet() or offsets() functions. (CVS 6097)

FossilOrigin-Name: d44c84c0f77bd0fc4a9942177b6cae6d109b89b7

16 years agoFix a (benign) valgrind error that can occur following malloc failure while executing...
danielk1977 [Thu, 1 Jan 2009 15:20:37 +0000 (15:20 +0000)] 
Fix a (benign) valgrind error that can occur following malloc failure while executing a 'ROLLBACK TO savepoint' command. (CVS 6096)

FossilOrigin-Name: 9ff8598f3be123a244f71b45e77af913b836504a

16 years agoFix some problems in the fts3 expression parser with mismatched parenthesis. (CVS...
danielk1977 [Thu, 1 Jan 2009 14:06:13 +0000 (14:06 +0000)] 
Fix some problems in the fts3 expression parser with mismatched parenthesis. (CVS 6095)

FossilOrigin-Name: ccfe4580ac7ba9add0e69c786a9a3a43d69b7753

16 years agoAdditional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094)
drh [Thu, 1 Jan 2009 12:34:45 +0000 (12:34 +0000)] 
Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094)

FossilOrigin-Name: afac4293000f81410d105a99956605bf7102fa62

16 years agoAdd a couple of extra tests for the fts3 expression parser to improve mcdc coverage...
danielk1977 [Thu, 1 Jan 2009 07:42:49 +0000 (07:42 +0000)] 
Add a couple of extra tests for the fts3 expression parser to improve mcdc coverage. (CVS 6093)

FossilOrigin-Name: 13146b34935d339d7b8379083e024647af07e2c1

16 years agoAdd pseudo-random tests of the fts3 expression parser. Revise the fix in (6091)....
danielk1977 [Thu, 1 Jan 2009 07:08:54 +0000 (07:08 +0000)] 
Add pseudo-random tests of the fts3 expression parser. Revise the fix in (6091). (CVS 6092)

FossilOrigin-Name: 11c2d4686197fb3f0d601651d5bbb3492af8f0dd

16 years agoFix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091)
danielk1977 [Thu, 1 Jan 2009 04:19:51 +0000 (04:19 +0000)] 
Fix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091)

FossilOrigin-Name: d1a6a2edd799d65ff88510df951e909919e35b6b

16 years agoAvoid surplus bytes at the end of the keyword string table.
drh [Wed, 31 Dec 2008 21:52:40 +0000 (21:52 +0000)] 
Avoid surplus bytes at the end of the keyword string table.
Add testcase() macros to make sure all keywords are used during
testing. (CVS 6090)

FossilOrigin-Name: 73958060aaf641d93bede3a42851e5b3451f5432

16 years agoFix the name in the documentation of the compile-time macro for
drh [Wed, 31 Dec 2008 19:27:53 +0000 (19:27 +0000)] 
Fix the name in the documentation of the compile-time macro for
enabling FTS3 parenthesis processing. (CVS 6089)

FossilOrigin-Name: ac8258da6ecd3ea37f394dc3b48834eb57832cf4

16 years agoFix the FTS3 expression parser so that it works in the amalgamation when
drh [Wed, 31 Dec 2008 16:27:58 +0000 (16:27 +0000)] 
Fix the FTS3 expression parser so that it works in the amalgamation when
FTS3 is disabled. (CVS 6088)

FossilOrigin-Name: 7e238e8604b9a9f786d84a47d21c6b42f1585755

16 years agoFix the FTS3 module with parenthesis syntax so that it will work in
drh [Wed, 31 Dec 2008 16:01:04 +0000 (16:01 +0000)] 
Fix the FTS3 module with parenthesis syntax so that it will work in
the amalgamation. (CVS 6087)

FossilOrigin-Name: c2b9891fc05ec05b270f108f61ab81b2df874e01

16 years agoFix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint"
drh [Tue, 30 Dec 2008 17:55:00 +0000 (17:55 +0000)] 
Fix a bug in the multi-index OR cost estimator.  Remove leftover "breakpoint"
commands from test scripts. (CVS 6086)

FossilOrigin-Name: b090d5736d7eaec17a39d3133e1587b1d2a42acb

16 years agoAdd LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)
drh [Tue, 30 Dec 2008 16:35:53 +0000 (16:35 +0000)] 
Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)

FossilOrigin-Name: 96f3b62914adde34079f08428b4e2fe81c193612

16 years agoGet EXPLAIN QUERY PLAN working with the multi-index OR optimization.
drh [Tue, 30 Dec 2008 16:18:47 +0000 (16:18 +0000)] 
Get EXPLAIN QUERY PLAN working with the multi-index OR optimization.
Added new test script "where9.test". (CVS 6084)

FossilOrigin-Name: 4b6460221011e02bedb724169e8e4793e539e65a

16 years agoAdd further pseudo-randomly generated test cases to where8.test. (CVS 6083)
danielk1977 [Tue, 30 Dec 2008 16:13:04 +0000 (16:13 +0000)] 
Add further pseudo-randomly generated test cases to where8.test. (CVS 6083)

FossilOrigin-Name: e01f6ef9d981d50a70c05edc4ef8135dbc473ba1

16 years agoFix a bug in where8.test causing a tcl exception. (CVS 6082)
danielk1977 [Tue, 30 Dec 2008 15:51:40 +0000 (15:51 +0000)] 
Fix a bug in where8.test causing a tcl exception. (CVS 6082)

FossilOrigin-Name: 495b569a3921042c36667a415c1353201760fa17

16 years agoAdd a few more tests to where8.test. (CVS 6081)
danielk1977 [Tue, 30 Dec 2008 15:26:29 +0000 (15:26 +0000)] 
Add a few more tests to where8.test. (CVS 6081)

FossilOrigin-Name: ac28aa8b618d59628c5b8fc6fe649ec14f554b11

16 years agoStill more test cases in where7.test. (CVS 6080)
drh [Tue, 30 Dec 2008 14:40:06 +0000 (14:40 +0000)] 
Still more test cases in where7.test. (CVS 6080)

FossilOrigin-Name: eb9ba5fe70df56ee00828f7dbaf71ae6f825737d

16 years agoAdd many new test cases to where7.test. (CVS 6079)
drh [Tue, 30 Dec 2008 14:14:03 +0000 (14:14 +0000)] 
Add many new test cases to where7.test. (CVS 6079)

FossilOrigin-Name: 174985831f9c8f5c393556d3248b01852573abc7

16 years agoDo not run savepoint4.test (crash simulation tests) in permutations.test. It slows...
danielk1977 [Tue, 30 Dec 2008 13:21:50 +0000 (13:21 +0000)] 
Do not run savepoint4.test (crash simulation tests) in permutations.test. It slows things down too much. (CVS 6078)

FossilOrigin-Name: 2df02b543edd77282aabff08327c3ab102139a24

16 years agoAdd a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077)
danielk1977 [Tue, 30 Dec 2008 12:00:12 +0000 (12:00 +0000)] 
Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077)

FossilOrigin-Name: 35c87585b81866e73a58adffe6af79ddcac57cf6

16 years agoFix a bug in where.c causing a malfunction when an INDEXED BY clause specified an...
danielk1977 [Tue, 30 Dec 2008 09:45:45 +0000 (09:45 +0000)] 
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

16 years agoFix a bug in README.tokenizers. Ticket #3559. (CVS 6075)
danielk1977 [Tue, 30 Dec 2008 06:36:50 +0000 (06:36 +0000)] 
Fix a bug in README.tokenizers. Ticket #3559. (CVS 6075)

FossilOrigin-Name: b8898d132e84888dc7c51b2f1ab67f78cc21f31b

16 years agoInvoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE...
danielk1977 [Tue, 30 Dec 2008 06:24:58 +0000 (06:24 +0000)] 
Invoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE commands. (CVS 6074)

FossilOrigin-Name: e49807b16f7f86d3f2290d6c1f7562f3db6330f9

16 years agoAlways make sure WhereClause objects are initialized to zero when they
drh [Mon, 29 Dec 2008 23:45:07 +0000 (23:45 +0000)] 
Always make sure WhereClause objects are initialized to zero when they
are first allocated. (CVS 6073)

FossilOrigin-Name: 7d0ae55d6b2d263382f034eb89bbc368fab6a9bc

16 years agoAdd test file where8.test. (CVS 6072)
danielk1977 [Mon, 29 Dec 2008 18:33:32 +0000 (18:33 +0000)] 
Add test file where8.test. (CVS 6072)

FossilOrigin-Name: bff460ec2c3e250de034a6b34312b897bb2f3749

16 years agoRemove an old variable declaration that was commented out using a C++ comment. (CVS...
danielk1977 [Mon, 29 Dec 2008 14:51:05 +0000 (14:51 +0000)] 
Remove an old variable declaration that was commented out using a C++ comment. (CVS 6071)

FossilOrigin-Name: 0b972f14f00340cbd4e310dea6d1a4f1c05f5628

16 years agoSet the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070)
danielk1977 [Mon, 29 Dec 2008 10:39:53 +0000 (10:39 +0000)] 
Set the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070)

FossilOrigin-Name: 03d0350441ef5fa5a9f22fcb0b760200614cf9f9

16 years agoMulti-index OR optimizer response to ORDER BY rowid.
drh [Sun, 28 Dec 2008 20:47:02 +0000 (20:47 +0000)] 
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

16 years agoOptimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands
drh [Sun, 28 Dec 2008 18:35:08 +0000 (18:35 +0000)] 
Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands
of an OR. (CVS 6068)

FossilOrigin-Name: 67cf24b30e087796cfb0fccf47328e72ade5ecdc

16 years agoSimplify the VM code that implements WHERE claues. (CVS 6067)
drh [Sun, 28 Dec 2008 16:55:25 +0000 (16:55 +0000)] 
Simplify the VM code that implements WHERE claues. (CVS 6067)

FossilOrigin-Name: fa95f843e179a38f663978d675607c4c3037928d

16 years agoFix a problem with savepoint and incremental-vacuum. (CVS 6066)
danielk1977 [Sat, 27 Dec 2008 15:23:13 +0000 (15:23 +0000)] 
Fix a problem with savepoint and incremental-vacuum. (CVS 6066)

FossilOrigin-Name: 08352f9ea9d2a1759320efc46e418079000855cb

16 years agoReset the column cache before coding each step of a trigger program. Candidate fix...
danielk1977 [Fri, 26 Dec 2008 07:56:39 +0000 (07:56 +0000)] 
Reset the column cache before coding each step of a trigger program. Candidate fix for #3554. (CVS 6065)

FossilOrigin-Name: a1b1f6cd7d2c060bd75ce39347e1220b872806ed

16 years agoFix a virtual table related assert() that can fail following a malloc failure. (CVS...
danielk1977 [Wed, 24 Dec 2008 11:25:39 +0000 (11:25 +0000)] 
Fix a virtual table related assert() that can fail following a malloc failure. (CVS 6064)

FossilOrigin-Name: c6fd3b8f29927c0fc634f82885f144c78f0105d9

16 years agoFix a couple of problems in test file test_journal.c that were causing segfaults...
danielk1977 [Wed, 24 Dec 2008 09:30:22 +0000 (09:30 +0000)] 
Fix a couple of problems in test file test_journal.c that were causing segfaults when running all.test. (CVS 6063)

FossilOrigin-Name: 416c9efb49ba207a9a79d06d0b13854695a8876c

16 years agoContinuing improvements to the multi-index OR-clause optimizer. Added a
drh [Tue, 23 Dec 2008 23:56:22 +0000 (23:56 +0000)] 
Continuing improvements to the multi-index OR-clause optimizer.  Added a
few simple test cases. (CVS 6062)

FossilOrigin-Name: 55d4f493e7df8515574a75caec9967d6c71b6012

16 years agoFix a problem with the savepoint code and in-memory journals. (CVS 6061)
danielk1977 [Tue, 23 Dec 2008 19:15:56 +0000 (19:15 +0000)] 
Fix a problem with the savepoint code and in-memory journals. (CVS 6061)

FossilOrigin-Name: 26ceebf38e7ae7bbda3284995b03f829a2d2493f

16 years agoFix an OOM problem in where.c. (CVS 6060)
drh [Tue, 23 Dec 2008 16:23:04 +0000 (16:23 +0000)] 
Fix an OOM problem in where.c. (CVS 6060)

FossilOrigin-Name: d2105f617eeb04c8177546c45bf6c63e72757f91

16 years agoMake sure nOverflow is always cleared when a page is released. (CVS 6059)
drh [Tue, 23 Dec 2008 15:58:06 +0000 (15:58 +0000)] 
Make sure nOverflow is always cleared when a page is released. (CVS 6059)

FossilOrigin-Name: 8d0f724477422db05ed46e58ce40a720107384f0

16 years agoMulti-index OR-clause optimization now works for simple tests. There are
drh [Tue, 23 Dec 2008 13:35:23 +0000 (13:35 +0000)] 
Multi-index OR-clause optimization now works for simple tests.  There are
no test scripts for it yet, though.  And it is disabled by default, pending
further testing and optimization.  We need a lot of both. (CVS 6058)

FossilOrigin-Name: d77a702358deddfa9987147999d06a235e730fa9

16 years agoAdd a test to savepoint.test that tests that nothing goes wrong if an incremental...
danielk1977 [Tue, 23 Dec 2008 11:46:28 +0000 (11:46 +0000)] 
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

16 years agoIn sqlite3AddColumn(), use local variable 'db' instead of 'pParse->db'. (CVS 6056)
danielk1977 [Tue, 23 Dec 2008 11:11:51 +0000 (11:11 +0000)] 
In sqlite3AddColumn(), use local variable 'db' instead of 'pParse->db'. (CVS 6056)

FossilOrigin-Name: 0c53a4c2da31f91947f1347f1d33d0c83b843d26

16 years agoFix a couple of assert() failures that can occur in btree.c and pager.c. (CVS 6055)
danielk1977 [Tue, 23 Dec 2008 10:37:47 +0000 (10:37 +0000)] 
Fix a couple of assert() failures that can occur in btree.c and pager.c. (CVS 6055)

FossilOrigin-Name: ae44e7482476478c8eeacfb80b282f17894530e5

16 years agoFix a reference counting bug in rtree. Ticket #3549. (CVS 6054)
danielk1977 [Mon, 22 Dec 2008 15:04:32 +0000 (15:04 +0000)] 
Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054)

FossilOrigin-Name: bbdc0e9f2481f8d59e05ea282b615f97e09fb471

16 years agoChanges to test scripts so that veryquick.test runs with SQLITE_TEMP_STORE=3 defined...
danielk1977 [Mon, 22 Dec 2008 11:43:35 +0000 (11:43 +0000)] 
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

16 years agoAdd a case to permutations.test to run tests with the test_journal.c backend installe...
danielk1977 [Mon, 22 Dec 2008 10:58:46 +0000 (10:58 +0000)] 
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

16 years agoFix a variable type to prevent a warning in the proxy-locking code. (CVS 6051)
danielk1977 [Mon, 22 Dec 2008 03:36:59 +0000 (03:36 +0000)] 
Fix a variable type to prevent a warning in the proxy-locking code. (CVS 6051)

FossilOrigin-Name: d9595b961800a13c141bebdb8c0a67377f30efad

16 years agoContinue refactoring where.c in preparation for installing OR-clause
drh [Sun, 21 Dec 2008 03:51:16 +0000 (03:51 +0000)] 
Continue refactoring where.c in preparation for installing OR-clause
optimizations. (CVS 6050)

FossilOrigin-Name: 778e91ddb834f6084ecdf3909692b54bb7da8f6d

16 years agoAdd a vfs backend that detects problems like the one addressed by (6043) and (6047...
danielk1977 [Sat, 20 Dec 2008 18:33:59 +0000 (18:33 +0000)] 
Add a vfs backend that detects problems like the one addressed by (6043) and (6047). (CVS 6049)

FossilOrigin-Name: 49172e487610268662c39fc4038032779a41c47f

16 years agoDo not use long long constants in code. Ticket #3547. (CVS 6048)
drh [Sat, 20 Dec 2008 13:18:50 +0000 (13:18 +0000)] 
Do not use long long constants in code.  Ticket #3547. (CVS 6048)

FossilOrigin-Name: 51b3bfc3b9628ca4ec754fa7f23aef7302f890ff

16 years agoFix the crash-followed-by-corruption bug revealed by savepoint4.test. This is actuall...
danielk1977 [Sat, 20 Dec 2008 08:39:57 +0000 (08:39 +0000)] 
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

16 years agoSpecify type "void" in the parameter list of functions that take no parameters.
drh [Sat, 20 Dec 2008 02:14:39 +0000 (02:14 +0000)] 
Specify type "void" in the parameter list of functions that take no parameters.
Tickets #3545 and #3546. (CVS 6046)

FossilOrigin-Name: c2228bd14ae54b17450f64357bf835d08c447250

16 years agoEnhanced analysis of OR terms in a WHERE clause. Another step toward being
drh [Sat, 20 Dec 2008 02:06:13 +0000 (02:06 +0000)] 
Enhanced analysis of OR terms in a WHERE clause.  Another step toward being
able to use indices with OR-connected WHERE clause terms. (CVS 6045)

FossilOrigin-Name: c3f7aa019c613e18457f090685725dd8a6a336b9

16 years agoAdd extra crash test cases that stress the savepoint mechanism to savepoint4.test...
danielk1977 [Fri, 19 Dec 2008 18:45:52 +0000 (18:45 +0000)] 
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

16 years agoAdd some crash-tests for savepoint. Fix a bug revealed by these tests. (CVS 6043)
danielk1977 [Fri, 19 Dec 2008 16:31:11 +0000 (16:31 +0000)] 
Add some crash-tests for savepoint. Fix a bug revealed by these tests. (CVS 6043)

FossilOrigin-Name: 6f36c16678b6e3baa5a9d9ceba1a756a8034f3e1

16 years agoAdd the file ext/fts3/README.syntax, containing documentation describing the two...
danielk1977 [Fri, 19 Dec 2008 11:37:38 +0000 (11:37 +0000)] 
Add the file ext/fts3/README.syntax, containing documentation describing the two query syntaxes now supported by fts3. (CVS 6042)

FossilOrigin-Name: ed81ad5a5d22304a4d96e778e8e9094f74c461c0

16 years agoFix the Oracle and MS-Sql command-line terminator logic in the CLI.
drh [Thu, 18 Dec 2008 22:25:13 +0000 (22:25 +0000)] 
Fix the Oracle and MS-Sql command-line terminator logic in the CLI.
Ticket #3544. (CVS 6041)

FossilOrigin-Name: dcc8935fa0ccf86648c22818823bf1daef8f3939

16 years agoIncrease test coverage of new savepoint code. (CVS 6040)
danielk1977 [Thu, 18 Dec 2008 18:31:38 +0000 (18:31 +0000)] 
Increase test coverage of new savepoint code. (CVS 6040)

FossilOrigin-Name: d915718d0b346982d686d131a159b67e28fc02a8

16 years agoAdd savepoint2.test, a file containing savepoint tests similar to tests in trans...
danielk1977 [Thu, 18 Dec 2008 15:45:07 +0000 (15:45 +0000)] 
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

16 years agoFix a bug in icuOpen() in fts2. (CVS 6038)
danielk1977 [Thu, 18 Dec 2008 05:30:26 +0000 (05:30 +0000)] 
Fix a bug in icuOpen() in fts2. (CVS 6038)

FossilOrigin-Name: b9c722bd96b44e0fabd1564ddd982d2aabb7047c

16 years agoUpdate the WHERE clause processing infrastructure in preparation for adding
drh [Wed, 17 Dec 2008 19:22:15 +0000 (19:22 +0000)] 
Update the WHERE clause processing infrastructure in preparation for adding
multi-index OR evaluation. (CVS 6037)

FossilOrigin-Name: 78401b33febf678cfeec2a35514eb4172de420ab

16 years agoAdd the savepoint feature. This feature is largely untested at this point. (CVS 6036)
danielk1977 [Wed, 17 Dec 2008 17:30:26 +0000 (17:30 +0000)] 
Add the savepoint feature. This feature is largely untested at this point. (CVS 6036)

FossilOrigin-Name: 34b56600ec0c5cd7b5faab265750252bc9850e3e

16 years agoFix some strict-aliasing problems in fts3_expr.c. (CVS 6035)
danielk1977 [Wed, 17 Dec 2008 15:49:51 +0000 (15:49 +0000)] 
Fix some strict-aliasing problems in fts3_expr.c. (CVS 6035)

FossilOrigin-Name: 20a4ca5d361ecbb982129171f10cccac4f5ad093

16 years agoModify fts3 to support a more complex expression syntax that allows parenthesis....
danielk1977 [Wed, 17 Dec 2008 15:18:17 +0000 (15:18 +0000)] 
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

16 years agoVersion 3.6.7 (CVS 6033)
drh [Tue, 16 Dec 2008 18:15:58 +0000 (18:15 +0000)] 
Version 3.6.7 (CVS 6033)

FossilOrigin-Name: f4f40370fb83d677df3fbf2c51c4bb4a3e5ccc7a

16 years agoFix a compile error in an assert() and a warning with MSVC builds. (CVS 6032)
shane [Tue, 16 Dec 2008 17:20:38 +0000 (17:20 +0000)] 
Fix a compile error in an assert() and a warning with MSVC builds. (CVS 6032)

FossilOrigin-Name: 8b8f6a6ab597e06e60557ab56c6ee7f8522ed570

16 years agoMake sure the memory returned from sqlite3ScratchMalloc() is 8-byte aligned.
drh [Tue, 16 Dec 2008 13:46:29 +0000 (13:46 +0000)] 
Make sure the memory returned from sqlite3ScratchMalloc() is 8-byte aligned.
Ticket #3542. (CVS 6031)

FossilOrigin-Name: 13b56b7ff97c3abc116dae934f6d1330bbb7762d

16 years agoNew hyperlinks added to C interface documentation. No changes to working code. ...
drh [Mon, 15 Dec 2008 22:51:38 +0000 (22:51 +0000)] 
New hyperlinks added to C interface documentation.  No changes to working code. (CVS 6030)

FossilOrigin-Name: 230cb68e07ec791fa4a46dee8506716d52a99426

16 years agoAdd test cases that verify evaluation of randomly generated SQL expressions. (CVS...
drh [Mon, 15 Dec 2008 16:33:29 +0000 (16:33 +0000)] 
Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029)

FossilOrigin-Name: 4685ffccd37456fc527a7f7178885a060b474ad8

16 years agoConvert the "~" and "NOT" operators to be two-address instructions.
drh [Mon, 15 Dec 2008 15:27:51 +0000 (15:27 +0000)] 
Convert the "~" and "NOT" operators to be two-address instructions.
Ticket #3541. (CVS 6028)

FossilOrigin-Name: ea9b747efb22fd3f679c3ef86ed51986c5ad9436

16 years agoAdd the example from #3359 to the test suite. (CVS 6027)
danielk1977 [Sun, 14 Dec 2008 14:45:20 +0000 (14:45 +0000)] 
Add the example from #3359 to the test suite. (CVS 6027)

FossilOrigin-Name: 84f8417c0794d3e5cec88f59ea71a7d557044409

16 years agoFix the name of the source algorithm in the comments of the script generators
drh [Sun, 14 Dec 2008 02:55:16 +0000 (02:55 +0000)] 
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

16 years agoAdd many new integer boundary value tests. Ticket #3536. (CVS 6025)
drh [Fri, 12 Dec 2008 19:19:22 +0000 (19:19 +0000)] 
Add many new integer boundary value tests.  Ticket #3536. (CVS 6025)

FossilOrigin-Name: 45277238d355caa1fbeea67c6c6d1a8f231eabda

16 years agoRework the rowid lookup logic in the query optimizer to fix various
drh [Fri, 12 Dec 2008 17:56:16 +0000 (17:56 +0000)] 
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

16 years agoPrevious change to the OP_ForceInt opcode did not work correctly when the
drh [Thu, 11 Dec 2008 20:03:22 +0000 (20:03 +0000)] 
Previous change to the OP_ForceInt opcode did not work correctly when the
input is a negative floating point value.  This change is the fix.
Ticket #3536. (CVS 6023)

FossilOrigin-Name: f6c50f357c302907a5398c551a5c596f7d305031

16 years agoMake sure the OP_ForceInt vdbe opcode does not cause a rowid overflow.
drh [Thu, 11 Dec 2008 19:50:18 +0000 (19:50 +0000)] 
Make sure the OP_ForceInt vdbe opcode does not cause a rowid overflow.
Ticket #3536.  Tests to verify this change will be checked in separately. (CVS 6022)

FossilOrigin-Name: 6a049c6595550c123e77199cf7f3898bfcf40c86

16 years agoGuard against attacks from deliberately corrupted database files. (CVS 6021)
drh [Thu, 11 Dec 2008 16:17:03 +0000 (16:17 +0000)] 
Guard against attacks from deliberately corrupted database files. (CVS 6021)

FossilOrigin-Name: da2ec96422b1f9de2e47d3b8c19ed20579742a9b

16 years agoIncrease the version number to 3.6.7. (CVS 6020)
drh [Thu, 11 Dec 2008 13:08:15 +0000 (13:08 +0000)] 
Increase the version number to 3.6.7. (CVS 6020)

FossilOrigin-Name: 7c367515f86c36b7ec8603754b20f1c7c4a0690a

16 years agoInitialize a local variable so as to avoid a valgrind warning. (CVS 6019)
drh [Thu, 11 Dec 2008 13:05:00 +0000 (13:05 +0000)] 
Initialize a local variable so as to avoid a valgrind warning. (CVS 6019)

FossilOrigin-Name: 0d316160fc9e24262457d330abee40f447ff909e

16 years agoRemoved a few more harmless warnings from MSVC. (CVS 6018)
shane [Thu, 11 Dec 2008 02:58:26 +0000 (02:58 +0000)] 
Removed a few more harmless warnings from MSVC. (CVS 6018)

FossilOrigin-Name: 72fd92bd67ed2b8e193cf3119e60d0a8f1e819c9

16 years agoFix the TCL test harness so that it compiles and runs on OSX with
drh [Thu, 11 Dec 2008 02:56:07 +0000 (02:56 +0000)] 
Fix the TCL test harness so that it compiles and runs on OSX with
SQLITE_ENABLE_LOCKING_STYLE. (CVS 6017)

FossilOrigin-Name: 561d5de16ec07546a3bb691f308fb2495a0d0a43

16 years agoInitialize the yyzerominor constant generated by lemon. (CVS 6016)
drh [Thu, 11 Dec 2008 02:20:43 +0000 (02:20 +0000)] 
Initialize the yyzerominor constant generated by lemon. (CVS 6016)

FossilOrigin-Name: 76c8f6ba87f333f15444ba5444bc675ec4cfd89e

16 years agoMore code obfuscation designed to thwart compiler warning messages. (CVS 6015)
drh [Wed, 10 Dec 2008 23:04:13 +0000 (23:04 +0000)] 
More code obfuscation designed to thwart compiler warning messages. (CVS 6015)

FossilOrigin-Name: 0a1888a7e6fb56e56d8078e7792379d908ba7a70

16 years agoTry to remove compiler warnings from vdbe.c. (CVS 6014)
drh [Wed, 10 Dec 2008 22:32:56 +0000 (22:32 +0000)] 
Try to remove compiler warnings from vdbe.c. (CVS 6014)

FossilOrigin-Name: 50352950df5d5a8b7da8c18b6667b8242a359f7d

16 years agoWork to remove harmless MSVC compiler warnings. (CVS 6013)
shane [Wed, 10 Dec 2008 22:30:24 +0000 (22:30 +0000)] 
Work to remove harmless MSVC compiler warnings. (CVS 6013)

FossilOrigin-Name: 715dcd52c1372c62873cff5db97fdbdfce617808

16 years agoThe strlen30 function in tclsqlite.c should be defined regardless of whether
drh [Wed, 10 Dec 2008 22:18:39 +0000 (22:18 +0000)] 
The strlen30 function in tclsqlite.c should be defined regardless of whether
or not the amalgamation is used. (CVS 6012)

FossilOrigin-Name: d8e8c7e51c09dc4e4d7e45ba1866c78713d6f5aa

16 years agoFix an issue with the new sqlite3Strlen30() introduced by
drh [Wed, 10 Dec 2008 22:15:00 +0000 (22:15 +0000)] 
Fix an issue with the new sqlite3Strlen30() introduced by
check-in (6007).  Additional casts for compiler warnings. (CVS 6011)

FossilOrigin-Name: 258722b6178f60eaccef1675aab3edc456d413a5

16 years agoAdditional work at eliminating silly compiler warnings. (CVS 6010)
drh [Wed, 10 Dec 2008 21:19:56 +0000 (21:19 +0000)] 
Additional work at eliminating silly compiler warnings. (CVS 6010)

FossilOrigin-Name: ea01d43788a75e39c7f03c22681d1a338d52cf0e

16 years agoFixed typo in comment in mkkeywordhash.c. (CVS 6009)
shane [Wed, 10 Dec 2008 20:11:01 +0000 (20:11 +0000)] 
Fixed typo in comment in mkkeywordhash.c. (CVS 6009)

FossilOrigin-Name: b7dd05b403e69caca814ccd8824130f176160cd5

16 years agoAdded option (-l) to lemon parser to have it skip printing line numbers (#line ....
shane [Wed, 10 Dec 2008 20:10:04 +0000 (20:10 +0000)] 
Added option (-l) to lemon parser to have it skip printing line numbers (#line ... ). (CVS 6008)

FossilOrigin-Name: ccb9393a7a10f0970419b860af293b0bdad7f894

16 years agoNever use strlen(). Use our own internal sqlite3Strlen30() which is
drh [Wed, 10 Dec 2008 19:26:22 +0000 (19:26 +0000)] 
Never use strlen().  Use our own internal sqlite3Strlen30() which is
guaranteed to never overflow an integer.  Additional explicit casts to
avoid nuisance warning messages. (CVS 6007)

FossilOrigin-Name: c872d554930ecf221ac2be5f886d5d67bb35288c

16 years agoMore explicit type casting to silence VC++. (CVS 6006)
drh [Wed, 10 Dec 2008 18:03:45 +0000 (18:03 +0000)] 
More explicit type casting to silence VC++. (CVS 6006)

FossilOrigin-Name: 14e6d19c3157ccdce170e769d678c7f472dd3db2