SQLite

Timeline
Login

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

100 events occurring around 9607600b6ca9b546.

2011-10-04
16:37
Add tests to check that modifying the schema of an FTS content table does not cause a crash in the FTS module. Also disable the deferred token optimization for content=xxx FTS tables. (check-in: be86c706 user: dan tags: fts4-content)
11:22
Add experimental 'content' option to FTS4. (check-in: 1d27ea74 user: dan tags: fts4-content)
2011-10-03
17:58 Edit [eaf447ea87b0ff29|eaf447ea]: Mark "Closed". Edit check-in comment. (artifact: 44c3c5a9 user: drh)
17:57 Edit [a7e18468825622e5|a7e18468]: Mark "Closed". (artifact: ada7ff27 user: drh)
17:57 Edit [4a153f010037db83|4a153f01]: Mark "Closed". Edit check-in comment. (artifact: 29c0b3bb user: drh)
15:30
Merge the STAT3 changes into trunk. (check-in: 774d0842 user: drh tags: trunk)
2011-10-02
05:23
Update MSVC makefile to allow targets to be built with support for ICU. (check-in: eb5da5e1 user: mistachkin tags: trunk)
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)