SQLite
Timeline
Not logged in

108 timeline items tagged with "trunk" occurring on or after release.

2016-02-12
05:19
[717c1fc4] Leaf: Naming updates for Universal Windows Platform. (user: mistachkin, tags: trunk)
00:13
[b5d77199] Remove an unused parameter from whereSortingCost(). (user: drh, tags: trunk)
2016-02-11
22:41
[0beb32d2] Automatically disable FTS3 and FTS4 when building with SQLITE_OMIT_VIRTUALTABLE. (user: drh, tags: trunk)
21:59
[f183e059] Enhance the MSVC makefile to enable building 'testfixture' fully from source code. (user: mistachkin, tags: trunk)
21:55
[52571991] Remove the unexplained extra 3.0 cost factor for the B-tree sorting that is done to implement DISTINCT in the absence of an index to help. (user: drh, tags: trunk)
21:53
[defc762d] Remove the unused fts5BlobCompare() routine. (user: drh, tags: trunk)
18:18
[61b4c120] Fix another unused variable warning in fts5 code. (user: dan, tags: trunk)
18:08
[facbc424] Avoid a buffer overread when reading a corrupt fts5 structure record. (user: dan, tags: trunk)
17:01
[bc3f7900] Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. (user: dan, tags: trunk)
15:37
[cfe2eb88] Add JSON1 and FTS5 to the set of extensions subject to close compiler warning analysis. Fix some warnings in each. More (harmless) warnings still exist in FTS5. (user: drh, tags: trunk)
2016-02-10
21:45
[e9e6000b] In the MSVC makefile, include the working directory so that it can pickup build generated files (e.g. sqlite3.h, etc). (user: mistachkin, tags: trunk)
19:10
[970881be] Add testcase() macros to the CHECK constraint avoidance logic. Avoid creating an unused VDBE label during CHECK constraint code generation. (user: drh, tags: trunk)
18:24
[7782cb1d] Fix to previous check-in: Make sure CHECK constraints involving the ROWID are not ignored when the ROWID changes. (user: drh, tags: trunk)
16:52
[02fbdbc7] Omit unnecessary CHECK constraints in UPDATE statements, when none of the columns referenced in the CHECK constraint are modified. (user: drh, tags: trunk)
16:03
[6a3aaedf] Omit NOT NULL checks on unchanging columns in an UPDATE. (user: drh, tags: trunk)
13:36
[604f7775] When generating the snapshot-tarball, truncate the date/time in the name to 12 significant digits (YYYYMMDDhhmm) omitting the seconds and fractional seconds. (user: drh, tags: trunk)
13:17
[a3e911e3] Updates to the autoconf tarball README.txt file. (user: drh, tags: trunk)
2016-02-09
22:54
[070ec66f] Update the snapshot tarball name to use the date (ISO8601 format) instead of the SHA1 hash in its name. (user: drh, tags: trunk)
22:39
[4f360b2a] Add the new "snapshot-tarball" target to the unix makefiles, for building a tarball similar to "amalgamation-tarball" but named by the SHA1 hash of the current check-out rather than by the version number. (user: drh, tags: trunk)
22:00
[c7242aa3] Update the MSVC autoconf makefile with the recent changes from the primary one. (user: mistachkin, tags: trunk)
20:37
[1135ad01] Fix the makefiles in the autoconf-tarball so that they build the command-line shell with SQLITE_ENABLE_EXPLAIN_COMMENTS. (user: drh, tags: trunk)
20:31
[61951b15] In the shell, use the appropriate string constant instead of a literal new-line. (user: mistachkin, tags: trunk)
20:11
[751915cb] Enhance the command-line shell to be in auto-explain mode by default. It is no longer necessary to use the ".explain" command to put the shell into a mode where the EXPLAIN output is formatted nicely. That now happens automatically. (user: drh, tags: trunk)
18:28
[51b6823f] Fix MSVC makefile options that enable control-flow guard. (user: mistachkin, tags: trunk)
17:12
[99228239] Fix the top-level makefiles to always include SQLITE_ENABLE_EXPLAIN_COMMENTS when building the shell. Still need to fix main.mk and the amalgamation tarball. (user: drh, tags: trunk)
16:09
[e1d8ec85] Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_format to 4 if is not there already. No need to upgrade to only 2 or 3 since format 4 has now been supported for over 10 years. (user: drh, tags: trunk)
02:12
[ca72be86] Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. (user: drh, tags: trunk)
2016-02-08
20:45
[6eab74c9] Fix spelling error in MSVC makefile comments. (user: mistachkin, tags: trunk)
20:40
[1e563c6e] More work on Windows 10 SDK integration. (user: mistachkin, tags: trunk)
20:14
[85eb05dd] Fix a signed/unsigned comparison warning in fts5. (user: dan, tags: trunk)
20:06
[6926f28c] Fix a compiler warning when compiling without SQLITE_ENABLE_FTS3_TOKENIZER. (user: drh, tags: trunk)
19:40
[e0eb217a] Disable the two-argument form of the fts3_tokenizer() SQL function unless the library is built with -DSQLITE_ENABLE_FTS3_TOKENIZER. (user: dan, tags: trunk)
19:36
[a050e6f0] Changes to help the tokenizer run about 33% faster. (user: drh, tags: trunk)
2016-02-07
20:39
[852a529a] Fix harmless compiler warning in 'srcck1' tool and add it to the clean targets. (user: mistachkin, tags: trunk)
00:08
[ab269e72] Add the sourcetest target to Makefile.msc. (user: drh, tags: trunk)
2016-02-06
22:32
[b0b4624f] Add a utility program that looks for assert(), NEVER(), ALWAYS(), and testcase() macros that have side-effects, and reports errors when they are found. Also fix a bug that this utility detected as it was being tested. (user: drh, tags: trunk)
19:48
[2f7778e6] Make sure variable declarations occur at the beginning of blocks, even with SQLITE_DEBUG enabled. (user: drh, tags: trunk)
14:14
[a2952231] Fix an assert() to have a test instead of a side effect (user: pdr, tags: trunk)
2016-02-05
21:09
[22589018] Add tests for and remove unreachable branches from fts5 in order to restore test coverage. (user: dan, tags: trunk)
19:18
[ca91bd8a] Further streamlining of fts5 prefix query code. (user: dan, tags: trunk)
17:49
[1cac6c45] Make sure the "bak.db" database file does not actually exist before starting the "quota.test" testing. (user: drh, tags: trunk)
16:46
[a6b35273] From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. (user: drh, tags: trunk)
14:11
[b082538d] Improvements to the way out-of-memory conditions are handled, resulting in an almost 1% performance gain in the commmon case where OOM errors do not occur. (user: drh, tags: trunk)
04:55
[fe123ab4] Improve ERRORLEVEL handling in the MSVC batch build tool sub-routine 'fn_UnsetVariable'. (user: mistachkin, tags: trunk)
04:39
[76718bbc] Another small tweak to the MSVC batch build tool. (user: mistachkin, tags: trunk)
2016-02-04
19:50
[42736fb0] Temporarily back out the 0.5% performance improvement from check-in [632071bac5ff32]. Need a more elaborate solution that works with reentrant virtual tables and SQL functions. (user: drh, tags: trunk)
19:45
[c9c6457d] Further improve performance of unindexed fts5 prefix queries. (user: dan, tags: trunk)
17:31
[f465944b] Avoid running some particularly time-consuming tests as part of veryquick.test. (user: dan, tags: trunk)
11:48
[b787165b] Remove unnecessary sets of db->mallocFailed. (user: drh, tags: trunk)
11:15
[634d008c] Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension. (user: drh, tags: trunk)
10:28
[4f1b5229] Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. (user: drh, tags: trunk)
09:48
[e3157cb5] Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. (user: drh, tags: trunk)
2016-02-03
22:14
[632071ba] In the VDBE loop, only check for OOM errors at jumps rather than after every opcode, for about a 0.5% performance increase. (user: drh, tags: trunk)
20:04
[ca11f46d] Improve performance of fts5 prefix queries on detail=col tables. (user: dan, tags: trunk)
19:52
[ef252bc4] Fix markup errors in comments used to generate the documentation - specifically in the documentation on the OP_Seek opcode. (user: drh, tags: trunk)
19:20
[af924018] Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. (user: drh, tags: trunk)
01:55
[ae8b9d2e] Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. (user: drh, tags: trunk)
2016-02-02
21:19
[063755c8] Add tests to restore full coverage of fts5 code. (user: dan, tags: trunk)
17:40
[62ea9e5a] Enhance the performance of fts5 AND and OR queries. (user: dan, tags: trunk)
02:04
[d8b7b199] Enhance the comment on the sqlite3_index_constraint object to bring attention to the fact than iColumn field can be negative for a rowid. (user: drh, tags: trunk)
2016-02-01
21:48
[6d7d4703] Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. (user: drh, tags: trunk)
20:12
[2334e882] Improve performance of fts5 queries. (user: dan, tags: trunk)
17:20
[4c9222f7] Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. (user: drh, tags: trunk)
16:36
[5d7c0928] Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. (user: dan, tags: trunk)
13:58
[a17712bf] Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. (user: dan, tags: trunk)
13:21
[a9b6a067] Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. (user: drh, tags: trunk)
00:21
[22eaced7] Fix an assert() that might fail on a corrupt database. (user: drh, tags: trunk)
2016-01-30
21:09
[a2810cf6] Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. (user: dan, tags: trunk)
19:16
[13fb4aa6] Performance enhancement for fts5 column filter queries on detail=full tables. (user: dan, tags: trunk)
16:59
[9bec50a1] Merge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer requires the rowid register and a separate OP_IdxRowid call. Shorter and faster prepared statements result. (user: drh, tags: trunk)
15:52
[1f4c667f] Only honor the register subtype value if the MEM_Subtype flag is set. Revised and improved fix for ticket [f45ac567eaa9f9]. (user: drh, tags: trunk)
14:17
[96b78020] Output subtype information on register traces for PRAGMA vdbe_trace. (user: drh, tags: trunk)
13:32
[85c46704] Add the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface and use them. Add assert() statement to verify that they are correct. (user: drh, tags: trunk)
12:50
[0bdb41c4] Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. (user: drh, tags: trunk)
02:10
[9de3d712] Make use of covering indexes in the OR optimization. (user: drh, tags: trunk)
2016-01-29
18:11
[512caa1a] Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. (user: drh, tags: trunk)
08:38
[2910ef64] Avoid two more instances of pointer arithmetic on freed pointers. (user: dan, tags: trunk)
2016-01-28
18:22
[5372f800] Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error. (user: dan, tags: trunk)
08:58
[688eb3b4] Remove a duplicate "p->magic = VDBE_MAGIC_RUN;" line from vdbeaux.c. (user: dan, tags: trunk)
02:47
[47633ffd] Fix for pthread detection in the configure scripts. (user: drh, tags: trunk)
00:04
[7c89d75d] Minor correction to the batch tool changes in the previous check-in. (user: mistachkin, tags: trunk)
2016-01-27
23:50
[1edd5f31] Make the MSVC batch build tool sub-routine 'fn_UnsetVariable' a bit more robust. (user: mistachkin, tags: trunk)
07:28
[4bf89891] Support building for Windows 10 desktop using 'MinCore.lib'. (user: mistachkin, tags: trunk)
2016-01-26
20:19
[a3d7b8ac] Performance improvements for fts5, particularly detail=col mode. (user: dan, tags: trunk)
14:48
[4003db4a] Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. (user: dan, tags: trunk)
2016-01-25
23:24
[abd2b357] Add the ability to do Windows builds to the amalgamation tarball. (user: drh, tags: trunk)
22:08
[7c49a947] Fix a compiler warning about doing pointer arithmetic involving a NULL pointer even though the result of computation is never used. (user: drh, tags: trunk)
15:57
[7ac017a4] Replace the OP_SetIfNotPos operator with OP_OffsetLimit in the VDBE, for simpler and smaller code. (user: drh, tags: trunk)
13:55
[30671345] Add the SQLITE_EXTRA_DURABLE compile-time option. (user: drh, tags: trunk)
02:15
[8a1deae4] Small simplification to the prepare statement opcode memory reuse logic. Easier to read, and slightly smaller and faster. (user: drh, tags: trunk)
01:07
[0a9cff5c] Small simplification and performance improvement in memsys5Free(). (user: drh, tags: trunk)
2016-01-23
22:55
[dd0100dd] Add the SQLITE_SPELLFIX_STACKALLOC_SZ compile-time option to control how much stack space is available for use as the Wagner matrix in editDest3 of the spellfix extension. (user: drh, tags: trunk)
18:24
[dfcebc73] Changes to spellfix to try to get it to use stack space instead of heap space in cases where that makes sense. (user: drh, tags: trunk)
15:57
[3be336aa] Fix some signed/unsigned comparison compiler warnings in fts5. (user: dan, tags: trunk)
14:05
[f0a551ed] Remove an assert() that can be false if compiled with SQLITE_USE_ALLOCA. (user: drh, tags: trunk)
00:07
[a79c46bc] More work on the MSVC build. (user: mistachkin, tags: trunk)
2016-01-22
23:17
[a1c8116c] In the TCL interface, if a database connection object was opened with the -uri 1 option, then also honor URI filenames for the "backup" and "restore" commands. (user: drh, tags: trunk)
22:16
[df22556f] More MSVC makefile cleanup. (user: mistachkin, tags: trunk)
19:44
[c11c85fd] Reenable the xCurrentTime and xGetLastError methods on the unix VFSes as long as SQLITE_OMIT_DEPRECATED is not defined. (user: drh, tags: trunk)
17:48
[73231753] Add the sqlite3TokenInit() utility function. (user: drh, tags: trunk)
15:44
[e60461e9] Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases. (user: dan, tags: trunk)
04:22
[e4c07df5] Enable FTS4 when building the shell with the MSVC makefile. (user: mistachkin, tags: trunk)
03:54
[67625b96] Further refinements to the MSVC makefile. (user: mistachkin, tags: trunk)
01:25
[ac2e9d3d] MSVC makefile enhancements for use with the Windows 10 SDK. (user: mistachkin, tags: trunk)
2016-01-21
18:56
[29a51c6d] Fix typo in 'Makefile.in'. (user: mistachkin, tags: trunk)
15:55
[a3cec529] Improved comments on the FORDELETE hint. No logic changes. (user: drh, tags: trunk)
2016-01-20
18:47
[f60f0250] Add 'rbu' to the clean targets. (user: mistachkin, tags: trunk)
16:36
[81e830e2] Add a -detail option to the loadfts5.tcl script. For creating tables with the detail= option set. (user: dan, tags: trunk)