SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2016-05-24
00:40
[3b28b68e] Leaf: Improvements to the initialization of the push-down automoton for the Lemon-generated parser. Smaller and faster. (user: drh, tags: trunk)
2016-05-23
21:56
[3c2a7705] Use a pointer to the top of the stack rather than an index into the stack in the Lemon-generated parser template, for about 6.6% parser performance gain. (user: drh, tags: trunk)
19:02
[276e92f5] Avoid a minor error message when running RTREE without an sqlite_stat1 table. (user: drh, tags: trunk)
18:27
[9589e937] Closed-Leaf: Fix the rtreeG.test test case. (user: drh, tags: tree-stat1-fix)
18:06
[bfbb6dd8] Remove an extra "finish_test" from the end of rtreeC.test. (user: drh, tags: tree-stat1-fix)
16:16
[3ad2531e] Improve the error messages generated by the rtree module when a constraint fails. (user: dan, tags: trunk)
16:15
[a86e782a] Lemon enhancement: avoid unnecessary reduce actions that convert one non-terminal into another but have no side effects. (user: drh, tags: trunk)
14:24
[b91a5b82] Fix comment typos and improve clarity of presention in Lemon. The output should be identical. (user: drh, tags: trunk)
02:57
[815cc2bb] Leaf: Merge changes from trunk. (user: drh, tags: apple-osx)
00:10
[90411a28] Update the configure script with additional hints on the location of tclConfig.sh, hints needed by the latest versions of Xcode. (user: drh, tags: trunk)
2016-05-21
23:25
[dec13075] More tweaks to improve the performance of the insert logic, slightly. (user: drh, tags: trunk)
20:03
[55f348cd] Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. (user: drh, tags: trunk)
19:10
[2ce11667] Remove some unused legacy code from the btree insert logic. (user: drh, tags: trunk)
12:29
[1dbaf7a1] Yet another minor size reduction and performance increase in the b-tree insert logic. (user: drh, tags: trunk)
11:23
[656aa1ec] Small size reduction and performance increase in the sqlite3BtreeInsert() logic. (user: drh, tags: trunk)
00:45
[8e366f18] Add the shell-script used for routine performance testing. (user: drh, tags: trunk)
2016-05-20
23:51
[96cf821b] Add a simple TCL script for summing cachegrind information for each VDBE opcdoe. (user: drh, tags: trunk)
21:40
[1765672c] Another optimization on the OP_Column opcode. (user: drh, tags: trunk)
20:58
[9db8f214] Fix typo in comment. (user: mistachkin, tags: trunk)
19:51
[5c157474] Slight performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
18:09
[f250166b] Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. (user: drh, tags: trunk)
15:53
[4dc56e86] Performance optimization and size reduction on the freeP4() routine. (user: drh, tags: trunk)
15:24
[1a0d0576] Increase the version number to 3.14.0 since we are already making significant code changes. (user: drh, tags: trunk)
15:15
[3d55d24d] Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. (user: drh, tags: trunk)
14:54
[9033afbb] Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. (user: drh, tags: trunk)
14:11
[559733b0] For queries with both ORDER BY and LIMIT, if the rows of the inner loop are emitted in ORDER BY order and the LIMIT has been reached, then optimize by exiting the inner loop and continuing with the next cycle of the first outer loop. (user: drh, tags: trunk)
13:44
[ed1b30dc] Closed-Leaf: Set the NULLEQ flag on the sequence counter comparison in the ORDER BY LIMIT optimization, to avoid coverage complaints about not testing the NULL case. (user: drh, tags: orderby-limit)
12:22
[645bd696] Autoconf configure.ac adjustment to try to get it to look for both editline and readline automatically. (user: drh, tags: trunk)
2016-05-19
22:13
[852d1eda] In a query with both ORDER BY and LIMIT, if the inner loop satisfies the ORDER BY then try to cut short each invocation of the inner loop once the LIMIT has been satisfied. This check-in is a partial implementation only. (user: drh, tags: orderby-limit)
19:31
[58b516e8] Fixup comments on wctrlFlags value definitions. (user: drh, tags: trunk)
18:56
[d0130584] Clean up the WHERE_* macros used for the wctrlFlags parameter on the sqlite3WhereBegin() interface, freeing up some bits to be used for other things. (user: drh, tags: trunk)
17:51
[cf273741] Optimization marks in vdbe.c. No logic changes. (user: drh, tags: trunk)
16:58
[4737cadc] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
16:21
[1f577e1f] Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. (user: dan, tags: trunk)
11:12
[0d773061] Small size reduction and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2016-05-18
21:03
[c981ab2a] Add the "scrub" utility program that simultaneously backs-up a live database and erases all deleted content. (user: drh, tags: trunk)
21:01
[915416d1] Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (user: drh, tags: trunk)
20:53
[e2e9b985] Merge the 3.13.0 release changes. (user: drh, tags: apple-osx)
10:57
[fc49f556] Version 3.13.0 (user: drh, tags: trunk, release, version-3.13.0)
2016-05-17
21:17
[ab1c5ce5] Closed-Leaf: Enhance the scrub utility program so that it does a FULL checkpoint prior to starting the backup, to ensure that the database file content matches what needs to be backed up without having to look at the WAL file. (user: drh, tags: scrub-backup)
17:11
[5021dfe1] Merge the latest changes from trunk. (user: drh, tags: scrub-backup)
2016-05-16
14:35
[995c084b] Do not run snapshot_fault.test as part of the inmemory_journal permutation. (user: dan, tags: trunk)
13:37
[0d9b82af] Merge recent fixes from trunk. (user: drh, tags: apple-osx)
11:55
[386bcbba] Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. (user: drh, tags: trunk)
2016-05-13
17:22
[b369980f] Improvements to a comment in the pcache.c file. No changes to code. (user: drh, tags: trunk)
15:22
[771c5411] Remove the unused PGHDR_NEED_READ flag. Add invariant checking (during SQLITE_DEBUG builds only) for the PgHdr object. (user: drh, tags: trunk)
12:12
[3401d9dc] Clarification of the pagerFlushOnCommit() logic. (user: drh, tags: trunk)
11:50
[9495d338] Fix pager_end_transaction() to ensure that a ROLLBACK does not clobber unwritten pages in a TEMP file pcache. (user: drh, tags: trunk)
04:24
[32a62e3b] Additional debugging and tracing logic for pcache.c, turned off by default using an "#if 0". (user: drh, tags: trunk)
2016-05-12
19:17
[24d9fbc1] Disable ALWAYS and NEVER when compiled with SQLITE_MUTATION_TEST. (user: drh, tags: trunk)
19:05
[1b0f4cc3] Simplification of the sqlite3FaultSim() call inside of sqlite3PagerCommitPhaseOne(). (user: drh, tags: trunk)
18:38
[3fd71092] Add an assert in pager.c to confirm that pPager->tempFile is always true for in-memory databases. (user: drh, tags: trunk)
17:06
[9d55b8f5] Add extra OPTIMIZATION-IF-FALSE comments where required to pcache.c. (user: dan, tags: trunk)
12:08
[06c1e27c] For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (user: drh, tags: trunk)
12:01
[0dc50d99] Remove an unnecessary call to sqlite3PcacheMakeClean() inside of the ROLLBACK logic. (user: drh, tags: trunk)
09:48
[bc202e5b] Add a missing OPTIMIZATION-IF-FALSE comment to pcache.c. (user: dan, tags: trunk)
2016-05-11
23:54
[ad601c79] Closed-Leaf: For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (user: drh, tags: pager-dev)
20:03
[3bfd2621] Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (user: dan, tags: trunk)
18:20
[4533ed35] Closed-Leaf: Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (user: dan, tags: mistake)
15:41
[9cc8cad7] Remove some a small amount of redundant code related to PCache.pSynced from pcache.c. (user: dan, tags: trunk)
12:47
[345ce1c9] Do not reset the page cache when a rollback journal truncate fails, as doing so can cause loss of information for an in-memory TEMP file. (user: drh, tags: trunk)
11:04
[42fb6f1e] Always truncate, rather than persist, the rollback journal of a TEMP database. (user: drh, tags: trunk)
10:57
[d9313d19] Add pcache tracing macros. Off by default. Requires changing an "#if 0" and recompiling to enable. (user: drh, tags: trunk)
2016-05-10
20:16
[22364024] Add another test case to temptable3.test. (user: dan, tags: trunk)
20:03
[20cf8811] Fix a problem in sqlite3PagerMovepage() when working on a temp table for which pages have been spilled. (user: drh, tags: trunk)
2016-05-09
23:11
[79ecd0ef] Fixes to requirements marks. No changes to code. (user: drh, tags: trunk)
22:35
[8a39c8ee] Enhancements to test/sort5.test so that it works with SEE. (user: drh, tags: trunk)
22:32
[f5875489] Remove some forgotten debugging lines from test/sort5.test. (user: drh, tags: trunk)
19:58
[da94a6e0] Closed-Leaf: Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (user: drh, tags: dev)
19:03
[14e53d0e] Update a comment in fts5.h. No changes to code. (user: dan, tags: trunk)
18:05
[48505cde] Fix the FTS5 xQueryPhrase() API function so that it recognizes column filters. (user: dan, tags: trunk)
2016-05-07
12:15
[d75140b8] Make the sqlite3DeleteTable() routine smaller and faster. (user: drh, tags: trunk)
12:15
[a45fda65] Fix typo in the intpkey-17.2 test. (user: drh, tags: trunk)
2016-05-06
20:23
[3a695263] Simplification to the logic used to decide between OP_Seek and OP_NotExists. Use OP_NotExists for both DELETE and UPDATE. (user: drh, tags: trunk)
18:47
[ab7ab415] Corrections to comments on the whereScanInit() interface. (user: drh, tags: trunk)
16:49
[93a2bace] For DELETE operations, make sure that seeks on the main table are not deferred, since if they are and none of the indexes reference columns of the table, the seek might never occur until the OP_Delete opcode, which is too late. Fix for ticket [16c9801ceba49]. (user: drh, tags: trunk)
16:30
[933a1c81] Fix an error in main.mk causing testfixture to use individual fts5 source code files instead of fts5.c. (user: dan, tags: trunk)
16:06
[150dd09e] Closed-Leaf: In the WHERE generator, when building code for a DELETE operation, make sure that seeks to the main table are not deferred. This is a better fix for the [16c9801ceba49] bug than the previous. (user: drh, tags: ticket-16c9801ce)
15:16
[dc37750d] Fix a bug in sqlite_analyzer causing it report (slightly) incorrect values for the number of entries in indexes or WITHOUT ROWID tables. (user: dan, tags: trunk)
11:31
[50312273] Do not scan indexes that have the integer primary key as their left-most column. This fixes the crash of ticket [16c9801ceba] but it seems like the wrong fix. More investigation needed. (user: drh, tags: ticket-16c9801ce)
2016-05-05
17:15
[bdf2ec77] Initial check-in of the "scrub.exe" utility program prototype. Not yet fully functional. In particular, no scrubbing is done. (user: drh, tags: scrub-backup)
11:53
[69d11447] Renumber internal constants in the printf() implemention for a small performance improvement. (user: drh, tags: trunk)
2016-05-04
21:06
[71af9ac1] Disable the session extension API if SQLITE_ENABLE_SESSION is not defined. (user: drh, tags: trunk)
19:04
[6c43ba1c] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
14:45
[aae38969] Only disable the one-pass DELETE optimization if the WHERE clause contains a correlated subquery. Uncorrelated subqueries are allowed. This is a refinement of check-in [3f221f592a9a1] that is the fix for ticket [dc6ebeda9396087]. (user: drh, tags: trunk)
14:20
[7184c4b8] Portability enhancements to the configure script on the amalgamation tarball. (user: drh, tags: trunk)
11:28
[6341ab2f] Disable the PagerDontWrite() optimization for temp tables. It can cause database corruption if a page passed to PagerDontWrite() is dirty at the start of a transaction that is subsequently rolled back. (user: dan, tags: trunk)
2016-05-03
19:40
[1b43358f] Minor style tweaks in the MSVC makefile. (user: mistachkin, tags: trunk)
19:36
[b6ddabe1] Leaf: Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. (user: mistachkin, tags: win32GetHandle)
14:57
[bcaa650e] The session extension is disabled by default. To enable it using --enable-session on ./configure on unix and add SESSION=1 to the nmake on Windows. Or add -DSQLITE_ENABLE_SESSION and -DSQLITE_ENABLE_PREUPDATE_HOOK to build manually. (user: drh, tags: trunk)
13:14
[e462cde2] Closed-Leaf: Turn the session extension off by default. Enable using --enable-session on configure scripts, or using the SESSION=1 argument to nmake on Windows. (user: drh, tags: session-make)
00:04
[0715ce16] Avoid left-shifts of signed integers. (user: drh, tags: trunk)
2016-05-02
19:05
[5830cf72] Remove some randomness from test script temptable2.test. (user: dan, tags: trunk)
16:59
[088cf838] Fix a test case in temptable2.test so that it works on systems that lack a coherient cache (ex: OpenBSD) and thus do not support the "PRAGMA mmap_size" command. (user: drh, tags: trunk)
15:00
[f52765ee] Merge enhancements and bug fixes from trunk. (user: drh, tags: apple-osx)
13:57
[e4af9675] Fix harmless LLVM compiler warnings in the srcck1.c utility program used during the build process. (user: drh, tags: trunk)
12:18
[3f221f59] Disable the multi-row one-pass DELETE optimization when the WHERE clause contains a subquery. Fix for ticket [dc6ebeda9396087]. (user: drh, tags: trunk)
10:25
[54c63b32] Improvements to the way the LIKE optimization is implemented, resulting in slightly smaller and faster code that is easier to test. (user: drh, tags: trunk)
2016-04-30
19:23
[820c57bb] Change the way tester.tcl handes $argv so that in "permutations.test <permutation> <filename>" <filename> may be the name of any file in the test/ directory. (user: dan, tags: trunk)
18:10
[459a0b45] Remove an unnecessary branch from the OP_String8 opcode. (user: drh, tags: trunk)
17:19
[762bdc55] More bug fixes to Lemon identified by Kelvin Sherlock. None of these have any impact on SQLite. (user: drh, tags: trunk)
02:59
[daf4630f] Simplifications to the OP_Halt opcode implementation. (user: drh, tags: trunk)
2016-04-29
20:30
[614bb709] Fix the temporary directory search algorithm for unix so that it fails gracefully even if all candidate directories are inaccessible. This fixes a bug that was introduced by check-in [9b8fec60d8e]. (user: drh, tags: trunk)
16:01
[91e5c07e] Merge the latest enhancements from trunk. (user: drh, tags: begin-concurrent)
15:52
[81b76901] Merge enhancements from trunk, and in particular the TEMP file deferred I/O enhancements. (user: drh, tags: apple-osx)
15:39
[9d0a5ae0] Postpone I/O associated with TEMP files for as long as possible, with the hope that the I/O can ultimately be avoided completely. (user: drh, tags: trunk)
14:12
[b7bec7f2] Closed-Leaf: Fix test script temptable2.test so that it works with the "inmemory_journal" and "journaltest" permutations. (user: dan, tags: tempfiles-25)
11:35
[99794aca] Merge latest trunk changes, including test case fixes, with this branch. (user: dan, tags: tempfiles-25)
11:33
[4cbd5024] Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. Fix a mostly harmless buffer overread in the sessions module. (user: dan, tags: trunk)
11:28
[4792d6db] Lemon bug fix: Do not merge action routines unless their destructors are also identical. Problem and suggested fix reported on the mailing list by Kelvin Sherlock. (user: drh, tags: trunk)
10:13
[89b0ee33] Closed-Leaf: Fix an almost entirely harmless buffer overread in the sessions module. (user: dan, tags: permutations-fix)
02:55
[e7c22e3b] Some optimization comments added to vdbe.c. No functional changes to code. (user: drh, tags: trunk)
2016-04-28
22:29
[9f15a520] Further simplifications and improved commentting on the rowset.c module, including several optimization comments. (user: drh, tags: trunk)
20:11
[8cdbe89a] Comment changes only: Add several optimization marks in rowset.c. Add a header comment that explains what the various special comments mean. (user: drh, tags: trunk)
19:23
[9f6f17b5] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
18:53
[5748e643] Rearrange some code in the RowSet logic for clarity of presentation, while adding an /*OPTIMIZATION-IF-TRUE*/ comment. It should operate identically. (user: drh, tags: trunk)
14:59
[45467ee4] Merge latest changes from trunk with this branch. (user: dan, tags: permutations-fix)
14:15
[33e62747] Use comments to mark several branches as optimizations. No changes to code. (user: drh, tags: trunk)
03:52
[fcf85bfe] Remove an unnecessary conditional from the sqlite3DecOrHexToI64() routine. (user: drh, tags: trunk)
00:32
[46d4ffff] Change the sqlite3Atoi64() routine so that it returns failure if not all of the input characters are consumed, even if it consumed all characters up to the first 0x00. This has no impact on external APIs as far as I can tell. (user: drh, tags: trunk)
2016-04-27
18:54
[2662d8fe] Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. (user: dan, tags: permutations-fix)
15:24
[0065fe97] More simplification of the sqlite3AtoF() routine. Add special comments to indicate branches that are for optimization purposes only and that give the correct answer even if always or never taken. (user: drh, tags: trunk)
02:35
[3adfe9f3] Remove still more unnecessary branches from sqlite3AtoF(). (user: drh, tags: trunk)
2016-04-26
23:14
[dd69e53c] Further simplifications to sqlite3AtoF() to remove unneeded branches. (user: drh, tags: trunk)
21:02
[a9d00749] Remove an unnecessary line from the sqlite3AtoF() routine. (user: drh, tags: trunk)
18:58
[12418b10] The pcache and the built-in VFSes should not use mutexes when SQLITE_CONFIG_SINGLETHREAD is set. (user: drh, tags: trunk)
16:03
[04911cee] Merge the checksymbols fix from trunk into this branch. (user: dan, tags: tempfiles-25)
13:13
[d819bfbd] Fix the "checksymbols" target in Makefile.in to be able to deal with the sqlite3changegroup family of interfaces. (user: drh, tags: trunk)
2016-04-25
19:25
[7dd48c10] Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (user: dan, tags: trunk)
15:03
[a905d5e0] Merge bug fix from trunk. (user: drh, tags: tempfiles-25)
02:20
[ec215f94] When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. (user: drh, tags: trunk)
01:43
[d0a579b3] Fix a typo in the Makefile. (user: mistachkin, tags: trunk)
2016-04-23
21:16
[9b8fec60] Merge the temporary directory search algorithm fix from trunk. (user: drh, tags: tempfiles-25)
20:59
[b38fe522] Fix the fix to the temporary directory search algorithm so that it continues to return "." as a fallback if that directory has the correct permissions. (user: drh, tags: trunk)
19:55
[84da122d] Merge the latest trunk changes. (user: drh, tags: tempfiles-25)
2016-04-21
23:37
[67985761] Change the temporary directory search algorithm on unix so that directories with only -wx permission are allowed. And do not allow "." to be returned if it lacks -wx permission. (user: drh, tags: trunk)
18:13
[bd4a6f83] Add the sqlite3rbu_vacuum() API, to create an RBU handle that can be used to rebuild a database in the same way as the VACUUM command. (user: dan, tags: trunk)
16:44
[6e4ac704] Closed-Leaf: If a call to sqlite3rbu_close() on an rbu handle opened by sqlite3rbu_vacuum() returns other than SQLITE_OK, delete the contents of the rbu_state table. This ensures that if an RBU vacuum operation either completes successfully or encounters an error, the next call to sqlite3rbu_vacuum() with the same parameters starts a new RBU vacuum operation. (user: dan, tags: rbu-vacuum)
15:44
[8183fa68] Leaf: Merge the latest changes from trunk. (user: drh, tags: skip-ahead-distinct)
15:35
[a15c49ae] Merge all recent enhancements from trunk. (user: drh, tags: apple-osx)
15:03
[cc28106e] Merge updates from trunk. (user: drh, tags: tempfiles-25)
02:27
[c4f165c4] Add the SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION method for enabling sqlite3_load_extension() while leaving the load_extension() SQL function disabled. (user: drh, tags: trunk)
01:58
[debafa5e] Closed-Leaf: Test cases for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION. (user: drh, tags: load-ext-security)
2016-04-20
19:30
[3340f086] When an error occurs while transitioning out of WAL mode, make sure the locking state is not left at EXCLUSIVE. (user: drh, tags: trunk)
18:31
[38a4e9d9] Fix a locking race condition in Windows 10 that can occur when two or more processes attempt to recover the same hot journal at the same time. (user: drh, tags: trunk)
12:16
[1f709fbf] Merge all recent enhancements from trunk. (user: drh, tags: begin-concurrent)
00:30
[edb454e4] API Change: Modify sqlite3_enable_load_extension() so that it only enables/disables the load_extension() SQL function, and leaves the C-APIs enabled at all times. In this way, applications can enable extension loading for the C interface without having to expose that capability to the SQL. (user: drh, tags: load-ext-security)
2016-04-18
15:46
[eba27d4d] Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (user: drh, tags: trunk)
13:36
[d9768de5] Merge recent trunk changes. (user: drh, tags: tempfiles-25)
13:09
[3a7d7298] The last parameter to pread64() and pwrite64() should be off64_t, not off_t. (user: drh, tags: trunk)
2016-04-15
20:46
[0216b48f] Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. (user: dan, tags: rbu-vacuum)
15:06
[491f0dbd] Merge enhancements from trunk, especially the ".eqp full" enhancement to the command-line shell. (user: drh, tags: skip-ahead-distinct)
15:03
[3e217d62] CLI enhancement: Add the ".eqp full" option, that shows both the EXPLAIN QUERY PLAN and the EXPLAIN output for each command run. Also disable any ".wheretrace" and ".selecttrace" when showing EQP output. (user: drh, tags: trunk)
2016-04-14
19:29
[129083bd] Leaf: Work toward improving analysis and code generation for DISTINCT and aggregate queries. (user: drh, tags: better-distinct-agg)
17:29
[d23e5813] In the ICU extension toupper() and tolower() SQL functions, avoid calling u_strToUpper() or u_strToLower() a second time if the buffer passed to the first invocation turns out to be large enough. (user: dan, tags: trunk)
16:40
[7b7a69d0] Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. (user: drh, tags: trunk)
15:44
[79147dca] Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (user: dan, tags: trunk)
15:38
[67d7f79c] Add some missing testcase() macros to the pushDownWhereTerms() routine. (user: drh, tags: trunk)
13:35
[53179614] Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (user: drh, tags: trunk)
13:16
[7ee570e7] Since the return value of sqlite3OsClose() is always ignored, we might as well make it "void" instead of "int", and thereby save 50 bytes in the compiled binary. (user: drh, tags: trunk)
13:06
[5a469145] Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (user: drh, tags: trunk)
2016-04-13
21:00
[55a62483] Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (user: drh, tags: trunk)
16:02
[e2edd34e] Closed-Leaf: Merge enhancements from trunk. (user: drh, tags: tempfiles-lazy-open)
15:52
[68142dc5] Fixes for harmless compiler warnings. (user: drh, tags: trunk)
15:33
[83cfe82c] Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (user: drh, tags: trunk)
2016-04-12
20:26
[929fa4c3] Closed-Leaf: A couple more compiler warning fixes. (user: mistachkin, tags: warnings)
20:05
[ab69527c] More harmless compiler warning fixes. (user: mistachkin, tags: warnings)
19:30
[bedb88a4] Compilation fix for a C99-ism in the 'fts3view' tool. (user: mistachkin, tags: trunk)
19:20
[a18a6ce2] Fix harmless compiler warnings in the 'session' module. (user: mistachkin, tags: trunk)
17:13
[b65b69f6] Fix speedtest1 so that it automatically unlinks its test database prior to startup. (user: drh, tags: trunk)
16:59
[8053a6e2] Add the --temp option to the speedtest1.c performance test program. (user: drh, tags: trunk)
16:23
[662c32af] Improved localtime() support for WindowsCE (user: drh, tags: trunk)
16:11
[541c6da2] Closed-Leaf: Add and adjust comments. (user: mistachkin, tags: winCeLocalTime)
16:10
[9682c043] Merge enhancements from trunk. (user: drh, tags: tempfiles-lazy-open)
16:04
[7e728965] Add the sqlite3_snapshot_cmp() interface (available only with SQLITE_ENABLE_SNAPSHOT). (user: drh, tags: trunk)
15:14
[8fc83474] Closed-Leaf: Update the documentation for sqlite3_snapshot_cmp() to make the circumstances under which the comparison is valid clearer. Add tests for the same. (user: dan, tags: snapshot-cmp)
11:58
[07f10dea] Update the header comment on the memjournal.c file. No code changes. (user: drh, tags: trunk)
00:26
[e2c4995b] Performance optimization the Vdbe allocator. (user: drh, tags: trunk)
00:16
[aec94b6e] Avoid unnecessary calls to object destructors for a small performance gain. (user: drh, tags: trunk)
00:00
[fdf75239] Performance improvements in sqlite3WhereExprUsage(). (user: drh, tags: trunk)
2016-04-11
22:24
[b8094166] Merge updates from trunk. (user: mistachkin, tags: winCeLocalTime)
22:23
[3189a7f1] Fix typo in the MSVC makefile. (user: mistachkin, tags: trunk)
19:59
[c698a21a] Add the sqlite3_snapshot_cmp() API. (user: dan, tags: snapshot-cmp)
19:01
[9efe2265] Performance optimization to sqlite3Dequote() and its callers. (user: drh, tags: trunk)
18:50
[ffc62af1] Merge latest trunk changes with this branch. (user: dan, tags: tempfiles-lazy-open)
18:25
[2764aeaa] Performance optimization for the sqlite3ExprListDelete() routine. (user: drh, tags: trunk)
18:15
[e35b345c] Performance optimizations in the column cache of the code generator, and especially the sqlite3ExprCacheRemove() routine. (user: drh, tags: trunk)
16:43
[476cc283] Simplification and performance improvements in sqlite3ExprDup() and its subroutines. More work is possible in this area. (user: drh, tags: trunk)
16:35
[e554a4c3] Rename the OP_MX_JUMP macro to SQLITE_MX_JUMP_OPCODE to avoid confusing the opcode name generator. (user: drh, tags: trunk)
14:49
[60ad80e3] Performance improvement in sqlite3ExprDelete(). (user: drh, tags: trunk)
13:36
[099478fa] Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. (user: drh, tags: trunk)
09:39
[982b753d] Update this branch with the latest changes from the trunk. (user: dan, tags: tempfiles-lazy-open)
01:43
[ef1966c2] Back off of the parser optimization in the previous check-in, slightly, to preserve some backwards compatibility regarding some undocumented behavior in the '#AAA' style query parameter. (user: drh, tags: trunk)
01:26
[16df7128] Small size reduction and performance improvement in the parser. (user: drh, tags: trunk)
01:06
[6a5cceee] Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. (user: drh, tags: trunk)
2016-04-09
18:04
[6c56b3a0] Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (user: drh, tags: trunk)
17:04
[ca2ef8a8] Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (user: drh, tags: trunk)
14:36
[3686ed74] Limit the number of digits shown in the "prereq" mask for ".wheretrace" debugging output. (user: drh, tags: trunk)
2016-04-08
21:35
[00ac73a0] Leaf: Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. (user: drh, tags: tabfunc-in-left-join)
19:44
[1dfa5234] Update documentation for sqlite3_snapshot_open(). No code changes. (user: drh, tags: trunk)