/ Timeline
Login

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

100 descendants of [01c4b5b8]

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
20:53
Tweaks to the SUBSTR() function to make it dramatically faster in the common case where the input string is large but the 2nd and 3rd arguments are small positive integers. check-in: 5a474a86 user: drh tags: trunk
13:17
Allow media sector sizes as small as 32. The former minimum size was 512. check-in: 5a32bfc1 user: drh tags: trunk
04:17
Modified CLI to raise an error when extra command line options are passed. Added tests to verify correct handling, as well as other basic handling of command line options. Ticket [f5cb008a65]. check-in: 09b4f19f user: shaneh tags: trunk
01:14
Additional test cases for the coalesce() and ifnull() functions. check-in: d0591258 user: drh tags: trunk
00:24
Generate VDBE code for the built-in COALESCE() and IFNULL() functions. This allows unused arguments to never be evaluated, which is a performance win when the unused argument is a subquery. check-in: 30055b25 user: drh tags: trunk
2009-11-10
17:55
Additional intarray test cases and tweaks to comments. check-in: 0c8db5d8 user: drh tags: trunk
17:24
Initial implementation and test cases for the "intarray" virtual table. check-in: 0e7d2925 user: drh tags: trunk
17:07
Fix for datbase name being ignored with the -batch option in the CLI. Ticket [aeff892c57]. check-in: 8097c64a user: shaneh tags: trunk
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. check-in: f6c045f6 user: drh tags: trunk
01:13
Remove from the TCL interface some old code associated with sqlite3_analyzer. check-in: 01f2271e user: drh tags: trunk
01:12
Omit some code that is not used when SQLITE_SECURE_DELETE is defined. check-in: 5a9e7463 user: drh tags: trunk
2009-11-09
19:30
Fix for lock structure sharing with AFP-style locking check-in: 62f15c0a user: adam tags: apple-osx
2009-11-06
17:20
Improved shell "dot" command argument handling. Ticket [f12a9eeedc]. check-in: 9fb69919 user: shaneh tags: trunk
04:13
Fix the backup API so that a backup from an empty database to a non-empty database works. Ticket [0bf974bdf9]. The only changes are in assert() statements. check-in: ddb71cd9 user: drh tags: trunk
03:33
Merged accidental fork. check-in: d410cd4e user: shaneh tags: trunk
03:22
Add some very basic tests for the commands available from the CLI. check-in: 6bf43338 user: shaneh tags: trunk
2009-11-05
18:46
Recover an ophaned branch that resulted from some ill-advised "shunning". This check-in should be identical to [bd443f39a9] except that it should be on the trunk. check-in: 38eaf1ab user: drh tags: trunk
18:31
Fix an undefined variable on non-Mac builds. check-in: 9552de8f user: drh tags: apple-osx
04:14
Update maxRow size after shrinking the row buffer (CSV). Closed-Leaf check-in: d474195a user: shaneh tags: csv_ext
04:01
Removed line limit on rows. check-in: ec08b15f user: shaneh tags: csv_ext
02:34
Initial implementation of a virtual table for CSV files. check-in: 90e63b7d user: shaneh tags: csv_ext
2009-11-04
13:30
Version 3.6.20 check-in: eb7a544f user: drh tags: trunk, release
13:17
Create a new datatype "ynVar" to hold "nVar" (number of variable) values. This is normally 16-bits can can be 32-bits if SQLITE_MAX_VARIABLE_NUMBER is large enough. check-in: 24a4d520 user: drh tags: trunk
01:56
Report errors back up to the ATTACH command if the codec fails to initialize. check-in: a6c69610 user: drh tags: trunk
2009-11-03
22:34
Customizations for OSX contributed by Apple. check-in: 941a01eb user: adam tags: apple-osx
19:42
Fix compiler warnings on MSVC build. check-in: 01c4b5b8 user: shane tags: trunk