Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 607aba6cd7020973.
2011-09-19
| ||
20:32 | Merge in all trunk changes through the 3.7.8 release. (check-in: ade72b18 user: drh tags: apple-osx) | |
20:28 | Merge in all trunk changes through the version 3.7.8 release. (check-in: 98619a23 user: drh tags: sessions) | |
18:19 | • Edit [3e0da808d2f5b4d1|3e0da808]: Add tag "release". (artifact: 8b48848f user: drh) | |
18:19 | • Edit [3e0da808d2f5b4d1|3e0da808]: Change background color to "#d0c0ff". Edit check-in comment. Timestamp 2011-09-19 18:00:00. Add tag "version-3.7.8". (artifact: b3bb0812 user: drh) | |
18:00 | Version 3.7.8 (check-in: 3e0da808 user: drh tags: trunk, release, version-3.7.8) | |
17:38 | • Closed ticket [1a1308d2]: Nested correlated subquery fails when indices used (artifact: 83c8b691 user: drh) | |
17:37 | • Closed ticket [002caede]: LEFT JOIN with OR terms in WHERE clause causes assertion fault (artifact: 3576c0c2 user: drh) | |
17:37 | • Closed ticket [d6352363]: Assertion fault on a join with a repeated column (artifact: 32d3d342 user: drh) | |
17:37 | • Closed ticket [6c14288a]: Virtual tables do not handle IS NOT NULL correctly (artifact: 62ce185b user: drh) | |
17:37 | • Closed ticket [d6ddba67]: Parser accepts invalid CREATE TRIGGER syntax (artifact: df4af5ed user: drh) | |
17:37 | • Closed ticket [25ee8127]: PRAGMA case_sensitive_like=1 fails (artifact: dcb466d4 user: drh) | |
17:37 | • Closed ticket [91e2e8ba]: Automatic indices cause undesirable type conversions (artifact: 7e156286 user: drh) | |
17:36 | • Closed ticket [bd484a09]: Date/time functions do not detect failure of localtime_r() (artifact: d1ee170d user: drh) | |
13:01 | Increase the default lookaside cache line size from 100 to 128 bytes. (check-in: db019465 user: drh tags: trunk) | |
11:57 | Remove a stray merge-sort related change from pager.c and pager.h. (check-in: 69823ed1 user: dan tags: trunk) | |
2011-09-17
| ||
18:56 | Remove a couple of comments that were causing problems for the amalgamation generator script. (check-in: ffed86bf user: drh tags: apple-osx) | |
17:29 | Add a new script to build an amalgamation that omits FTS3/4 and RTREE. (check-in: b31a7d7d user: drh tags: trunk) | |
15:34 | Make sure the file structure is zeroed prior to calling the VFS to open a file. (check-in: 29c4d0dd user: mistachkin tags: trunk) | |
2011-09-16
| ||
22:10 | Fix a problem with SQLITE_OMIT_TRACE that was introduced by the recent OP_Once change. (check-in: 96be3f7b user: drh tags: trunk) | |
21:32 | • Edit [7f00552b739fad79|7f00552b]: Mark "Closed". Edit check-in comment. (artifact: a9f6e319 user: drh) | |
20:43 | Fix #if's in winSync to avoid compiler warnings about unused local variables. Also, update version numbers in the MSVC makefile. (check-in: 2e66e414 user: mistachkin tags: trunk) | |
20:16 | Silence harmless compiler warning about redefinition of the _CRT_SECURE_NO_WARNINGS macro by shell.c. (check-in: 69022071 user: mistachkin tags: trunk) | |
19:40 | Merge the latest trunk changes into the sessions branch. (check-in: 5efb0294 user: drh tags: sessions) | |
19:36 | Merge the latest trunk fixes into the apple-osx branch. (check-in: 070bf203 user: drh tags: apple-osx) | |
19:29 | Merge all the latest trunk changes into the experimental STAT3 branch. (check-in: 51908c8f user: drh tags: stat3-trunk) | |
19:04 | • Fixed ticket [1a1308d2]: Nested correlated subquery fails when indices used plus 2 other changes (artifact: 5264e143 user: drh) | |
19:04 | Remove unreachable branches from the previous change. Add additional test cases. (check-in: cf51ef8a user: drh tags: trunk) | |
18:17 | • Fixed ticket [002caede]: LEFT JOIN with OR terms in WHERE clause causes assertion fault plus 2 other changes (artifact: a25beefa user: drh) | |
17:43 | When analyzing the right-hand side of IN operators to see if the IN operator can work with an index, be sure to decend into nested subqueries. Fix for ticket [1a1308d2538d7] (check-in: 0156f10e user: drh tags: trunk) | |
16:20 | • New ticket [1a1308d2] Nested correlated subquery fails when indices used. (artifact: f68bc318 user: drh) | |
16:00 | Further streamlining of the subquery materializer. New test cases for ticket [002caede898a] (check-in: ff8b76b2 user: drh tags: trunk) | |
01:38 | Merge the [002caede898] fix into trunk. (check-in: 95708ae2 user: drh tags: trunk) | |
01:34 | Add the new OP_Once opcode. Use it to clean up and simplify various one-time initialization sections in the code, including the fix for ticket [002caede898ae]. (Closed-Leaf check-in: 7f00552b user: drh tags: tkt-002caede898) | |
00:01 | • Edit [4b8357ee3c4ccdbd|4b8357ee]: Edit check-in comment. (artifact: 1b3a9ea6 user: drh) | |
2011-09-15
| ||
23:58 | Materialize subqueries using a subroutine and invoke that subroutine prior to each use of the materialization. Fix for ticket [002caede898aee4] (check-in: 4b8357ee user: drh tags: tkt-002caede898) | |
19:39 | Adding test case for ticket [002caede898] (check-in: 62dfc51a user: drh tags: tkt-002caede898) | |
18:54 | • New ticket [002caede] LEFT JOIN with OR terms in WHERE clause causes assertion fault. (artifact: 80aac112 user: drh) | |
00:40 | Cleanup/fix error handling when no arguments are supplied to the SQLite analyzer. (check-in: 3fc566ac user: mistachkin tags: trunk) | |
2011-09-14
| ||
19:52 | • Edit [a9d8794ae949df57|a9d8794a]: Mark "Closed". (artifact: aff7cd7d user: drh) | |
19:52 | • Edit [5ed7633d41b99929|5ed7633d]: Mark "Closed". (artifact: 7335c965 user: drh) | |
19:52 | • Edit [4cb17881d9676fa3|4cb17881]: Mark "Closed". (artifact: a3b1a06d user: drh) | |
19:51 | • Edit [2aff1b0ca87a99b8|2aff1b0c]: Mark "Closed". Edit check-in comment. (artifact: ace2682f user: drh) | |
19:50 | • Edit [36f11acc531a5244|36f11acc]: Mark "Closed". (artifact: 514f4f74 user: drh) | |
19:50 | • Edit [a6b85c73406caa3b|a6b85c73]: Mark "Closed". Edit check-in comment. (artifact: 0c5e61e7 user: drh) | |
19:50 | • Edit [91daea7d2ec41f01|91daea7d]: Mark "Closed". (artifact: d9ef716b user: drh) | |
19:41 | Merge latest changes from the trunk into the sessions branch. (check-in: c00e45ed user: dan tags: sessions) | |
19:05 | Merge in the latest changes from trunk. (check-in: 2456b4d0 user: drh tags: apple-osx) | |
18:19 | Remove 'const' from a variable that might actually be written when an OOM error occurs. Also, fix a couple MSVC/Win32 compiler warnings. (check-in: 3035dc1c user: mistachkin tags: trunk) | |
13:41 | Remove unused parameters from internal routines in vdbesort.c. This is an additional simplification made possible by recent optimizations. (check-in: a1f3aeeb user: drh tags: trunk) | |
13:23 | Remove code from vdbesort.c that was made unreachable by the recent sqlite3VdbeRecordUnpack() optimizations. (check-in: 607aba6c user: drh tags: trunk) | |
11:16 | • Closed ticket [56be9768]: Buffer overrun in FTS prefix queries plus 2 other changes (artifact: e4256312 user: dan) ... 1 similar event omitted. | |
2011-09-13
| ||
19:09 | Merge the latest trunk changes into the stat3-trunk branch. (check-in: 11ca4ed8 user: drh tags: stat3-trunk) | |
19:08 | Allocate the correct size for the output buffer in fts3DoclistOrMerge(). Fix for [56be976859]. (check-in: 07788c0f user: dan tags: trunk) | |
18:48 | • New ticket [56be9768] Buffer overrun in FTS prefix queries. (artifact: 424c0064 user: dan) | |
2011-09-11
| ||
10:14 | Cleanup pdb/ilk files generated by the MSVC makefile. (check-in: a9db247b user: mistachkin tags: trunk) | |
2011-09-05
| ||
20:16 | Fix a minor performance regression in btreeMoveto(). (check-in: d0712dfb user: dan tags: trunk) | |
14:20 | Refactor the sqlite3VdbeRecordUnpack() interface to better accommodate the vdbesort.c module. (check-in: f115b230 user: dan tags: trunk) | |
2011-09-04
| ||
01:27 | Fix a compiler warning about an unused parameter in the merge-sort code. (check-in: 6b657ae7 user: drh tags: trunk) | |
01:11 | Improve the testability of the merge-sort logic. (check-in: b5179baf user: drh tags: trunk) | |
2011-09-03
| ||
17:07 | • Edit [99e34bdce4ccca15|99e34bdc]: Mark "Closed". (artifact: 1206b8e4 user: drh) | |
17:07 | Performance improvements to the external merge-sorter. Keep content on an in-memory linked lists rather than an ephemeral table prior to spilling to disk. Use the external merge-sorter to implement ORDER BY and GROUP BY in addition to CREATE INDEX. (check-in: 4c43e8b2 user: drh tags: trunk) | |
16:42 | Simplification and performance tweaks in vdbeSorterMerge(). (Closed-Leaf check-in: 99e34bdc user: drh tags: merge-sort) | |
14:36 | Reduce the number of VdbeRecordUnpack() calls made in vdbesort.c. (check-in: 666c2c3c user: dan tags: merge-sort) | |
00:17 | The build works again with -DSQLITE_OMIT_MERGE_SORT. The merge-sorter now avoids spilling to disk (letting the in-memory linked list grow without bound) if PRAGMA temp_store=3. (check-in: 68e26c44 user: drh tags: merge-sort) | |
2011-09-02
| ||
21:42 | Remove some dead code. Fix a faulty assert(). Improve some variable names. (check-in: a9a64592 user: drh tags: merge-sort) | |
18:03 | Combine two malloc calls in vdbesort.c. (check-in: cf48ad83 user: dan tags: merge-sort) | |
15:41 | Reduce the number of malloc() calls made when creating an index on more than 2 columns. (check-in: 065b0c98 user: dan tags: merge-sort) | |
15:08 | Remove unused local variable. (check-in: 61bda876 user: mistachkin tags: trunk) | |
11:45 | If all data being sorted fits in memory, avoid writing any data out to temporary files in vdbesort.c. (check-in: 71075673 user: dan tags: merge-sort) | |
10:31 | Instead of a temporary b-tree, use a linked-list and merge-sort to sort records in main memory in vdbesort.c. (check-in: 7769fb98 user: dan tags: merge-sort) | |
2011-09-01
| ||
16:01 | Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY. (check-in: ebf819aa user: drh tags: merge-sort) | |
15:32 | Experimental code-generator changes to utilize new opcodes for sorting. (check-in: bab2e560 user: drh tags: merge-sort) | |
2011-08-31
| ||
23:57 | Avoid using uninitialized variables after failures in the merge sort code. (check-in: 2869ed28 user: drh tags: trunk) | |
21:01 | Formerly, we enabled fdatasync() on linux only. But now we learn that fdatasync() is not supported on Android. So we disable fdatasync() on Linux too. It can be reenabled at compile-time for those who really need it. (check-in: 70b5b309 user: drh tags: trunk) | |
20:47 | Add the SQLITE_MAX_SCHEMA_RETRY compile-time option to the set of options understood by "PRAGMA compile_options;" and by the "sqlite_compileoption_used()" function. (check-in: 1b124af4 user: drh tags: trunk) | |
19:40 | The server1.test script should only run if mutexes are functional. Fix to the #ifdef change of check-in [9e6a4c1473]. (check-in: 64898485 user: drh tags: trunk) | |
18:35 | Always include the unixShm.id field, even when not debugging. (check-in: 07803476 user: drh tags: trunk) | |
18:04 | Only create the sqlite3OSTrace global variable if compiling with SQLITE_TEST. (check-in: 9e6a4c14 user: drh tags: trunk) | |
17:46 | Backslash escaping is not working right in tostr.awk on the latest ubuntu. The easiest fix is to simply not use any backslashes in the spaceanal.tcl script. (check-in: df550066 user: drh tags: trunk) | |
13:27 | Add checks to make sure cells in corrupt database files do not overflow a page when doing autovacuum. Problem detected by valgrind. (check-in: d0b347b4 user: drh tags: trunk) | |
2011-08-30
| ||
19:52 | Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time option. (check-in: 20ddfb47 user: drh tags: trunk) | |
01:29 | Change the build process so that it does not require the unix "sort" command. This avoids confusion between ms-sort and mingw-sort on windows systems. (check-in: f1bd5bba user: drh tags: trunk) | |
01:23 | Make sure SQLITE_FCNTL_SIZE_HINT a no-op if the chunk size is not greater than zero. (check-in: 88b763e8 user: mistachkin tags: trunk) | |
00:58 | Fix a total unimportant file descriptor leak in lemon. This is to silence warning messages. (check-in: e95cf2c5 user: drh tags: trunk) | |
00:53 | Fix a buffer overrun in test logic. No impact on the core SQLite. (check-in: 49cd60e3 user: drh tags: trunk) | |
2011-08-29
| ||
18:24 | Fix a broken assert() statement in select.c. (check-in: ad78ef2b user: dan tags: trunk) | |
11:56 | Back out [05c9832e5f6eb] since it was causing a performance regression with no obvious benefit. (check-in: 639cc85a user: drh tags: trunk) | |
03:08 | Merge performance enhancements into trunk. (check-in: 5a00d24b user: drh tags: trunk) | |
02:49 | About a 1% overall performance improvement by using a macro to avoid no-op calls to sqlite3MemReleaseExternal(). (Closed-Leaf check-in: ff71d20a user: drh tags: experimental) | |
02:16 | Small performance improvement to OP_Column. (check-in: b6b73a74 user: drh tags: experimental) | |
2011-08-28
| ||
02:15 | About a 3% improvement in the performance of OP_Column. (check-in: edff9d4a user: drh tags: experimental) | |
00:19 | Correctly display P4_ADVANCE values on opcode traces. Mark an always-taken branch in OP_Column as such. (check-in: 087dc960 user: drh tags: experimental) | |
2011-08-27
| ||
18:48 | Experimental changes to improve the performance of OP_Next. (check-in: 1a249845 user: dan tags: experimental) | |
2011-08-26
| ||
20:55 | Fix several harmless compiler warnings and a documentation bug. (check-in: 5454d0fe user: drh tags: trunk) | |
19:20 | Merge the latest trunk changes into the sessions branch. (check-in: eb036d6f user: drh tags: sessions) | |
19:18 | Merge the latest trunk changes into the apple-osx branch. (check-in: 55af8003 user: drh tags: apple-osx) | |
18:28 | Veryquick and min.rc tests now passing. (Closed-Leaf check-in: a7e18468 user: drh tags: stat3-3.7.2) | |
18:04 | Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. (check-in: a42db19d user: drh tags: stat3-3.7.2) | |
17:17 | Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. (check-in: 41b5f869 user: drh tags: branch-3.7.2) | |