/ Timeline
Login

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

100 check-ins occurring around ee1e689633e517ce.

2017-02-23
02:15
Add two NEVER() operators in the sqlite3BtreeRowCountEst() routine. check-in: 7a959f6d user: drh tags: auto-analyze
00:58
Do a single OP_Expire at the very end of "PRAGMA optimize", and omit the OP_Expire on ANALYZE commands invoked by the pragma. check-in: 188300a3 user: drh tags: auto-analyze
2017-02-22
20:24
Change the name of the analyze_as_needed pragma to "optimize". Enhance the comment (which will become documentation, assuming these changes land on trunk) to explain that the optimize pragma is likely to be enhanced in various ways in future releases and that applications should not depend upon the current behavior. check-in: 9fced545 user: drh tags: auto-analyze
19:49
Merge integrity_check and other improvements from trunk. check-in: fe073905 user: drh tags: auto-analyze
19:41
Move a branch condition in analyze.c inside an #ifdef SQLITE_ENABLE_STAT4 block. check-in: d6afd98d user: dan tags: trunk
19:27
Improve the performance of ANALYZE when SQLITE_ENABLE_STAT4 is defined. check-in: 737a8244 user: dan tags: trunk
18:53
Improvements to PRAGMA integrity_check. Verify CHECK constraints. Verify NOT NULL constraints even on table that lack indexes. Verify CHECK and NOT NULL constraints with PRAGMA quick_check. check-in: aa02bd3c user: drh tags: trunk
18:04
Cleanup and simplification of the output row count limit control of PRAGMA integrity_check. Closed-Leaf check-in: 5af7d72e user: drh tags: integrity-check-improvements
15:11
Fix integrity_check so that it verifies NOT NULL constraints even for tables that have no indexes. Enhance quick_check so that it verifies NOT NULL and CHECK constraints. check-in: 5264844b user: drh tags: integrity-check-improvements
14:15
Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. check-in: 549bae08 user: drh tags: integrity-check-improvements
2017-02-21
21:24
In sqlite3VdbeHalt(), return as soon as possible if Vdbe.magic!=VDBE_MAGIC_RUN. This makes sqlite3_reset() slightly faster in some cases. check-in: 80adc0cb user: dan tags: trunk
17:52
Fix an FTS5 problem that could cause a crash when certain queries were interrupted using sqlite3_interrupt(). check-in: e400909f user: dan tags: trunk
15:27
Very small enhancement to dispatch speed for SQL functions. check-in: 3c3228ed user: drh tags: trunk
14:04
The VDBE cycle counts for the sqlite3_progress_handler() callback are now cumulative. Leftovers from the previous statement are applied to the next statement. Leaf check-in: 7a62fc6a user: drh tags: cumulative-progress-count
13:29
Proof of concept for a "PRAGMA vdbe_cycle_limit=N" command. When N>0, invoke sqlite3_interrupt() whenever any byte code program uses more than N virtual machine cycles. Leaf check-in: 9626b41e user: drh tags: vdbe_cycle_limit
2017-02-20
23:32
Correct a harmless typo in the previous check-in. check-in: 1589db01 user: mistachkin tags: trunk
19:13
Avoid unsigned integer overflows for SQLITE_WIN32_HEAP_INIT_SIZE when the Win32 heap subsystem is used with very large values of SQLITE_DEFAULT_CACHE_SIZE and/or SQLITE_DEFAULT_PAGE_SIZE. check-in: 96b6a98e user: mistachkin tags: trunk
14:30
Small grammar simplification. check-in: 0d8a868a user: drh tags: trunk
13:11
Merge fixes from trunk. check-in: ff213f2e user: drh tags: auto-analyze
2017-02-18
22:52
Updated comments. No code changes. check-in: e842ad39 user: drh tags: auto-analyze
20:05
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. Leaf check-in: c1adf959 user: dan tags: sort-column-opcodes
15:58
Add the OP_SqlExec opcode and use it to implement "PRAGMA analyze_as_needed", invoking ANALYZE subcommands as necessary. This simplifies the implementation. check-in: d386015f user: drh tags: auto-analyze
13:47
Add the SQLITE_BUG_COMPATIBLE_20160819 compile-time option to omit the error message when an unrecognized argument is provided to the VACUUM command. check-in: 49181427 user: drh tags: trunk
02:42
Fix errors in the table resize detection. check-in: 4229caec user: drh tags: auto-analyze
02:19
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. check-in: 882599a4 user: drh tags: auto-analyze
2017-02-17
23:52
Fix the #endif location for an #ifndef SQLITE_UNTESTABLE macro in the command-line shell. check-in: 8cc9d74c user: drh tags: trunk
21:23
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. Leaf check-in: 38298ef9 user: drh tags: apple-increased-sorting-cost
19:24
The analyze_as_needed pragma now responds to table size growth and will automatically rerun the analysis after each 10x size increase. check-in: bfbdd074 user: drh tags: auto-analyze
16:26
Add the "PRAGMA analyze_as_needed" command. check-in: e93db237 user: drh tags: auto-analyze
15:26
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. check-in: fb2b8ae8 user: drh tags: auto-analyze
13:38
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. check-in: 85026c8e user: drh tags: auto-analyze
02:07
Merge fixes from trunk. Leaf check-in: 662e8ccf user: drh tags: increased-sorting-cost
02:04
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. check-in: 218b2bbb user: drh tags: trunk
01:43
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. check-in: 8a03be1d user: drh tags: trunk
2017-02-16
21:29
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. check-in: aa0703e5 user: drh tags: increased-sorting-cost
20:52
Change the name of WhereInfo.pDistinctSet to pResultSet, since it is now used for more than just DISTINCT processing. check-in: 9fc5cd50 user: drh tags: trunk
17:18
Change two MallocZero() calls into MallocRaw() to avoid unnecessary memset(). check-in: ff5e733c user: drh tags: trunk
16:26
Fix a comment on a field of the ExprList object. No changes to code. check-in: bb8e2642 user: drh tags: trunk
15:57
Increase Table.tabFlags from 8 to 32 bits. check-in: 7e14044c user: drh tags: trunk
15:06
Remove two redundant initializations from the virtual table logic. check-in: 6bd82b95 user: drh tags: trunk
14:48
Always use the IsVirtual() macro to determine if a Table object is a virtual table. Slightly smaller and faster code. check-in: 6affb1c8 user: drh tags: trunk
14:02
Merge recent enhancements from trunk. check-in: 325ccfa9 user: drh tags: est_count_pragma
2017-02-15
22:36
Query planner optimization to detect empty tables in a join early and bail out without doing excess work. check-in: 58797e9b user: drh tags: trunk
18:30
Minor enhancement to mutex tracing on Win32. check-in: 830b9235 user: mistachkin tags: trunk
17:47
simple test cases for carray_asc. Leaf check-in: 1d4759c1 user: drh tags: carray_asc
16:11
Add the companion "carray_asc" table-valued function to the carray extension. check-in: a2b4f60b user: drh tags: carray_asc
16:04
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. Closed-Leaf check-in: 396b9d99 user: drh tags: mistake
15:11
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. check-in: 8d3f485d user: drh tags: branch-3.17
15:09
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. check-in: 810d2932 user: drh tags: trunk
04:16
Further reforms to Tcl_*Alloc() usage. check-in: ee1e6896 user: mistachkin tags: trunk
01:39
In the blob test code, avoid crashing on low-memory systems by using Tcl_AttemptAlloc(). check-in: 1d267757 user: mistachkin tags: trunk
01:02
Make SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX. Leaf check-in: 4ca2b2f8 user: mistachkin tags: mutexDbg2
00:52
Another compilation fix for POSIX. check-in: 82ef47ea user: mistachkin tags: mutexDbg2
00:45
Make fine time granularity work on POSIX. check-in: 79057716 user: mistachkin tags: mutexDbg2
00:02
Compilation fix for POSIX. check-in: 9964ad24 user: mistachkin tags: mutexDbg2
2017-02-14
23:58
Experimental enhancements to mutex debugging. check-in: 80481754 user: mistachkin tags: mutexDbg2
21:47
Clarification of the help text for the command-line shell. check-in: ca4f1e49 user: drh tags: trunk
20:00
Enable the SQLITE_ENABLE_NULL_TRIM option for WITHOUT ROWID tables. check-in: 54836270 user: drh tags: trunk
16:30
More realistic lengths of string values in speedtest1 with --testset orm. check-in: e4731fd6 user: drh tags: trunk
15:58
Fix a testcase number on the ORM testset of speedtest1. check-in: 58b2f911 user: drh tags: trunk
15:57
Add the new "--testset orm" to the speedtest1 utility. check-in: 1836adc1 user: drh tags: trunk
2017-02-13
16:17
Merge all changes up through the 3.17.0 release. check-in: 1913a758 user: drh tags: apple-osx
16:02
Version 3.17.0 check-in: ada05cfa user: drh tags: release, version-3.17.0, branch-3.17
13:35
Change all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for consistency. check-in: 670f10b2 user: drh tags: trunk
13:26
Fix typos in using the MSVC_VERSION macro. check-in: f3b65926 user: drh tags: trunk
13:20
Avoid a duplication #define in FTS5 check-in: c447441c user: drh tags: trunk
11:35
Fix typos in using the MSVC_VERSION macro. check-in: 25ebadd0 user: drh tags: branch-3.17
2017-02-11
15:02
Ensure that indexed expressions with collating sequences are handled correctly. Fix for ticket [eb703ba7b50c1a5] backported from trunk. check-in: b2e49ae3 user: drh tags: branch-3.17
14:59
Fix indexes on expressions so that they can be actually used with a COLLATE clause. check-in: e464b919 user: drh tags: trunk
13:51
Ensure that indexed expressions with collating sequences are handled correctly. Proposed fix for ticket [eb703ba7b50c1a5]. check-in: 9689d04b user: drh tags: trunk
2017-02-10
21:40
Bump the version number up to 3.18.0. check-in: 7520c238 user: drh tags: trunk
21:37
Enhance the LIKE optimization so that it works for arbitrary expressions on the LHS as long as the pattern on the RHS does not begin with a digit or a minus sign. check-in: 158290c0 user: drh tags: trunk
19:38
Add the "," flag to printf(). check-in: 064445b1 user: drh tags: trunk
17:38
Version 3.17.0 release candidate check-in: ad867e87 user: drh tags: branch-3.17
2017-02-09
17:12
Cleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option. Remove the SQLITE_RUNTIME_BYTEORDER compile-time option. Use -DSQLITE_BYTEORDER=0 instead. Fix a bug in R-Tree that occurs when compiling on a known little-endian machine without the use of intrinsic byteswapping functions. check-in: 798fb9d7 user: drh tags: trunk
2017-02-08
19:12
Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. check-in: 1afec575 user: dan tags: trunk
19:10
Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. Leaf check-in: 9962c10a user: dan tags: fts3-seekstmt-cache
18:13
Typo fixes in comment. No changes to code. check-in: c09dd5c0 user: mistachkin tags: trunk
16:55
Merge the 3.17.0beta changes from trunk. check-in: 92dbd875 user: drh tags: apple-osx
16:01
Always invoke the xRoundup() method of the memory allocator before calling xMalloc(). check-in: 77b470b0 user: drh tags: trunk
12:18
Round up the size of all memory allocations to a multiple of 8 bytes when using the system memory allocator. check-in: c46e06fa user: drh tags: trunk
2017-02-07
21:44
When generating the hash on the sqlite_master table in dbselftest, use an ORDER BY clause, since the sqlite_master table is reordered by VACUUM. check-in: c8bfd99b user: drh tags: trunk
21:09
MSVC makefile enhancments for several command line tools and the session extensions. check-in: fc1dfe87 user: mistachkin tags: trunk
21:00
Fix harmless compiler warnings in dbfuzz. check-in: 61242267 user: drh tags: trunk
20:57
Fix harmless compiler warnings in kvtest.c check-in: db6b3993 user: drh tags: trunk
20:51
The dbselftest utility now generates hashes in the selftest table with --init. It also accepts multiple database files on the command-line. check-in: e68829c9 user: drh tags: trunk
19:36
Omit fts5fault1.test from the inmemory_journal permutation. check-in: cb1e83f9 user: dan tags: trunk
19:23
Update a test parameter in malloc5.test to account for the increase in default lookaside buffer size. check-in: be82d5ae user: dan tags: trunk
17:36
Add the initial version of the "dbselftest" utility program. check-in: 1fcac836 user: drh tags: trunk
16:15
Update an error message in corruptC.test. check-in: 722e57fe user: dan tags: trunk
14:45
Fix a build problem affecting non-amalgamation rtree builds. check-in: bb7f445b user: dan tags: trunk
14:22
Fix a test case to account for the fact that sqlite3_blob_reopen() now returns SQLITE_IOERR_NOMEM instead of SQLITE_NOMEM if an OOM occurs in the VFS layer. check-in: e11cc523 user: dan tags: trunk
13:51
Fix SQLITE_BYTEORDER #defines in R-Tree when compiled separately from the amalgamation. check-in: a136609c user: drh tags: trunk
12:58
Make the cellMargin() routine of R-Tree slightly smaller and faster while also fixing a harmless compiler warning. check-in: 07fe6228 user: drh tags: trunk
03:44
Back out [ec8ff892ac] which is causing missed OOM errors on some tests. check-in: 0611770d user: drh tags: trunk
00:55
Fix a minor typo in a comment in R-Tree. No changes to code. check-in: f77ee9e9 user: drh tags: trunk
2017-02-06
16:52
Remove a small amount of unnecessary code from R-Tree. check-in: e5aea894 user: drh tags: trunk
15:27
Add the "max-limits" utility program to the tools/ subdirectory. check-in: c54173b6 user: drh tags: trunk
07:37
Fix a bug in kvtest causing "init --variance 0" runs to generate single byte blob values only. check-in: 6b0276f9 user: dan tags: trunk
01:19
Remove incorrect testcase() macros from R-Tree. check-in: 853a58a7 user: drh tags: trunk