/ Timeline
Login

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

100 check-ins occurring around f3398fc4db765e2c.

2009-12-04
08:41
Reset the state of the asynchronous IO module at the end of the tkt-94c04eaadb.test script. check-in: e8ae7e98 user: dan tags: trunk
05:41
Do not run fts3rnd.test as part of quick.test. check-in: 3bb64842 user: dan tags: trunk
01:44
Clear a conflicting TCL variable in the fts3rnd.test test script. check-in: f9047b2e user: drh tags: trunk
2009-12-03
21:26
Fix an assert() in btree.c that might have fired on a corrupt database file. check-in: 5ab2b3e3 user: drh tags: trunk
19:40
Remove a NEVER() from btree.c that could occur in a very obscure tested evaluation with an I/O error on fstat(). check-in: d5861d9f user: drh tags: trunk
17:36
Fix an incorrect assert() in fts3.c. Add further fts3 tests. check-in: 75863c2d user: dan tags: trunk
06:26
Updates to FTS3 to correct compiler warnings under MSVC. check-in: 37495b55 user: shaneh tags: trunk
04:40
Fix a couple of compiler warnings under MSVC. check-in: e3aa0870 user: shaneh tags: trunk
04:32
Fix cut-and-paste error affecting a couple of attach tests on Windows. check-in: 59e2e2c6 user: shaneh tags: trunk
01:01
Add links from C/C++ interfaces to their equivalent SQL functions. Comment changes only - no changes to code. check-in: acce10f7 user: drh tags: trunk
2009-12-02
20:25
Change an error message in FTS3 to avoid using an uninitialized variable. check-in: 620a8a2b user: drh tags: trunk
18:16
Fix an uninitialized value read in sqlite3async.c. check-in: 1cf2136c user: dan tags: trunk
18:03
Fix compiler warnings in test_hexio.c. check-in: 6a2e0725 user: drh tags: trunk
16:09
Modify a test in fts3b.test to reflect the fact that the docid field may now be updated. check-in: ef5b7450 user: dan tags: trunk
14:44
Clear the Pager.dbModified flag when unlocking the database. Assert that it is clear when locking the database. check-in: d17ec16b user: dan tags: trunk
02:49
Make sure a variable is cleared before use in the where8.test script. check-in: b3436529 user: drh tags: trunk
2009-12-01
22:09
Add testcase() macros to make sure boundary cases in BEFORE UPDATE triggers are well tested. check-in: 27175caa user: drh tags: trunk
18:46
Fix a faulty function prototype in test_intarray.c. check-in: 110956a6 user: drh tags: trunk
17:08
Use #include "sqlite3.h" instead of <sqlite3.h> in fts3Int.h. check-in: 7737db49 user: dan tags: trunk
17:05
Add typedefs for i16 and u8 to fts3Int.h when not building via the amalgamation method. check-in: fa56c1c4 user: dan tags: trunk
15:04
Add tests for the remaining examples in fts3.in. check-in: e381cd52 user: dan tags: trunk
14:31
Reorder function declarations in mutex_os2.c. This is a blind change - we have no capability of testing on OS/2. Ticket [97214a34d814] check-in: c40e4ef0 user: drh tags: trunk
13:57
Changes to the TCL interface header to allow it to be compiled independently from the amalgamation. check-in: 58113932 user: drh tags: trunk
13:48
Open a savepoint within the FTS3 optimize() function. check-in: 4924fbb2 user: dan tags: trunk
12:00
Fix a segfault that can occur when querying an empty FTS3 table. Also restore the rowid/docid conflict handling to work as it did in version 3.6.20. check-in: c022f66b user: dan tags: trunk
2009-11-30
19:48
Test coverage improvements in the FTS3 porter stemmer. check-in: 6d112bfd user: drh tags: trunk
08:55
Add test cases for examples recently added to documentation file fts3.html. check-in: 498922cc user: dan tags: trunk
2009-11-28
21:33
Updates to snippet() and offsets() functions of FTS3 so that they work sanely following an OOM fault. check-in: b939a37a user: drh tags: trunk
17:23
Change FTS3 to detect when the RHS of the MATCH opertor encounters an OOM during string format conversion and report back an SQLITE_NOMEM error. check-in: 31eed4f8 user: drh tags: trunk
17:07
Remove all benign OOM failure opportunities from the FTS3 hash table implementation. All OOM faults cause SQLITE_NOMEM to be returned. check-in: 80754d38 user: drh tags: trunk
15:35
Add a test case for creating an FTS3 table with no module arguments or opening/closing brackets in the CREATE VIRTUAL TABLE statement. check-in: a9cba7ea user: dan tags: trunk
13:46
Initialize a variable (unnecessarily) to avoid a compiler warning. check-in: db65fd59 user: drh tags: trunk
12:40
Fix a bug introduced by the fts3 refactoring (segfault when creating a table with zero module args). Also a fix to handle an OOM error. check-in: eada284b user: dan tags: trunk
2009-11-27
18:31
Change the test numbers in e_fkey.test so that they are in order. check-in: ca73be44 user: dan tags: trunk
12:14
Remove a C++ism accidentally added to fts3.c. check-in: 97d33241 user: dan tags: trunk
12:12
Move [7d30880114] to the trunk. Add optimizations to reduce the number of opcodes used for BEFORE UPDATE triggers. check-in: 1b7c5250 user: dan tags: trunk
2009-11-26
14:01
Simplifications to the sqlite3_trace() bound parameter substitution logic. check-in: cb4b9286 user: drh tags: trunk
2009-11-25
22:42
Make sure the new fts3Int.h header file is added to the amalgamation. check-in: f25558f3 user: drh tags: trunk
21:05
Support zeroblob in trace output. check-in: 5086bf8e user: drh tags: trunk
19:35
Get trace with parameter insertion working for UTF16 databases. check-in: 01d5451a user: drh tags: trunk
18:03
Initial check-in of code that inserts tokenizations of the values for bound parameters into the output of sqlite3_trace(). check-in: 545cfb3b user: drh tags: trunk
16:53
Enhance the %q, %Q, and %w printf conversions so that the precisions specifies the length of the input. check-in: 3ba77313 user: drh tags: trunk
2009-11-24
19:02
Recomputed unchanged column values in an UPDATE statement after running BEFORE triggers, in case the triggers have modified any of those values. Closed-Leaf check-in: 7d308801 user: drh tags: experimental
16:26
Fix a tracing macro in the VDBE in the VColumn opcode. check-in: cb74b81b user: drh tags: trunk
02:37
Fix SQLITE_SECURE_DELETE so that it overwrites content on the root pages of tables and indices that are dropped using the truncate optimization. check-in: 02ef972a user: drh tags: trunk
2009-11-23
21:23
Make sure registers computed for the VFilter opcode are marked invalid after the VFilter opcode finishes. Ticket [16fbf14cb2]. check-in: 83dc7d38 user: drh tags: trunk
15:59
Rearrange the order of two branches in order to restore 100% branch coverage after recent changes to in-memory database processing. check-in: 6ce6ff44 user: drh tags: trunk
14:39
Change so that deleting an Expr structure requires only one frame per level in the expression tree, not two. check-in: a4380ab3 user: dan tags: trunk
13:17
Bump the version number to 3.6.21. check-in: 39214aee user: drh tags: trunk
2009-11-21
03:03
Add some missing comments to fts3 files. No source code changes. check-in: b6402b20 user: dan tags: trunk
01:33
Fix a bug in transaction rollback during backup when the CODEC is enabled that can result in a corrupt backup file. This is only a problem when SQLITE_HAS_CODEC is defined. check-in: f3398fc4 user: drh tags: trunk
2009-11-20
18:48
When moving pages as part of autovacuum on an in-memory database, make sure that the source location is journalled so that a ROLLBACK can occur. Part of the fix for ticket [564d412f15a00] check-in: 2f42f91f user: drh tags: trunk
17:23
Merge leaf accidentally created by [1c4984c62f]. check-in: cae949ce user: dan tags: trunk
17:18
Add a test to make sure a database can be attached to a single handle twice if not in shared-cache mode. check-in: 1c4984c6 user: dan tags: trunk
16:13
Fix a bug in LIMIT 0 for compound SELECT statement. The problem was introduced by recent enhancements and has not appeared in any release. check-in: c6ed7e2a user: drh tags: trunk
15:02
If the root pages numbers of the internal schema are adjusted due to autovacuum on a DROP TABLE statement and that statement later aborts (for example, due to an OOM error) then reset the internal schema at the conclusion of the statement. Partial fix for ticket [564d412f15a]. check-in: e493b093 user: drh tags: trunk
13:18
Avoid unnecessary page cache allocations when move a page while autovacuuming an in-memory database, since the allocation might fail making it impossible to rollback the transaction. check-in: 9a429349 user: drh tags: trunk
05:05
Improve comments and other things in fts3_write.c. check-in: 1cf0e3cc user: dan tags: trunk
02:24
Minor optimizations to fts3 code. check-in: b456eacb user: dan tags: trunk
2009-11-19
18:30
Merge leaves [7cd178a72a] and [598727e6da]. check-in: 4115c0c2 user: dan tags: trunk
18:28
Fix a performance regression introduced while reworking the fts3 code. check-in: 7cd178a7 user: dan tags: trunk
15:44
Remove an unreachable branch from the OP_Affinity suppression logic. check-in: 598727e6 user: drh tags: trunk
15:26
Merge fts3-refactor into the main trunk. check-in: 551dbe30 user: dan tags: trunk
15:25
Fix some fts3 related issues with the autoconf and amalgamation build systems. Closed-Leaf check-in: 3b179247 user: dan
14:57
Merge with [4bd4330709]. check-in: 7a46d1eb user: dan tags: fts3-refactor
14:52
Merge the fts3-refactor branch with the trunk. check-in: c8d2bd37 user: dan tags: fts3-refactor
14:48
Fix a bug introduced with recent optimizations: The unary minus operator is TK_UMINUS, not TK_MINUS. check-in: 4bd43307 user: drh tags: trunk
00:15
Fix problems introduced into fts3 as part of the refactoring. check-in: fa0998e1 user: dan tags: fts3-refactor
2009-11-18
23:01
Performance improvement by avoiding unnecessary calls to memset(). check-in: 85940468 user: drh tags: trunk
15:35
Add some missing comments and fix some other issues in fts3 code. check-in: 2fe579e7 user: dan tags: fts3-refactor
01:25
Suppress more instances of unnecessary OP_IsNull and OP_Affinity opcodes. check-in: bf6c0bd1 user: drh tags: trunk
2009-11-17
23:59
Enhancements to the VDBE opcode loop to reduce the number of machine-code instructions evaluated by about 10%. check-in: 9744ffb3 user: drh tags: trunk
18:31
Code generator tries to avoid pointless OP_IsNull and OP_Affinity opcodes. check-in: ebb0c8a3 user: drh tags: trunk
12:52
Improvements to the way fts3 reads the full-text index. check-in: 45c051e7 user: dan tags: fts3-refactor
2009-11-16
23:36
Make sure the output of sqlite3OsFullPathname is initialized even if the fails due to I/O or OOM errors. check-in: e4943adb user: drh tags: trunk
22:54
Fix a reference to freed memory that can occur following an OOM error in where.c. check-in: 929b6047 user: drh tags: trunk
21:28
Back out part of the change in [23ea2b700fd6d28d] since TH3 reveals some problems in OOM situations. check-in: 15d215d6 user: drh tags: trunk
16:36
Add a few extra coverage test cases for fts3. check-in: f29c8fca user: dan tags: fts3-refactor
15:11
Use the sqlite3CtypeMap to improve the speed and reduce the size of the logic in the tokenizer that recognizes identifiers. check-in: 1c9243b0 user: drh tags: trunk
03:13
Additional optimizations in sqlite3VdbeRecordCompare(). check-in: 23ea2b70 user: drh tags: trunk
02:14
Optimizations to the sqlite3VdbeRecordCompare() routine help it to run 12.5% faster for some traces. check-in: 74c76f0b user: drh tags: trunk
2009-11-15
06:50
Fixes to fts3 integrity check code. check-in: d3cae986 user: dan tags: fts3-refactor
2009-11-14
23:22
Optimizations to the main loop inside sqlite3VdbeExec() to help VDBE byte code run a few percent faster. check-in: d622ac6a user: drh tags: trunk
18:41
Further OOM testing for fts3 code. Add Tcl code implementing an integrity-check for fts3. check-in: c27d46b3 user: dan tags: fts3-refactor
18:04
Make the sqlite3VdbeExec() function about 2% faster by storing the opcode array in a local variable. check-in: 8bd3cc82 user: drh tags: trunk
2009-11-13
20:52
Performance improvements and size reductions on the OP_Seek* family of VDBE opcodes. check-in: ed820f45 user: drh tags: trunk
19:43
Simplify the OPFLG processing logic in the VDBE for a speed boost in the VDBE processing loop and a reduction in code size. check-in: 3352b3eb user: drh tags: trunk
17:36
Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.). check-in: 30a92f11 user: dan tags: fts3-refactor
17:05
Force 8-byte memory alignment on memory allocated for VDBE cursors. check-in: bdc45ba7 user: drh tags: trunk
10:04
Changes to test_intarray.c so that it build with SQLITE_OMIT_VIRTUALTABLE. Added testcase() macros to expr.c. check-in: f0599d28 user: drh tags: trunk
2009-11-12
20:39
Shift more OP_Found opcodes over to using the unpacked format, for improved performance. check-in: 6705ab1a user: drh tags: trunk
19:59
Enhance the OP_Found and OP_NotFound opcodes so that they can accept an array of registers as an unpacked record in addition to a record built using OP_MakeRecord. Use this to avoid OP_MakeRecord calls during IN expression processing. check-in: b9eab885 user: drh tags: trunk
17:52
Factor out the IN operator code generation into a subroutine. Use this subroutine to implement both logic and branching versions of the IN operator. check-in: fcff5b7e user: drh tags: trunk
13:32
Factor out the code generator for BETWEEN into a subroutine. check-in: 5735f60b user: drh tags: trunk
05:04
Update comment for substrFunc(). Added additional SUBSTR() test cases. check-in: d7b3801d user: shaneh tags: trunk
04:26
Suppress unnecessary OP_Noop instructions on when the right table of a LEFT JOIN uses the index-only optimization. check-in: e8aec08b user: drh tags: trunk
03:46
Suppress excess OP_Null opcodes caused by binary IS or IS NOT operators that are converted into unary ISNULL or NOTNULL operators. check-in: cff1b36a user: drh tags: trunk
03:13
Adjustments to the implementation of LIMIT so that it uses fewer opcodes. check-in: 39d5b292 user: drh tags: trunk
2009-11-11
23:58
If the sector size is unspecified (initially 0) then set it to 512, not to 32. check-in: 8861b5c1 user: drh tags: trunk
23:48
Remove an obsolete (and incorrect) comment from sqlite3MemCompare(). No changes to code. check-in: c15b70b3 user: drh tags: trunk