SQLite
Timeline
Not logged in

50 most recent timeline items

2016-07-27
19:39 • Edit [bf46179d44843769|bf46179d]: Edit check-in comment. (user: drh)
19:33
[719a3b20] Leaf: Fix some problems with multi-column IN(SELECT...) processing. (user: dan, tags: rowvalue)
19:30
[9e2b2681] Leaf: Enhance the query planner cost estimation for index scans to take into account WHERE clause terms that can be computed using only the index and that do not require looking up rows in the original table. This fixes an obscure performance regression that arose when the ORDER BY LIMIT optimization was added by check-in [bf46179d44843]. (user: drh, tags: trunk)
19:20
[50f8ea37] Closed-Leaf: Add test cases and fix a comment. (user: drh, tags: improved-index-scan)
18:27
[a59b5622] When estimating the cost of an index scan, factor in the cost savings of being able to use the index to evaluate some WHERE clause terms without having to do a table lookup. (user: drh, tags: improved-index-scan)
16:03
[4d59df02] Initialize a variable in where.c to avoid a valgrind warning. (user: dan, tags: trunk)
2016-07-26
18:15
[d4f3d52c] Merge latest trunk changes into this branch. (user: dan, tags: rowvalue)
18:06
[061b8006] Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. (user: dan, tags: rowvalue)
15:17
[91e811f5] Leaf: Merge fixes to sqlite3_scrub_backup() from trunk. (user: drh, tags: apple-osx)
10:46
[483994a5] Ensure that the sqlite3_scrub_backup() extension creates a backup database at least as large as indicated by the database header, even if the last page of the input database is a free-list leaf. (user: dan, tags: trunk)
04:54
[cc6bfdf8] Merge the cache_spill VACUUM fix from trunk. (user: drh, tags: apple-osx)
04:49
[c0e7d98e] Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. (user: drh, tags: trunk)
04:31
[b819bace] Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (user: drh, tags: trunk)
04:24 • Fixed ticket [a0bac8b3]: CREATE INDEX changes the answer plus 3 other changes (user: drh)
04:23
[0e9f534f] Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (user: drh, tags: apple-osx)
04:21 • Ticket [a0bac8b3] CREATE INDEX changes the answer status still Open with 6 other changes (user: drh) ... 1 similar event omitted.
2016-07-25
22:46
[cdb7efd0] Merge the VACCUM cache_size adjustment from trunk. (user: drh, tags: apple-osx)
22:40
[b78d9954] In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. (user: drh, tags: trunk)
21:11
[a495f8e7] Fix a test case in FTS5 to make it compatible with Tcl 8.5. (user: drh, tags: trunk)
18:50
[68ecd8e0] Add the experimental SQLITE_VACUUM_CACHE_SIZE macro. (user: drh, tags: apple-osx)
17:31
[e98cefb1] Merge 3.14 alpha changes from trunk. (user: drh, tags: apple-osx)
16:10
[8dcb9d50] Minor test infrastructure changes to better support SEE testing. (user: drh, tags: trunk)
14:40
[38a48cfb] Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. (user: drh, tags: trunk)
14:20
[9e7bedee] Changes to test scripts to get them all running on OpenBSD. (user: drh, tags: trunk)
12:10
[d6f6c87c] Disable the DBSTATUS_CACHE_USED_SHARED tests on mac when memsys3/5 is disabled due to differences in the allocation sizes for the Darwin memory allocator. (user: drh, tags: trunk)
12:01
[ea7fb98b] Update the vacuummem.test script so that it works on mac as well as on linux. (user: drh, tags: trunk)
11:57
[ccc22e14] If both MEMSYS3 and MEMSYS5 are enabled, than automatically disable MEMSYS3. (user: drh, tags: trunk)
11:39
[5f40e6ad] Another attempt at getting --enable-memsysN working. (user: drh, tags: trunk)
11:32
[67955255] Fix the --enable-memsysN options in configure so that they actually work. (user: drh, tags: trunk)
11:27
[67e1dc98] Add --enable-memsys3 and --enable-memsys5 options to the configure script. (user: drh, tags: trunk)
02:42
[e1e02238] Evidence marks and code reformatting for SQLITE_TRACE_STMT operation. (user: drh, tags: trunk)
02:31
[163e1522] Change SQLITE_TRACE_STMT to return unexpanded SQL text in the X argument. Add documentation on how and when to use sqlite3_expanded_sql(P) to compute the expanded text for legacy sqlite3_trace() compatibility. (user: drh, tags: trunk)
00:05
[1c5baae3] Fix code so that the deprecated sqlite3_trace() and sqlite3_profile() interfaces are not called when SQLITE_OMIT_DEPRECATED is used. (user: drh, tags: trunk)
2016-07-23
20:27
[c8e0539b] Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. (user: drh, tags: trunk)
20:24
[e2fd6f49] Allow vector IN(SELECT ...) expressions to use an index if either all the indexed columns are declared NOT NULL or if there is no difference between the expression evaluating to 0 and NULL (as in a WHERE clause). (user: dan, tags: rowvalue)
19:34
[269892ab] Add the json_quote() function to the JSON1 extension. (user: drh, tags: trunk)
19:20 • Edit [549abe3f89b55b05|549abe3f]: Marked "Closed". (user: drh)
19:18
[8817dedb] Small tweak to the btree balancer for improved tree balance. (user: drh, tags: trunk)
14:50
[d0bcaf0c] Fix recently added tests so that they work in all configurations. (user: drh, tags: trunk)
05:22
[99a6c518] Add the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces. (user: drh, tags: trunk)
04:58
[0400f642] Closed-Leaf: Improvements to sqlite3_trace_v2() documentation. Fix the sqlite3VdbeExpandSql() routine to respond better to OOM conditions. (user: drh, tags: sqlite3_trace_v2)
02:07
[ebd388e9] Add requirements marks to the sqlite3_trace_v2() interface documentation. (user: drh, tags: sqlite3_trace_v2)
00:43
[5a027fe4] Fix sqlite3VdbeExpandSql() so that it handles OOMs by always returning NULL. (user: drh, tags: sqlite3_trace_v2)
2016-07-22
21:35
[f50a3fd6] Revise a warning fix from the previous check-in to improve clarity. Also, fix an incorrect test prefix (typo). (user: mistachkin, tags: trunk)
21:26
[8bb6e6fc] Fix harmless compiler warnings seen with MSVC. (user: mistachkin, tags: trunk)
20:45
[527b5ba6] Be sure to hold the database connection mutex while calling sqlite3VdbeExpand() from within sqlite3_expanded_sql(). (user: drh, tags: sqlite3_trace_v2)
20:20
[409535e6] Add requirements marks to the sqlite3_expanded_sql() documentation. (user: drh, tags: sqlite3_trace_v2)
17:58
[60fed5cd] Merge latest trunk changes with this branch. (user: dan, tags: rowvalue)
10:09
[87e25fc4] Fix a problem with upper case module names in the "sqldiff --vtab" command. (user: dan, tags: trunk)