SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2016-08-24
18:49
[428fc38d] Merge updates from trunk. (user: mistachkin, tags: callbackConv)
18:21
[77f7c31a] Leaf: Sync up the MSVC autoconf makefile. (user: mistachkin, tags: trunk)
2016-08-23
14:42
[c640489d] Fix the SQLITE_USER_AUTHENTICATION login check so that the SQLITE_AUTH_USER error code correctly propagates and is not overwritten by SQLITE_ERROR. (user: drh, tags: trunk)
2016-08-22
20:49
[0c9fd6b7] Add an experimental module to detect conflicts between sessions changesets. (user: dan, tags: changebatch)
20:10
[78395193] Add support for the SQLITE_DBCONFIG_MAINDBNAME configuration option. (user: drh, tags: trunk)
2016-08-19
15:41
[b1787236] Merge recent enhancements from trunk. (user: drh, tags: rowvalue)
15:17
[12d5e38d] Closed-Leaf: Merge the VACUUM attached database enhancement from trunk. (user: drh, tags: dbconfig_maindbname)
15:15
[083f9e62] Enhance the VACUUM command so that it can operate on an attached database. (user: drh, tags: trunk)
15:12
[ad35ef11] Closed-Leaf: Disable row counting on queries run while doing a VACUUM. (user: drh, tags: vacuum-attached-db)
14:20
[29d63059] Add the capability to VACUUM an attached database by specifying the schema name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. (user: drh, tags: vacuum-attached-db)
2016-08-18
22:44
[d6e3d579] Add the SQLITE_DBCONFIG_MAINDBNAME interface. (user: drh, tags: dbconfig_maindbname)
22:19
[cb9865e1] Change the name of Db.zName to Db.zDbSName for improved long-term code maintainability. (user: drh, tags: trunk)
20:56
[d7cf423c] Closed-Leaf: Fix a zName to zDbSName conversion missed in the previous check-in. (user: drh, tags: zDbSName)
14:33
[92a22f01] Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. (user: drh, tags: zDbSName)
2016-08-17
19:05
[60de1594] Bias the fts5 snippet() function to return snippets that look like they start at the start of sentences. (user: dan, tags: fts5-snippet-bias)
11:14
[a861713c] Fix a problem in the fts5 snippet() auxiliary function. (user: dan, tags: trunk)
2016-08-16
16:46
[f9035b8e] Fix a bug in destructor processing of Lemon. That has no impact on the SQLite grammar. The bug was introduced by prior work to optimize the Lemon-generated parser used by SQLite. (user: drh, tags: trunk)
2016-08-13
10:34
[e22252e1] Fix an fts5 problem with corrupt database handling found by address-sanitizer. (user: dan, tags: trunk)
06:38
[fcfbee6c] Fix a buffer overread in fts5. (user: dan, tags: trunk)
2016-08-12
16:21
[8a5f41c7] Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. (user: dan, tags: interruptible-checkpoint)
2016-08-11
19:12
[d9f8918c] Leaf: Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. (user: drh, tags: begin-concurrent)
18:05
[ed406d31] Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). (user: dan, tags: trunk)
13:03
[03dceaea] Enhance sqlite3PcacheTruncate() to run faster in the common case where the cutoff is just a few pages less than the page number highwater mark. (user: drh, tags: branch-3.14)
12:31
[959677b9] Merge recent changes from trunk. (user: drh, tags: rowvalue)
09:55
[ab83d707] Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (user: dan, tags: trunk)
01:24
[2ea0c8b4] Fix a harmless compiler warning in FTS5. (user: drh, tags: trunk)
2016-08-10
20:02
[95493058] Optimization to sqlite3WhereExprUsage(). (user: drh, tags: trunk)
19:43
[7319d676] List of MATCH operator names in isMatchOfColumn() should be constant. (user: drh, tags: trunk)
18:56
[ebccbd96] Performance enhancement in the expression walker. (user: drh, tags: trunk)
15:02
[059f4e2e] Tweaks to pcache1TruncateUnsafe() to make it slightly smaller and faster and easier to test. (user: drh, tags: trunk)
14:40
[25d1d02b] Rearrange the code inside sqlite3RunParser() routine so that sqlite3Parser() is only called from a single place. This allows sqlite3Parser() to be in-lined, which results in a 0.25% overall performance gain. (user: drh, tags: trunk)
13:34
[8c2701e7] Increment the version number to 3.15. (user: drh, tags: trunk)
13:30
[83622f3f] Improved comments on the lempar.c parser template. Adjust the YY_SHIFT_USE_DFLT constant in the Lemon-generated parser tables so as to guarantee that it is always out of range of the yy_lookahead[] table. (user: drh, tags: trunk)
11:50
[b07a26df] Fix pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. (user: drh, tags: trunk)
01:43
[ba6663be] Performance optimization in the yy_find_shift_action() routine of the Lemon-generated parser. (user: drh, tags: trunk)
2016-08-09
21:08
[f0942c36] Leaf: Prototype for the remember(V,PTR) extension function. (user: drh, tags: rememberFunc)
21:01
[9a5a4f6e] Fix harmless compiler warning. (user: drh, tags: trunk)
19:48
[14864f2b] Minor update to the way fts5 column filters are parsed. (user: dan, tags: trunk)
19:26
[e5175456] Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. (user: dan, tags: trunk)
2016-08-08
16:52
[0e927a7e] Merge trunk changes with this branch. (user: dan, tags: rowvalue)
14:21
[c3cd543f] Leaf: Merge all changes from the 3.14 release. (user: drh, tags: apple-osx)
13:40
[d5e98057] Version 3.14 (user: drh, tags: trunk, release, version-3.14.0)
2016-08-07
18:52
[ebc396a1] Fix documentation typos. No changes to code. (user: drh, tags: trunk)
2016-08-05
20:54
[95578898] Have the TEA package build without SQLITE_OMIT_DEPRECATED. As it uses recently deprecated interfaces sqlite3_profile() and sqlite3_trace(). (user: dan, tags: trunk)
16:16
[ae72513a] Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. (user: dan, tags: trunk)
15:34
[0f57effa] Remove an incorrect ALWAYS() statement and add a test case to show when the condition is sometimes false. (user: drh, tags: trunk)
14:35
[68eac748] Fix a very obscure problem following OOM in sqlite3_declare_vtab(). (user: drh, tags: trunk)
2016-08-04
13:39
[dacfff51] Merge all recent enhancements from trunk. (user: drh, tags: apple-osx)
13:23
[9adda385] Revert the SQLITE_APICALL changes for now. That changes needs further research before it is released. Deferred until 3.15. (user: drh, tags: trunk)
12:35
[b7f30a9f] Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. (user: drh, tags: trunk)
09:13
[bf5a9542] Merge the ORDER BY LIMIT fix, and other enhancements, from trunk. (user: drh, tags: apple-osx)
09:09
[13e3bd3d] Make sure the ORDER BY LIMIT optimization is not applied if the inner-most loop can only have a single iteration and is hence not really a loop. (user: drh, tags: trunk)
2016-08-03
14:51
[722c1281] Fix a typo in a comment in btree.c. No changes to code. (user: drh, tags: trunk)
13:40
[b91444b5] Fix the --help output on fuzzcheck so that it fix in an 80-character window. (user: drh, tags: trunk)
2016-08-02
20:42
[e2f9919e] Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. (user: drh, tags: trunk)
19:29
[50de9631] The 'replace.tcl' tool should use Unix line-endings. (user: mistachkin, tags: trunk)
16:24
[d468101b] Merge latest trunk changes into this branch. (user: dan, tags: rowvalue)
13:26
[b23c10ac] Updates to requirements marks. No changes to code. (user: drh, tags: trunk)
11:29
[e64a4173] Fix a problem introduced by [77948b5eceab92a7] causing duplicate calls to be made to the xSavepoint() method of virtual tables under some circumstances. (user: dan, tags: trunk)
08:45
[7c38a79c] Fix harmless compiler warnings in sqlite3_status(). (user: drh, tags: trunk)
2016-08-01
21:17
[d8ef9f58] Update the wordcount.c test program and add a new script "time-wordcount.sh" for additional performance testing. (user: drh, tags: trunk)
17:06
[90d2c490] Fix other harmless compiler warnings. (user: drh, tags: trunk)
16:57
[fd184e5a] Remove a duplicate typedef from loadext.c (remaining copy is in sqlite3ext.h). (user: dan, tags: trunk)
16:50
[e57fa6af] Add an extra compiler switch to loadext.test to ensure that it picks up the correct version of sqlite3.h when building a test extension. (user: dan, tags: trunk)
15:00
[a6a112de] Update releasetest.tcl to automatically do one round of tests with USE_STDCALL=1 when running on Windows with MSVC. (user: drh, tags: trunk)
14:35
[b6ea2f21] Avoid making unnecessary changes to the signatures of the sqlite3_auto_extension() and sqlite3_cancel_auto_extension() interfaces. (user: drh, tags: trunk)
2016-07-30
18:54
[390a38a1] Fix harmless compiler warning seen with MSVC. (user: mistachkin, tags: trunk)
17:59
[63ae02d0] Merge latest trunk with this branch. (user: dan, tags: rowvalue)
2016-07-29
17:36
[9fae75c0] Using the header file 'intrin.h' requires MSVC 2005 or later. (user: mistachkin, tags: trunk)
04:12
[544c990a] For test 'shell1-5.0', disable round-trip testing for characters in the range 0xE0 to 0xEF on Linux, due to intermittent shell portability issues. (user: mistachkin, tags: trunk)
02:04
[4fedd790] Fix typo in a test file interactive output string. (user: mistachkin, tags: trunk)
01:55
[8b0eb22e] Merge additional linkage macro changes from the branch. (user: drh, tags: trunk)
01:49
[45588de3] Further refinement to the calling convention macros. (user: drh, tags: trunk)
01:47
[71ffa195] Merge updates from trunk. (user: mistachkin, tags: callbackConv)
01:32
[c7d51934] Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. (user: drh, tags: trunk)
01:31
[bc8c9b55] Add macro necessary for building several extensions when the __stdcall calling convention is not in use. (user: mistachkin, tags: callbackConv)
2016-07-28
22:23
[3ea567c4] Make the extension auto-loading mechanism work with the __stdcall calling convention. Also, fix a couple Tcl command calling conventions missed in the previous check-in. (user: mistachkin, tags: callbackConv)
19:28
[cbe1de47] The 'sqlite3ext.h' content should be processed before being included in the amalgamation. (user: mistachkin, tags: trunk)
18:55
[fd784887] Decorate all interfaces with calling convention macros. (user: drh, tags: trunk)
18:49
[97fc6e43] Closed-Leaf: All SQLite API functions and callbacks in the 'sqlite3ext.h' header file must be decorated with the calling convention. (user: mistachkin, tags: callbackConv)
18:42
[97657445] Merge recent trunk fixes. (user: drh, tags: apple-osx)
18:38
[805d01cd] Disable the authorizer callback when reparsing the schema. This avoids undesirable authorization failures following an ALTER TABLE. (user: drh, tags: trunk)
17:24
[81f9cf86] Improvements to the way the COMPILER compile-time option is set when compiling with Clang. (user: drh, tags: trunk)
13:59
[9685880f] Merge latest trunk changes into this branch. (user: dan, tags: rowvalue)
12:52
[6feff15c] New test case to insure legacy CREATE TABLE syntax is supported. (user: drh, tags: trunk)
04:14
[02b8040e] Work in progress on setting a calling convention for all callback functions. (user: mistachkin, tags: callbackConv)
2016-07-27
19:33
[719a3b20] Fix some problems with multi-column IN(SELECT...) processing. (user: dan, tags: rowvalue)
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
18:15
[d4f3d52c] Merge latest trunk changes into this branch. (user: dan, tags: rowvalue)
15:17
[91e811f5] 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)
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)
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)
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)
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)
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)
2016-07-21
18:02
[bf98a2de] Add extra test cases to verify the fix in [64ca1a835]. (user: dan, tags: trunk)
16:43
[1b1ad0b2] Add new test file vacuummem.test. To test that any temporary memory used by VACUUM is freed as soon as the VACUUM has finished (not, for example, when sqlite3_close() is finally called). (user: dan, tags: trunk)
2016-07-15
19:17
[d0a1cf1c] Add the largely untested SQLITE_FTS5_NO_WITHOUT_ROWID compile time option to fts5. For building a dynamically loadable extension that does not use WITHOUT ROWID. (user: dan, tags: trunk)
02:55
[d2b1fa55] Merge fixes from trunk. Fix the tclsqlite.test script. (user: drh, tags: sqlite3_trace_v2)
02:50
[ec718089] Disable the CSV extension when virtual tables are disabled. (user: drh, tags: trunk)
2016-07-14
20:19
[46bd9533] Leaf: Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. (user: drh, tags: btree-balance-bias)
19:48
[d2a0af7a] Closed-Leaf: Minor tweak the the b-tree balancer. (user: drh, tags: btree-tuning)
19:13
[a7db6e45] Fix ALTER TABLE so that it does not promote the schema version past 3, as that will cause DESC indexes to go corrupt. Ticket [f68bf68513a1c]. (user: drh, tags: trunk)
2016-07-13
21:30
[0c569f75] Interface design for a new sqlite3_trace_v2() method that supersedes sqlite3_trace() and sqlite3_profile(). (user: drh, tags: sqlite3_trace_v2)
13:05
[824b39e5] Fix harmless compiler warnings in shell.c for NetBSD. (user: drh, tags: trunk)
00:55
[021d0fb8] Fix header comments and remove an unnecessary version restriction from the carray() table-valued function implementation. (user: drh, tags: trunk)
2016-07-12
19:54
[3ef93950] Fix the error counter reset in Lemon generated parsers. This has no effect on SQLite. (user: drh, tags: trunk)
2016-07-10
19:35
[728c5aa4] Merge comment typo fixes from trunk. (user: mistachkin, tags: rowvalue)
19:35
[77c692a6] Fix typos in comments. No changes to code. (user: mistachkin, tags: trunk)
2016-07-09
20:23
[b2204215] Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. (user: dan, tags: rowvalue)
17:47
[c869bf34] Add the "#/value-list/" style of results for approximate value matching in the do_test command of the test infrastructure. Use this new result style to make the SQLITE_DBSTATUS_CACHE_SIZE_SHARED tests cross-platform. (user: drh, tags: trunk)
17:15
[29fb988f] Fix a compiler warning in test code - in the int64array_addr TCL command. (user: drh, tags: trunk)
16:38
[8b22f777] Fix compiler warnings on windows. (user: drh, tags: trunk)
16:14
[5471aca0] Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". (user: drh, tags: trunk)
00:06
[b5f32a89] Add support for the win32-none VFS. (user: drh, tags: trunk)
2016-07-08
21:14
[549abe3f] Closed-Leaf: Initial work on a Win32 VFS with NOP locking. (user: mistachkin, tags: win32nolock)
19:54
[e1d8ef31] Another attempt to fix error handling in Lemon. This change is a no-op for SQLite's usage. (user: drh, tags: trunk)
02:14
[8bb8d886] In the sqldiff program, make sure the first argument to the db_prepare() utility function is always a valid format string. (user: drh, tags: trunk)
2016-07-06
18:42
[06cf2680] Add the SQLITE_DBSTATUS_CACHE_USED_SHARED sqlite3_db_status() parameter. This option is similar to DBSTATUS_CACHE_USED, except that it divides memory used by shared caches evenly between all connections. (user: dan, tags: trunk)
18:12
[d58401ab] Closed-Leaf: Change the name of the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED to SQLITE_DBSTATUS_CACHE_USED_SHARED. (user: dan, tags: dbstatus-prop-cache-used)
10:17
[0c228f5d] Fix a test script problem causing a test to fail if the ICU extension is enabled. (user: dan, tags: trunk)
10:12
[118321c8] Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. (user: dan, tags: dbstatus-prop-cache-used)
09:19
[724e4cdc] Fix a memory leak in recently added test code. (user: dan, tags: trunk)
2016-07-05
16:11
[2683b375] More fixes to Lemon so that it automatically resets its error counter at the end of a parse. (user: drh, tags: trunk)
12:47
[91889fa3] Attempt to reset the error count in the Lemon-generated parser after a parse failure. (user: drh, tags: trunk)
2016-07-04
11:47
[0357875f] Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. (user: dan, tags: trunk)
11:34
[d8bc6feb] Add the carray() virtual table as a loadable extension. (user: drh, tags: trunk)
2016-07-03
02:35
[a204ba99] Closed-Leaf: Change the name of the intarray() extension to carray() and give it an optional third parameter that specifies the datatype as one of 'int32', 'int64', 'double', or 'char*'. 'int32' is the default. (user: drh, tags: prototype-int-array)
2016-07-02
20:51
[507fdbfb] Merge the alternative table-valued function RHS of IN operator implementation from trunk. (user: drh, tags: prototype-int-array)
12:33
[bead151e] Fix a problem in table-valued functions on the RHS of an IN operator that occurs following an OOM error. (user: drh, tags: trunk)
12:08
[ac6000f0] Add support for table-valued functions on the RHS of an IN operator. (user: drh, tags: trunk)
2016-07-01
20:12
[228a7879] Fix the transitive constraint logic error that can result in a null pointer dereference. Fix for ticket [e8d439c77685eca6]. (user: drh, tags: trunk)
19:48
[c952af89] Closed-Leaf: Add test cases to the transitive constraint fix. (user: drh, tags: planner-fix)
12:39
[92e7df0f] Closed-Leaf: Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. (user: dan, tags: rbu-state-api)
2016-06-29
05:00
[233b3338] Add a prototype intarray($PTR,$N) table valued function. (user: drh, tags: prototype-int-array)
2016-06-28
22:27
[a33d2356] Proposed fix for a problem in the query planner. (user: drh, tags: planner-fix)
2016-06-26
04:06
[f8105085] Prevent the WhereLoop.rSetup cost estimate from going negative on complex queries. (user: drh, tags: trunk)
2016-06-25
11:43
[507014e4] Fix the handling of OP_Eq opcodes that compare a register against itself and that require an affinity change. (user: drh, tags: trunk)
2016-06-24
06:23
[77e4f7a3] Fix the ctime.test script so that it works with clang. (user: drh, tags: trunk)
02:50
[67c39e16] Fix the Makefile.in to avoid unnecessary recompiles of sqlite3.c. (user: drh, tags: trunk)
02:21
[a2778ae4] Leaf: Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. (user: drh, tags: temp-page-size)
2016-06-23
16:48
[b8671e94] Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (user: dan, tags: trunk)
12:35
[91113142] Fix the build for -DSQLITE_OMIT_VIRTUALTABLE (user: drh, tags: trunk)
2016-06-21
10:34
[5d0a9d4c] Closed-Leaf: Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (user: dan, tags: sqldiff-vtab-support)
2016-06-20
17:25
[913e5956] For a table on the rhs of a LEFT JOIN operator, do not include terms like "IS NULL" from the WHERE clause in the cursor-hint. These may be false for rows that the cursor would otherwise visit, but true for a row of all NULL values generated by the LEFT JOIN. (user: dan, tags: trunk)
17:22
[7455d932] Closed-Leaf: Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. (user: dan, tags: cursor-hints)
2016-06-17
14:33
[2a2346b0] If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. (user: dan, tags: cursor-hints)
13:01
[2c3714ae] Closed-Leaf: Add the json_quote() function to the JSON1 extension. (user: drh, tags: json_quote)
2016-06-16
17:14
[0b1579ca] Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (user: dan, tags: trunk)
11:16
[48b555c4] Fix a typo in a comment on the SrcList object. (user: drh, tags: trunk)
2016-06-15
10:21
[0f707d15] Merge changes from trunk. (user: drh, tags: apple-osx)
2016-06-13
19:58
[0230ca17] Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". (user: drh, tags: trunk)
15:59
[a1e1cdc5] Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. (user: drh, tags: trunk)
12:51
[fcf6114b] Fix an incorrect assert() in the btree logic. (user: drh, tags: trunk)
12:34
[d362ba15] Fix the "onecolumn" and "exists" methods of the TCL interface so that they work in combination with the "profile" callback. (user: drh, tags: trunk)
2016-06-10
22:49
[53a1e5d5] Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (user: drh, tags: trunk)
2016-06-08
18:07
[fe187432] Prefer to use partial indexes for full table scans when that is possible. (user: drh, tags: trunk)
14:04
[f48a4ad3] Add the "dbhash.exe" utility program that computes a SHA1 hash over the invariant content of an SQLite database file. Free space in the file, the page size, auto_vacuum status, text encoding, and so forth do not change the hash. Only the content matters. (user: drh, tags: trunk)
13:59
[fb276815] Closed-Leaf: Fix an undersized buffer in the SHA1 implementation. (user: drh, tags: dbhash)
01:03
[2247649c] An initial attempt at a "dbhash" command-line utility. (user: drh, tags: dbhash)
2016-06-07
20:25
[2091a4c9] Fix the walcrash4.test test module so that it works on windows. (user: drh, tags: trunk)
2016-06-06
20:36
[e404ad70] In winFullPathname, translate '/X:' to 'X:' before doing anything else. (user: mistachkin, tags: trunk)
20:27
[f8470ffc] Translate filenames of the form "/c:/*" into just "c:/*" on WinRT and Cygwin. (SQLite has long done this for Win32/WinNT.) (user: drh, tags: trunk)
18:17
[3665a2f5] Fix lempar.c so that the shift-reduce optimization works for error processing. This is a Lemon issue only and has no impact on SQLite. (user: drh, tags: trunk)
13:24
[45531654] Initialize the yyerrcnt variable in the lemon parser template. This has no effect on SQLite itself. (user: drh, tags: trunk)
01:54
[e106a77d] Small performance boost and size decrease in sqlite3BtreeMovetoUnpacked(). (user: drh, tags: trunk)
01:48
[5fb0c354] Small performance improvement in the LIKE function. (user: drh, tags: trunk)
01:14
[2d831074] Btree interface refactoring: (1) The sqlite3BtreeKeySize() interface is renamed to sqlite3BtreeIntegerKey() and modified to work only for table btrees with a rowid. (2) The sqlite3BtreeDataSize() interface is renamed to sqlite3BtreePayloadSize() and modified to work with any btree. (3) The sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() routines are combined into a single sqlite3BtreePayloadFetch() routine. The result of these changes is a smaller binary and fewer CPU cycles needed to run queries. (user: drh, tags: trunk)
2016-06-04
21:05
[5e269c2d] Closed-Leaf: Improved comment on cursorOwnsBtShared(). No changes to code. (user: drh, tags: btree-refactor)
20:37
[bef35e18] Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. (user: drh, tags: btree-refactor)
17:12
[b411107a] Allocate KeyInfo objects from lookaside if possible. (user: drh, tags: trunk)
16:33
[9583c0fb] Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). (user: drh, tags: trunk)