Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
117 events for the month beginning 2011-09-01
Following month ↑
2011-09-30
| ||
12:19 | • Closed ticket [c48d99d6]: Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured plus 2 other changes (artifact: 9fbd73a1 user: dan) ... 2 similar events omitted. | |
12:01 | Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (check-in: 9ddfe1e4 user: dan tags: trunk) | |
11:42 | • New ticket [c48d99d6] Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured. (artifact: 64346b71 user: dan) | |
2011-09-28
| ||
01:11 | • Fixed ticket [d1d84037]: import doesn't work on attached databases due to unnecessary quoting plus 2 other changes (artifact: 31182e44 user: drh) | |
01:10 | In the shell, allow arbitrary table names on the ".import" command. Ticket [d1d84037b90a449]. (check-in: f4dd32d3 user: drh tags: trunk) | |
00:50 | Enhance the stat VFS to report out the total size of all pages used by a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. (check-in: 19b8eaaf user: drh tags: trunk) | |
2011-09-27
| ||
21:44 | • Ticket [d1d84037] import doesn't work on attached databases due to unnecessary quoting status still Open with 3 other changes (artifact: e5821bc9 user: rogerb) ... 1 similar event omitted. | |
13:40 | Changes to sqlite3_analyzer to try to avoid integer overflow problems when linking against older versions of TCL. (check-in: 8c846311 user: drh tags: trunk) | |
2011-09-26
| ||
23:07 | • New ticket [57c971fc] Some user defined string functions do not operate correctly on strings with embedded nuls. (artifact: e916c2f4 user: rogerb) | |
19:32 | Changes to the analyzer script to make it work with zipvfs databases. (check-in: d82cffab user: dan tags: trunk) | |
2011-09-25
| ||
17:49 | If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. (check-in: 263c5fb2 user: drh tags: trunk) | |
17:47 | If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. (Closed-Leaf check-in: 4a153f01 user: drh tags: stat3-trunk) | |
2011-09-24
| ||
09:54 | Fix misc3.test so that it works with OMIT_MERGE_SORT builds. (check-in: 87946c62 user: dan tags: trunk) | |
05:55 | Fix some test files so that they work with SQLITE_OMIT_WAL builds. (check-in: a38668dc user: dan tags: trunk) | |
2011-09-23
| ||
18:58 | Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell. (check-in: d279e1a3 user: drh tags: trunk) | |
16:34 | Add the -DBUILD_sqlite option to the compiler when building testfixture.exe using the configure script. (check-in: 15a13b6c user: drh tags: trunk) | |
14:40 | Merge the latest trunk changes into the stat3-trunk branch. (check-in: 0beb88a9 user: drh tags: stat3-trunk) | |
13:59 | Testability enhancements. (check-in: be44928c user: drh tags: stat3-trunk) | |
13:25 | Fix typos in the format description comment of analyze.c. (check-in: 74e27fad user: drh tags: stat3-trunk) | |
2011-09-22
| ||
20:52 | Remove the restriction on the number of entries per index in sqlite_stat3. (check-in: 374343c8 user: drh tags: stat3-trunk) | |
18:46 | Fix an issue in ANALYZE when STAT3 is disabled but both sqlite_stat2 and sqlite_stat3 tables exist. Also add testability tweaks to the STAT3 code. (check-in: 3ca7e449 user: drh tags: stat3-trunk) | |
15:31 | Remove a redundant (and undefined) "forcedelete" command from corruptE.test. (check-in: 6d8d4e16 user: dan tags: trunk) | |
15:05 | • Edit [646db971885bb7b6|646db971]: Mark "Closed". (artifact: d5423142 user: drh) | |
14:56 | Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. (check-in: 4eb46898 user: dan tags: trunk) | |
14:41 | Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number of cache hits and misses on a per-connection basis. (check-in: 5100b6e9 user: dan tags: trunk) | |
14:18 | • Edit [646db971885bb7b6|646db971]: Move to branch mistake. Change background color to "#e0e0e0". (artifact: e13d2642 user: dan) | |
14:17 | • Edit [646db971885bb7b6|646db971]: Cancel tag "trunk". (artifact: 1f7ba885 user: dan) | |
03:13 | • Edit [892723575c033ed3|89272357]: Mark "Closed". (artifact: 1647fb22 user: drh) | |
03:13 | Merge the cache-stats enhancement into trunk. (Closed-Leaf check-in: 646db971 user: drh tags: mistake) | |
00:56 | Update the version number to 3.7.9. (check-in: 14e28eb9 user: drh tags: trunk) | |
00:28 | Fix an uninitialized variable and a misuse of memcpy(). (check-in: ee110d5a user: drh tags: stat3-trunk) | |
00:06 | Integrate build changes for sqlite3_analyzer into the MSVC makefile. Also, more cleanup of build files, including sqlite3_analyzer, for all makefiles. (check-in: af1c5718 user: mistachkin tags: trunk) | |
2011-09-21
| ||
20:10 | Minor tweaks to the TCL code for sqlite3_analyzer. (check-in: 3a261f38 user: drh tags: trunk) | |
18:29 | Remove unnecessary dependencies from the sqlite3_analyzer targets in makefiles. (check-in: 0bd8fd35 user: drh tags: trunk) | |
17:04 | Fix the sqlite3_analyzer target in the configure-generated Makefile. (check-in: 256cdbdc user: drh tags: trunk) | |
16:43 | Change the way the sqlite3_analyzer executable is built. (check-in: 05e3cced user: dan tags: trunk) | |
00:09 | Pull in the latest changes from trunk. Update the STAT3 documentation. (check-in: 63fc3e4b user: drh tags: stat3-trunk) | |
2011-09-20
| ||
15:53 | Add SQLITE_STMTSTATUS_CACHE_HIT/MISS and SQLITE_DB_STATUS_CACHE_HIT/MISS. For querying the number of pager cache hits and misses on a statement or connection basis. (Closed-Leaf check-in: 89272357 user: dan tags: cache-stats) | |
2011-09-19
| ||
20:56 | Minor comment change in the description of the different memory allocator options. No changes to code. (check-in: 36be31ff user: drh tags: trunk) | |
20:43 | • Ticket [bd484a09] Date/time functions do not detect failure of localtime_r() status still Closed with 1 other change (artifact: d9993c4f user: rogerb) | |
20:36 | Merge in all changes through the 3.7.8 release. (check-in: 9607600b user: drh tags: stat3-trunk) | |
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) | |