/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around bff460ec2c3e250d.

2009-01-06
15:58
Cleanup of the PAGERTRACE macro. Other comment changes in pager.c. (CVS 6122) check-in: ee7b4b60 user: drh tags: trunk
15:28
The fix in (6120) wasn't quite right. This fixes it. (CVS 6121) check-in: ddc2ebfa user: danielk1977 tags: trunk
15:20
Fix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120) check-in: 2cdbb468 user: danielk1977 tags: trunk
14:50
Update permutations.test so that it does not show an error when running the singlethread and multithread test cases on THREADSAFE=0 builds. (CVS 6119) check-in: 301b57b7 user: drh tags: trunk
14:34
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) check-in: a64f3db0 user: danielk1977 tags: trunk
14:19
Fix compiler warnings. (CVS 6117) check-in: da770a8d user: drh tags: trunk
13:40
Add some savepoint related test cases and fix a few problems. (CVS 6116) check-in: 8c62ea4f user: danielk1977 tags: trunk
00:11
Remove leftover "breakpoint" from the fuzz.test script. (CVS 6115) check-in: c2482d88 user: drh tags: trunk
00:08
Fix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114) check-in: a7015625 user: drh tags: trunk
2009-01-05
22:30
The fix in (6111) was not quite right. This version works better. (CVS 6113) check-in: 5f80140a user: drh tags: trunk
19:36
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) check-in: e02323b3 user: drh tags: trunk
18:02
Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111) check-in: b2131e86 user: drh tags: trunk
17:19
Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110) check-in: 77dc19cf user: drh tags: trunk
17:15
Fix some test code problems in "permutations.test journaltest pager.test". (CVS 6109) check-in: cf627752 user: danielk1977 tags: trunk
2009-01-03
15:06
Add some tests with attached databases to savepoint.test. Also tests of creating and dropping tables in auto-vacuum mode inside of a savepoint. (CVS 6108) check-in: ca7f11d5 user: danielk1977 tags: trunk
14:04
When the commit_hook calls a query recursively, make sure the commit_hook is not invoked recursively. Ticket #3564. (CVS 6107) check-in: 27ae4065 user: drh tags: trunk
12:55
Fix a typo in a comment. (CVS 6106) check-in: 50f57cd1 user: drh tags: trunk
10:41
Add test file savepoint6.test. Contains pseudo random tests of savepoint related commands. (CVS 6105) check-in: 2946fbb7 user: danielk1977 tags: trunk
2009-01-02
21:39
Memory allocation failure in Bitvec are probably all benign. Still, add code to check this, just to be sure. (CVS 6104) check-in: 4688e1c8 user: drh tags: trunk
21:08
Reinitialize page 1 of the database file following a ROLLBACK TO of a transactional SAVEPOINT on an initially empty database. (CVS 6103) check-in: 3e9efb76 user: drh tags: trunk
18:10
Fix compiler warnings in pager.c (CVS 6102) check-in: 78dd7909 user: drh tags: trunk
17:33
Modify the (transaction) method of the tcl interface to use savepoints. This makes nested calls to (transaction) work more intuitively. (CVS 6101) check-in: f047758d user: danielk1977 tags: trunk
15:47
Add fts_expr.* files to Makefile.in. (CVS 6100) check-in: 524c8634 user: shane tags: trunk
15:45
Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099) check-in: b1a4a17f user: shane tags: trunk
12:35
Increment the version number to 3.6.8. (CVS 6098) check-in: 7509641a user: drh tags: trunk
01:10
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) check-in: d44c84c0 user: drh tags: trunk
2009-01-01
15:20
Fix a (benign) valgrind error that can occur following malloc failure while executing a 'ROLLBACK TO savepoint' command. (CVS 6096) check-in: 9ff8598f user: danielk1977 tags: trunk
14:06
Fix some problems in the fts3 expression parser with mismatched parenthesis. (CVS 6095) check-in: ccfe4580 user: danielk1977 tags: trunk
12:34
Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094) check-in: afac4293 user: drh tags: trunk
07:42
Add a couple of extra tests for the fts3 expression parser to improve mcdc coverage. (CVS 6093) check-in: 13146b34 user: danielk1977 tags: trunk
07:08
Add pseudo-random tests of the fts3 expression parser. Revise the fix in (6091). (CVS 6092) check-in: 11c2d468 user: danielk1977 tags: trunk
04:19
Fix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091) check-in: d1a6a2ed user: danielk1977 tags: trunk
2008-12-31
21:52
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) check-in: 73958060 user: drh tags: trunk
19:27
Fix the name in the documentation of the compile-time macro for enabling FTS3 parenthesis processing. (CVS 6089) check-in: ac8258da user: drh tags: trunk
16:27
Fix the FTS3 expression parser so that it works in the amalgamation when FTS3 is disabled. (CVS 6088) check-in: 7e238e86 user: drh tags: trunk
16:01
Fix the FTS3 module with parenthesis syntax so that it will work in the amalgamation. (CVS 6087) check-in: c2b9891f user: drh tags: trunk
2008-12-30
17:55
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) check-in: b090d573 user: drh tags: trunk
16:35
Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085) check-in: 96f3b629 user: drh tags: trunk
16:18
Get EXPLAIN QUERY PLAN working with the multi-index OR optimization. Added new test script "where9.test". (CVS 6084) check-in: 4b646022 user: drh tags: trunk
16:13
Add further pseudo-randomly generated test cases to where8.test. (CVS 6083) check-in: e01f6ef9 user: danielk1977 tags: trunk
15:51
Fix a bug in where8.test causing a tcl exception. (CVS 6082) check-in: 495b569a user: danielk1977 tags: trunk
15:26
Add a few more tests to where8.test. (CVS 6081) check-in: ac28aa8b user: danielk1977 tags: trunk
14:40
Still more test cases in where7.test. (CVS 6080) check-in: eb9ba5fe user: drh tags: trunk
14:14
Add many new test cases to where7.test. (CVS 6079) check-in: 17498583 user: drh tags: trunk
13:21
Do not run savepoint4.test (crash simulation tests) in permutations.test. It slows things down too much. (CVS 6078) check-in: 2df02b54 user: danielk1977 tags: trunk
12:00
Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077) check-in: 35c87585 user: danielk1977 tags: trunk
09:45
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) check-in: f8ff0212 user: danielk1977 tags: trunk
06:36
Fix a bug in README.tokenizers. Ticket #3559. (CVS 6075) check-in: b8898d13 user: danielk1977 tags: trunk
06:24
Invoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE commands. (CVS 6074) check-in: e49807b1 user: danielk1977 tags: trunk
2008-12-29
23:45
Always make sure WhereClause objects are initialized to zero when they are first allocated. (CVS 6073) check-in: 7d0ae55d user: drh tags: trunk
18:33
Add test file where8.test. (CVS 6072) check-in: bff460ec user: danielk1977 tags: trunk
14:51
Remove an old variable declaration that was commented out using a C++ comment. (CVS 6071) check-in: 0b972f14 user: danielk1977 tags: trunk
10:39
Set the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070) check-in: 03d03504 user: danielk1977 tags: trunk
2008-12-28
20:47
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) check-in: 3464d369 user: drh tags: trunk
18:35
Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands of an OR. (CVS 6068) check-in: 67cf24b3 user: drh tags: trunk
16:55
Simplify the VM code that implements WHERE claues. (CVS 6067) check-in: fa95f843 user: drh tags: trunk
2008-12-27
15:23
Fix a problem with savepoint and incremental-vacuum. (CVS 6066) check-in: 08352f9e user: danielk1977 tags: trunk
2008-12-26
07:56
Reset the column cache before coding each step of a trigger program. Candidate fix for #3554. (CVS 6065) check-in: a1b1f6cd user: danielk1977 tags: trunk
2008-12-24
11:25
Fix a virtual table related assert() that can fail following a malloc failure. (CVS 6064) check-in: c6fd3b8f user: danielk1977 tags: trunk
09:30
Fix a couple of problems in test file test_journal.c that were causing segfaults when running all.test. (CVS 6063) check-in: 416c9efb user: danielk1977 tags: trunk
2008-12-23
23:56
Continuing improvements to the multi-index OR-clause optimizer. Added a few simple test cases. (CVS 6062) check-in: 55d4f493 user: drh tags: trunk
19:15
Fix a problem with the savepoint code and in-memory journals. (CVS 6061) check-in: 26ceebf3 user: danielk1977 tags: trunk
16:23
Fix an OOM problem in where.c. (CVS 6060) check-in: d2105f61 user: drh tags: trunk
15:58
Make sure nOverflow is always cleared when a page is released. (CVS 6059) check-in: 8d0f7244 user: drh tags: trunk
13:35
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) check-in: d77a7023 user: drh tags: trunk
11:46
Add a test to savepoint.test that tests that nothing goes wrong if an incremental vacuum occurs inside a savepoint. (CVS 6057) check-in: fc4f0621 user: danielk1977 tags: trunk
11:11
In sqlite3AddColumn(), use local variable 'db' instead of 'pParse->db'. (CVS 6056) check-in: 0c53a4c2 user: danielk1977 tags: trunk
10:37
Fix a couple of assert() failures that can occur in btree.c and pager.c. (CVS 6055) check-in: ae44e748 user: danielk1977 tags: trunk
2008-12-22
15:04
Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054) check-in: bbdc0e9f user: danielk1977 tags: trunk
11:43
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) check-in: ee0e6eae user: danielk1977 tags: trunk
10:58
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) check-in: bb177e30 user: danielk1977 tags: trunk
03:37
Fix a variable type to prevent a warning in the proxy-locking code. (CVS 6051) check-in: d9595b96 user: danielk1977 tags: trunk
2008-12-21
03:51
Continue refactoring where.c in preparation for installing OR-clause optimizations. (CVS 6050) check-in: 778e91dd user: drh tags: trunk
2008-12-20
18:33
Add a vfs backend that detects problems like the one addressed by (6043) and (6047). (CVS 6049) check-in: 49172e48 user: danielk1977 tags: trunk
13:18
Do not use long long constants in code. Ticket #3547. (CVS 6048) check-in: 51b3bfc3 user: drh tags: trunk
08:39
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) check-in: 68833626 user: danielk1977 tags: trunk
02:14
Specify type "void" in the parameter list of functions that take no parameters. Tickets #3545 and #3546. (CVS 6046) check-in: c2228bd1 user: drh tags: trunk
02:06
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) check-in: c3f7aa01 user: drh tags: trunk
2008-12-19
18:45
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) check-in: e06a968a user: danielk1977 tags: trunk
16:31
Add some crash-tests for savepoint. Fix a bug revealed by these tests. (CVS 6043) check-in: 6f36c166 user: danielk1977 tags: trunk
11:37
Add the file ext/fts3/README.syntax, containing documentation describing the two query syntaxes now supported by fts3. (CVS 6042) check-in: ed81ad5a user: danielk1977 tags: trunk
2008-12-18
22:25
Fix the Oracle and MS-Sql command-line terminator logic in the CLI. Ticket #3544. (CVS 6041) check-in: dcc8935f user: drh tags: trunk
18:31
Increase test coverage of new savepoint code. (CVS 6040) check-in: d915718d user: danielk1977 tags: trunk
15:45
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) check-in: 98a53d91 user: danielk1977 tags: trunk
05:30
Fix a bug in icuOpen() in fts2. (CVS 6038) check-in: b9c722bd user: danielk1977 tags: trunk
2008-12-17
19:22
Update the WHERE clause processing infrastructure in preparation for adding multi-index OR evaluation. (CVS 6037) check-in: 78401b33 user: drh tags: trunk
17:30
Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) check-in: 34b56600 user: danielk1977 tags: trunk
15:49
Fix some strict-aliasing problems in fts3_expr.c. (CVS 6035) check-in: 20a4ca5d user: danielk1977 tags: trunk
15:18
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) check-in: 7389b9ec user: danielk1977 tags: trunk
2008-12-16
18:15
Version 3.6.7 (CVS 6033) check-in: f4f40370 user: drh tags: trunk, release
17:20
Fix a compile error in an assert() and a warning with MSVC builds. (CVS 6032) check-in: 8b8f6a6a user: shane tags: trunk
13:46
Make sure the memory returned from sqlite3ScratchMalloc() is 8-byte aligned. Ticket #3542. (CVS 6031) check-in: 13b56b7f user: drh tags: trunk
2008-12-15
22:51
New hyperlinks added to C interface documentation. No changes to working code. (CVS 6030) check-in: 230cb68e user: drh tags: trunk
16:33
Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029) check-in: 4685ffcc user: drh tags: trunk
15:27
Convert the "~" and "NOT" operators to be two-address instructions. Ticket #3541. (CVS 6028) check-in: ea9b747e user: drh tags: trunk
2008-12-14
14:45
Add the example from #3359 to the test suite. (CVS 6027) check-in: 84f8417c user: danielk1977 tags: trunk
02:55
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) check-in: adba0f3c user: drh tags: trunk
2008-12-12
19:19
Add many new integer boundary value tests. Ticket #3536. (CVS 6025) check-in: 45277238 user: drh tags: trunk
17:56
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) check-in: e545490a user: drh tags: trunk
2008-12-11
20:03
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) check-in: f6c50f35 user: drh tags: trunk