SQLite
Timeline
Not logged in

50 most recent timeline items

2017-02-18
22:52
[e842ad39] Leaf: Updated comments. No code changes. (user: drh, tags: auto-analyze)
20:05
[c1adf959] Leaf: Add an optimization to OP_Column to speed up sequential OP_Column instructions that read earlier fields from the same cursor. Attempt to reorder OP_Column opcodes so as to take advantage of this. (user: dan, tags: sort-column-opcodes)
15:58
[d386015f] Add the OP_SqlExec opcode and use it to implement "PRAGMA analyze_as_needed", invoking ANALYZE subcommands as necessary. This simplifies the implementation. (user: drh, tags: auto-analyze)
13:47
[49181427] Leaf: Add the SQLITE_BUG_COMPATIBLE_20160819 compile-time option to omit the error message when an unrecognized argument is provided to the VACUUM command. (user: drh, tags: trunk)
02:42
[4229caec] Fix errors in the table resize detection. (user: drh, tags: auto-analyze)
02:19
[882599a4] In the analyze_as_needed pragma, avoid running unnecessary OP_LoadAnalysis and OP_Expire opcodes. Make the analyze_as_needed pragma responsive to the schema name. (user: drh, tags: auto-analyze)
2017-02-17
23:52
[8cc9d74c] Fix the #endif location for an #ifndef SQLITE_UNTESTABLE macro in the command-line shell. (user: drh, tags: trunk)
21:23
[38298ef9] Leaf: Increase the estimated cost of sorting when sorting wide results sets, to account for the extra storage space and I/O required for the external sort. (user: drh, tags: apple-increased-sorting-cost)
19:24
[bfbdd074] The analyze_as_needed pragma now responds to table size growth and will automatically rerun the analysis after each 10x size increase. (user: drh, tags: auto-analyze)
16:26
[e93db237] Add the "PRAGMA analyze_as_needed" command. (user: drh, tags: auto-analyze)
15:26
[fb2b8ae8] Set the TF_StatsUsed flag on tables when the query planner outcome is affected by the sqlite_stat1 data. Also, change the column names of the "PRAGMA stats" command so that they are not keywords. (user: drh, tags: auto-analyze)
13:38
[85026c8e] Enhance the Index and Table objects so that they remember if their stats come from the sqlite_stat1 table. Make the "PRAGMA stats" an SQLITE_DEBUG only pragma. Add the flags column to "PRAGMA stats". These are all preliminary steps toward a "PRAGMA analyze_ifneeded;" feature. (user: drh, tags: auto-analyze)
02:07
[662e8ccf] Leaf: Merge fixes from trunk. (user: drh, tags: increased-sorting-cost)
02:04
[218b2bbb] Fix a test case that was made to fail by the LIKE optimization enhancement in check-in [158290c0ab] but which went unnoticed because test builds were running with ICU enabled and ICU disables the LIKE optimization. (user: drh, tags: trunk)
01:43
[8a03be1d] Enable the ".wheretrace" and ".selecttrace" extensions in the command-line shell when compiled on Windows using DEBUG=3 or higher. Fix a harmless warning in the shell that comes up when compiled this way. (user: drh, tags: trunk)
2017-02-16
21:29
[aa0703e5] Increase the estimated cost of sorting when sorting wide results sets, to account for the extra storage space and I/O required for the external sort. (user: drh, tags: increased-sorting-cost)
20:52
[9fc5cd50] Change the name of WhereInfo.pDistinctSet to pResultSet, since it is now used for more than just DISTINCT processing. (user: drh, tags: trunk)
17:18
[ff5e733c] Change two MallocZero() calls into MallocRaw() to avoid unnecessary memset(). (user: drh, tags: trunk)
16:26
[bb8e2642] Fix a comment on a field of the ExprList object. No changes to code. (user: drh, tags: trunk)
15:57
[7e14044c] Increase Table.tabFlags from 8 to 32 bits. (user: drh, tags: trunk)
15:06
[6bd82b95] Remove two redundant initializations from the virtual table logic. (user: drh, tags: trunk)
14:48
[6affb1c8] Always use the IsVirtual() macro to determine if a Table object is a virtual table. Slightly smaller and faster code. (user: drh, tags: trunk)
14:02
[325ccfa9] Leaf: Merge recent enhancements from trunk. (user: drh, tags: est_count_pragma)
2017-02-15
22:36
[58797e9b] Query planner optimization to detect empty tables in a join early and bail out without doing excess work. (user: drh, tags: trunk)
18:30
[830b9235] Minor enhancement to mutex tracing on Win32. (user: mistachkin, tags: trunk)
17:47
[1d4759c1] Leaf: simple test cases for carray_asc. (user: drh, tags: carray_asc)
16:11
[a2b4f60b] Add the companion "carray_asc" table-valued function to the carray extension. (user: drh, tags: carray_asc)
16:09 • Edit [396b9d99ae43cc5c|396b9d99]: Move to branch mistake. Mark "Closed". Edit check-in comment. (user: drh)
16:04
[396b9d99] Closed-Leaf: Bummer. Checked this in as a branch off of the wrong branch.... Was: Add the companion "carray_asc" table-valued function to the carray extension. (user: drh, tags: mistake)
15:11
[8d3f485d] Leaf: Remove the CLANG_VERSION macro, since we have learned that version numbers in clang are "marketing" and are inconsistent and unreliable. Builds using clang will still use the GCC_VERSION macro since clang works hard to be gcc compatible. (user: drh, tags: branch-3.17)
15:09
[810d2932] Remove the CLANG_VERSION macro, since we have learned that version numbers in clang are "marketing" and are inconsistent and unreliable. Builds using clang will still use the GCC_VERSION macro since clang works hard to be gcc compatible. (user: drh, tags: trunk)
04:16
[ee1e6896] Further reforms to Tcl_*Alloc() usage. (user: mistachkin, tags: trunk)
01:39
[1d267757] In the blob test code, avoid crashing on low-memory systems by using Tcl_AttemptAlloc(). (user: mistachkin, tags: trunk)
01:02
[4ca2b2f8] Leaf: Make SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX. (user: mistachkin, tags: mutexDbg2)
00:52
[82ef47ea] Another compilation fix for POSIX. (user: mistachkin, tags: mutexDbg2)
00:45
[79057716] Make fine time granularity work on POSIX. (user: mistachkin, tags: mutexDbg2)
00:02
[9964ad24] Compilation fix for POSIX. (user: mistachkin, tags: mutexDbg2)
2017-02-14
23:58
[80481754] Experimental enhancements to mutex debugging. (user: mistachkin, tags: mutexDbg2)
21:47
[ca4f1e49] Clarification of the help text for the command-line shell. (user: drh, tags: trunk)
20:00
[54836270] Enable the SQLITE_ENABLE_NULL_TRIM option for WITHOUT ROWID tables. (user: drh, tags: trunk)
16:30
[e4731fd6] More realistic lengths of string values in speedtest1 with --testset orm. (user: drh, tags: trunk)
15:58
[58b2f911] Fix a testcase number on the ORM testset of speedtest1. (user: drh, tags: trunk)
15:57
[1836adc1] Add the new "--testset orm" to the speedtest1 utility. (user: drh, tags: trunk)
2017-02-13
16:17
[1913a758] Leaf: Merge all changes up through the 3.17.0 release. (user: drh, tags: apple-osx)
16:02
[ada05cfa] Version 3.17.0 (user: drh, tags: release, branch-3.17, version-3.17.0)
13:35
[670f10b2] Change all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for consistency. (user: drh, tags: trunk)
13:26
[f3b65926] Fix typos in using the MSVC_VERSION macro. (user: drh, tags: trunk)
13:20
[c447441c] Avoid a duplication #define in FTS5 (user: drh, tags: trunk)
11:35
[25ebadd0] Fix typos in using the MSVC_VERSION macro. (user: drh, tags: branch-3.17)
2017-02-11
15:02
[b2e49ae3] Ensure that indexed expressions with collating sequences are handled correctly. Fix for ticket [eb703ba7b50c1a5] backported from trunk. (user: drh, tags: branch-3.17)