SQLite
Timeline
Not logged in

30 ancestors of [6feff15c]

2016-07-28
12:52
[6feff15c] Leaf: New test case to insure legacy CREATE TABLE syntax is supported. (user: drh, tags: trunk)
2016-07-27
19:30
[9e2b2681] 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
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: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)
2016-07-25
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)
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)
19:34
[269892ab] Add the json_quote() function to the JSON1 extension. (user: drh, tags: trunk)
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)