SQLite

Timeline
Login

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

100 events occurring around 5a9e746357aa8ede.

2009-11-16
12:43 Fixed ticket [29ab7be9]: Hitting NOT NULL constraint does not roll back statement transaction plus 1 other change (artifact: ba930fde user: drh)
12:42 Ticket [58a75d62] encoding failure status still Closed with 2 other changes (artifact: 70c78f04 user: drh)
12:41 Ticket [98f156c7] status still Closed with 1 other change (artifact: 417f8c89 user: drh)
12:38 Ticket [19b44e35] sqlite3_bind_text inconsistent with NULL pointers, zero length etc status still Open with 1 other change (artifact: a6463ad0 user: drh)
12:36 Closed ticket [3211d778]: replace function works on blobs plus 4 other changes (artifact: 3a08fd95 user: drh)
12:34 Ticket [8f81455b] fts3GetVarint32 sets random number on error status still Open with 3 other changes (artifact: fb39b2d0 user: drh)
12:33 Closed ticket [e123bd22]: POSIX File handles aren't always immediately released on sqlite3_close plus 3 other changes (artifact: 344215c5 user: drh)
12:27 Closed ticket [60f26ed7]: Empty Title plus 5 other changes (artifact: b17123de user: drh)
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:51 Edit [d3cae986ee1a176b|d3cae986]: Timestamp 2009-11-15 06:50:11. (artifact: d8edbd54 user: dan)
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:42 Edit [c27d46b33e8596b4|c27d46b3]: Timestamp 2009-11-14 18:41:01. (artifact: 636e3204 user: dan)
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:44 Edit [30a92f1132801c75|30a92f11]: Timestamp 2009-11-13 17:36:21. (artifact: a27a5d95 user: drh)
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)
21:55 New ticket [60f26ed7] . (artifact: f1be9b9a user: anonymous)
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 Fixed ticket [f5cb008a]: Shell silently ignores extra parameters plus 3 other changes (artifact: e603814c user: shane)
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
23:31 Ticket [61d35ac2] A way to tell if a journal should exist status still Open with 3 other changes (artifact: 24ad0a80 user: rogerb)
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 Ticket [aeff892c] -batch mode not creating DB in CLI status still Fixed with 1 other change (artifact: 2b554fd1 user: shane)
17:07
Fix for datbase name being ignored with the -batch option in the CLI. Ticket [aeff892c57]. (check-in: 8097c64a user: shaneh tags: trunk)
17:07 Fixed ticket [aeff892c]: -batch mode not creating DB in CLI plus 2 other changes (artifact: 16f4678b user: shane) ... 2 similar events omitted.
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:22 Fixed ticket [f12a9eee]: Shell command argument parsing is lax plus 2 other changes (artifact: 84f729d1 user: shane)
17:20
Improved shell "dot" command argument handling. Ticket [f12a9eeedc]. (check-in: 9fb69919 user: shaneh tags: trunk)
04:42 Ticket [33fdaab1] Need to cancel an integrity check in progress with sqlite3_interrupt status still Open with 3 other changes (artifact: 5b925eca user: rogerb) ... 1 similar event omitted.
04:15 Fixed ticket [0bf974bd]: backup api asserts with zero length source file plus 5 other changes (artifact: daf649bb user: drh)
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)
03:04 New ticket [0bf974bd] backup api asserts with zero length source file. (artifact: fcecca71 user: shane)
03:00 Edit [eb7a544fe49d1626|eb7a544f]: Timestamp 2009-11-04 13:30:02. Add tag "release". (artifact: e52df996 user: drh)
2009-11-05
18:47 Edit [bd443f39a947ae84|bd443f39]: Mark "Closed". Edit check-in comment. Timestamp 2009-11-05 17:27:25. (artifact: b5499bd9 user: drh)
18:47 Edit [590d4ac1ee0db824|590d4ac1]: Change branch background color to "#c0c0c0". Move to branch shunning-error. Timestamp 2009-11-04 18:51:17. (artifact: 87a77199 user: drh)
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)
17:27
Do not limit the trigger recursion depth when SQLITE_SMALL_STACK is defined since trigger recursion uses the heap, not the stack. (Closed-Leaf check-in: bd443f39 user: drh tags: shunning-error)
16:29
Add a comment related to code coverage. No changes to code. (check-in: 6bdc2c99 user: drh tags: shunning-error)
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
23:53 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: d6615d6c user: shane)
23:02
Fix a typo on the ynVar typedef that unfortunately caused 3.6.20 to be released with a "bug" that causes excess memory usage for Expr objects. This bug should be benign in the sense that the correct answer is still always obtained - it only uses more more memory than is really necessary. (check-in: f1c09aca user: drh tags: shunning-error)
21:49
Do not accept a codec no an in-memory database. (check-in: 6f3081a8 user: drh tags: shunning-error)
18:51
Fix documentation typos. (check-in: 590d4ac1 user: drh tags: shunning-error)
18:16 Edit [eb7a544fe49d1626|eb7a544f]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2009-11-04 13:30:02. (artifact: f228c7ca user: drh)
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:48 Edit [941a01eb868815f5|941a01eb]: Change branch background color to "#c0ffc0". Edit check-in comment. Timestamp 2009-11-03 22:34:36. (artifact: a3c2a90c user: drh)
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)
19:18
Enhancements to lemon to generate more compact action tables and to avoid making array bounds tests that can never fail on action table calculations. (check-in: 27d8e684 user: drh tags: trunk)
14:30 Edit [64989904d44556ee|64989904]: Change background color to "#ffc0d0". Timestamp 2007-08-13 20:31:01. Add tag "release". (artifact: 1336cae0 user: drh)
13:08
Force all qsort() calls in mkkeywordhash.c to be stable so that we get predictable results on different platforms. (check-in: 3b02df27 user: drh tags: trunk)
13:02
Adjust the lemon implementation so that it always computes the same PDA regardless of qsort() implementation on the host platform. In other words, make all sorts in lemon stable. (check-in: d66a0f31 user: drh tags: trunk)
01:22
All SQLITE_MAX_VARIABLE_NUMBER to exceed 32767. The sizes of some structures increase when the compile-time parameter is configured this way. (check-in: 16a24b44 user: drh tags: trunk)
2009-11-02
18:44
Bug fix in the recent changes to mkopcodeh.awk. (check-in: 6610cac4 user: drh tags: trunk)
18:14
Update the generator AWK script for opcodes.h so that it always generates opcode numbers in the same order and is not dependent on the hash order of opcode names within AWK. (check-in: e730195f user: drh tags: trunk)
18:01
Do not insert the date and time of generation into the amalgamation. (check-in: 9f6cf13d user: drh tags: trunk)
17:40
Update the configure script for version 3.6.20. (check-in: f19cb105 user: drh tags: trunk)
15:51
Comment changes in support of better documentation. No changes to code. (check-in: 79ab4714 user: drh tags: trunk)
2009-11-01
19:26
Fix compiler warnings. Better comments on some variables associated with LIKE/GLOB processing in the query planner. (check-in: cfa2db0f user: drh tags: trunk)
2009-10-30
14:27
Increase the version number to 3.6.20. (check-in: 61295274 user: drh tags: trunk)
14:05 Fixed ticket [6b00e0a3]: The great OP_If bug plus 3 other changes (artifact: a67b11ba user: drh) ... 1 similar event omitted.
13:27 Edit [2a832b19b657ba02|2a832b19]: Timestamp 2009-10-30 13:26:54. Add tag "release". (artifact: 9bac7e4d user: drh)
13:26
Version 3.6.16.1 (Leaf check-in: 2a832b19 user: drh tags: release, branch_3_6_16)
13:25
Avoid storing the result register for EXISTS and SELECT in any field of the Expr object - simply return the register number as the return value of the function that codes those expressions. (check-in: 7253f8fa user: drh tags: trunk)
2009-10-29
18:43 Edit [65a1f1334d92873e|65a1f133]: Change branch background color to "#fff0c0". Edit check-in comment. Timestamp 2009-10-29 18:38:22. (artifact: 865f94ad user: drh)
18:38
Fix a 16-bit integer overflow that might occur in statements that use both an EXISTS clause and IN operator with a RHS holding in excess of 32K entries. (check-in: 65a1f133 user: drh tags: branch_3_6_16)