SQLite
Timeline
Not logged in

All nodes on the path from [release] to [trunk]

2015-03-02
17:25
[17890292] Leaf: Ensure that automatic indexes are *not* considered when doing the the subqueries of the OR-optimization. (user: drh, tags: trunk)
2015-02-28
14:03
[6bf62463] In the command-line shell, the inability to read ~/.sqliterc is no longer a fatal error. A warning is issued, but processing continues. (user: drh, tags: trunk)
01:04
[fc51037c] More test cases and requirements marks for pragmas. (user: drh, tags: trunk)
2015-02-27
21:53
[766ad650] Remove all references to SQLITE_DEFAULT_TEMP_CACHE_SIZE. Add requirements marks related to cache_size changing. (user: drh, tags: trunk)
20:28
[8c2b29d9] New requirements marks and a few new test cases to go with them. No changes to code. (user: drh, tags: trunk)
00:33
[d70b0fd4] Add a couple of requirements marks. (user: drh, tags: trunk)
2015-02-26
21:04
[3bc34fd4] Fix potential memory leaks in the misc 'compress' extension. (user: mistachkin, tags: trunk)
16:40
[3038d016] Update a requirements mark to reflect a change of wording in the documentation. No changes to code. (user: drh, tags: trunk)
16:32
[a62ba58c] Fix a real bug (in test code) that was introduced while trying to eliminate harmless compiler warnings from OpenBSD (see check-in 10321910990195878c). (user: drh, tags: trunk)
02:33
[4bee8295] Simplifications to the description of the nByte parameter to sqlite3_prepare() and friends. (user: drh, tags: trunk)
2015-02-25
14:25
[6d132e7a] Make sure the sqlite3_mutex.id field is initialized in the Win32 mutex implementation, even when SQLITE_DEBUG is turned off. (user: drh, tags: trunk)
13:48
[03bbb947] Add support for the linenoise command-line editing library in shell.c. (user: drh, tags: trunk)
13:29
[9d6c1880] Leaf: Version 3.8.8.3 (user: drh, tags: release, version-3.8.8.3, branch-3.8.8)
12:52
[ec27ab0e] Add support for linenoise to shell.c. (user: dan, tags: branch-3.8.8)
01:06
[034c16bd] When cleaning with MSVC, prevent superfluous output regarding 'missing' files and directories. (user: mistachkin, tags: trunk)
00:24
[3af300bf] Remove an always-false conditional from constructAutomaticIndex(). Put an assert() in its place to prove that the conditional is always false. (user: drh, tags: trunk)
2015-02-24
20:12
[9d94ac6a] Make sure partial indexes are not qualified incorrectly by a constraint that is inside the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead33]. Cherry-pick from 491cfe9b3f87f. (user: drh, tags: branch-3.8.8)
20:10
[1d6fb43a] Prevent partial indexes on the table on the left hand side of a LEFT JOIN from being incorrectly qualified by a constraint in the ON clause of the join. This relaxes the rule introduced by the previous commit (as the partial indexes on the table on the rhs of the LEFT JOIN may now be qualified by terms within the ON clause). (user: dan, tags: trunk)
20:04
[491cfe9b] Make sure partial indexes are not qualified incorrectly by a constraint that is inside the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead33]. (user: drh, tags: trunk)
16:22
[a92afe7d] Increase the version number to 3.8.8.3 (user: drh, tags: branch-3.8.8)
2015-02-21
15:42
[f8917ba4] Update document on sqlite3_mprintf() and related functions. Discuss the %w format and point out that obscure ANSI-C formats are not supported. No changes to code. (user: drh, tags: trunk)
00:56
[c299e55a] Fix a compiler warning associated with USE_PREAD64. (user: drh, tags: trunk)
00:49
[7560a9fa] Fix over-length source code lines in os_unix.c. (user: drh, tags: trunk)
00:19
[28c2b726] Keep track of the optimal number of reserved bytes (by looking at reserve byte requests in calls to sqlite3BtreeSetPageSize()) and then change the reserve byte count to the optimal when doing a VACUUM or when using the backup API. (user: drh, tags: trunk)
2015-02-19
17:16
[905009f6] Fix errors in the EBCDIC upper-case to lower-case translation table. (user: drh, tags: trunk)
16:12
[8215727d] Remove a redundant call to statfs() in the xOpen() method of the unix VFS. Also fix an unused local variable warning. (user: drh, tags: trunk)
02:43
[81f242e3] Move the os_unix.c file closer to apple-osx. (user: drh, tags: trunk)
00:29
[28284ccc] First small steps toward brining trunk and apple-osx closer together. (user: drh, tags: trunk)
2015-02-13
16:36
[823ad40c] Improvements to SQLITE_ENABLE_API_ARMOR. (user: drh, tags: trunk)
12:05
[3c6ca414] Make sure the prepared statement auto-resets on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET. (user: drh, tags: trunk)
2015-02-12
22:45
[9c5bcad1] For the shell '.import' command, make sure the last column value present is considered before NULL filling any missing ones. (user: mistachkin, tags: trunk)
17:15
[b2082462] Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. Cherrypick of 245e8730451f. (user: dan, tags: branch-3.8.8)
2015-02-09
18:28
[24e78b8d] Propagate COLLATE operators upward through function calls and CASE operations. And do not flatten an aggregate subquery into a query that uses other subqueries. Fixes for tickets [ca0d20b6cdddec5] and [2f7170d73bf9], respectively. (user: drh, tags: trunk)
17:46
[937e0fe7] Fix WITHOUT ROWID table handing in sqlite3_analyzer. (user: dan, tags: trunk)
14:07
[4ef7cece] Rename the internal "EP_Constant" bitmask to a less misleading "EP_ConstFunc". (user: drh, tags: trunk)
13:42
[aa093fef] In selecttrace 0x100 mode, show the parse tree after name resolution instead of before flattening, so that it is always seen even if flattening does not occur. Also: add the hex pointer value to the top of each SELECT tree. (user: drh, tags: trunk)
11:54
[b3c6b8a3] In selecttrace mode 0x100, show a complete parse-tree both before and after query flattening. This is a change to debugging code only. (user: drh, tags: trunk)
10:20
[c12edb85] Fix over-length source code lines in resolver.c. No logic changes. (user: drh, tags: trunk)
2015-02-07
15:16
[5df02f50] Fix potential 32-bit integer overflow problems on the offset and length parameters to sqlite3_blob_read() and sqlite3_blob_write(). For sqlite3_blob_open(), make sure the *ppBlob return parameter is zeroed if the interface fails with SQLITE_MISUSE. (user: drh, tags: trunk)
2015-02-06
14:51
[0f65a7e2] Change the name of ".info" to ".dbinfo" and add an optional second argument which is the ATTACH-ed DB about which information is provided. Provide ".indexes" as an alternative name to the legacy ".indices" command. (user: drh, tags: trunk)
14:19
[0a3100a7] Add the ".info" command to the shell. (user: drh, tags: trunk)
01:07
[2743846c] Add the index_xinfo pragma which gives information about the fields that reference the table PRIMARY KEY in addition to the index key fields. Add extra columns "desc", "coll", and "key" to the index_info and index_xinfo pragmas. Add the "origin" and "partial" columns to the index_list pragma. (user: drh, tags: trunk)
2015-02-04
20:56
[71691c4b] Fix a missing mutex in SQLITE_TESTCTRL_IMPOSTER. (user: drh, tags: trunk)
2015-02-03
19:20
[f30a057a] Fix a typo in the --help output for speedtest1. Fix a dependency error in the Makefile.in for speedtest1. (user: drh, tags: trunk)
2015-02-02
21:34
[32c0325b] Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. (user: drh, tags: trunk)
2015-01-30
20:59
[42d56017] Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased. (user: drh, tags: trunk)
15:52
[98e02913] Added SQLITE_TESTCTRL_INITMODE for improved testability. (user: drh, tags: trunk)
14:30
[7757fc72] Version 3.8.8.2 (user: drh, tags: release, version-3.8.8.2, branch-3.8.8)
2015-01-29
20:01
[65bfbbb4] Bump the version number to 3.8.8.2 (user: drh, tags: branch-3.8.8)
19:59
[18610617] Ensure that "PRAGMA wal_checkpoint = TRUNCATE|FULL|RESTART" block on other connections and truncate the wal file as required even if the entire wal file has already been checkpointed. Cherry-pick from trunk. (user: drh, tags: branch-3.8.8)
19:27
[1797158d] Fix some duplicated test names. (user: mistachkin, tags: trunk)
19:12
[53429689] Ensure that "PRAGMA wal_checkpoint = TRUNCATE|FULL|RESTART" block on other connections and truncate the wal file as required even if the entire wal file has already been checkpointed. (user: dan, tags: trunk)
18:38
[7d70ac65] Split up the SRC variable in Makefile.msc to avoid over-long cmd.exe commands when TOP is set to a long pathname. (user: drh, tags: trunk)
11:52
[85dc1262] Optimize range constraints on the rowid column of fts3/4 tables even if there is no MATCH clause in the query. (user: dan, tags: trunk)
2015-01-27
21:24
[e7d2ec04] Fix harmless compiler warnings. (user: mistachkin, tags: trunk)
19:01
[adc9283d] Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column. (user: dan, tags: trunk)
18:43
[245e8730] Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. (user: dan, tags: trunk)
13:17
[e098de69] Fix a (almost always harmless) read past the end of a memory allocation that comes about because the Expr.pTab field is checked on an EXPR_REDUCEDSIZE Expr object before checking the Expr.op field to know that the Expr.pTab field is meaningless. (user: drh, tags: trunk)
2015-01-25
20:19
[1964e656] The va_list argument cannot take on a NULL value and cannot be compared with NULL on some platforms (ex: ARM). So do not attempt to do so. (user: drh, tags: trunk)
2015-01-24
12:12
[2a9ea9b4] In the command-line shell, make sure stderr is unbuffered so that it automatically flushes. This has always been the case already for unix and on Windows when the output is a console, but apparently was not the case on Windows when the output was a pipe. (user: drh, tags: trunk)
2015-01-22
12:00
[9e6eae66] Make sure errors in the FROM clause of a SELECT cause analysis to abort and unwind the stack before those errors have a chance to mischief in the "*" column-name wildcard expander. Fix for ticket [32b63d542433ca67]. (user: drh, tags: trunk)
11:29
[bd63bf88] Change the undocumented ".selecttrace" command in the shell to accept an integer bitmask rather than a boolean. (user: drh, tags: trunk)
2015-01-21
17:00
[5f592359] Fix an assert() that may fail following an OOM error. (user: dan, tags: trunk)
00:51
[78c2e62b] Fix harmless compiler warning seen with MSVC. (user: mistachkin, tags: trunk)
00:48
[26190b3c] Enhancements to entropy generation for the Win32 VFS. (user: mistachkin, tags: trunk)
2015-01-20
16:51
[f73337e3] Version 3.8.8.1 (user: drh, tags: release, version-3.8.8.1, branch-3.8.8)
03:04
[0077f645] Fix another instance of an incorrect value for KeyInfo.nXField on a sorting index. Ticket [f97c4637102a3ae72b79]. (user: drh, tags: trunk)
02:51
[c75555a3] Change the version number to 3.8.8.1 (user: drh, tags: branch-3.8.8)
02:50
[dc711db4] Fix another instance of an incorrect value for KeyInfo.nXField on a sorting index. More changes for ticket [f97c4637102a3ae72b79]. (user: drh, tags: branch-3.8.8)
2015-01-19
21:38
[59e592f6] Ensure that the KeyInfo.nXField value for ephemeral tables used to implement ORDER BY or GROUP BY clauses is set correctly, so that the sqlite3VdbeFindCompare() routine can choose the correct comparison function. Add assert() statements to the high-speed comparison functions to detect cases where they are inappropriately chosen. Fix for ticket [f97c4637102a3ae72b7911]. (user: drh, tags: branch-3.8.8)
21:36
[f7201bb0] Ensure that the KeyInfo.nXField value for ephemeral tables used to implement ORDER BY or GROUP BY clauses is set correctly, so that the sqlite3VdbeFindCompare() routine can choose the correct comparison function. Add assert() statements to the high-speed comparison functions to detect cases where they are inappropriately chosen. Fix for ticket [f97c4637102a3ae72b7911]. (user: drh, tags: trunk)
20:05
[2037442c] Fix compilation on Cygwin when SQLITE_MAX_WORKER_THREADS is greater than zero. (user: mistachkin, tags: trunk)
15:05
[824328f9] Enhance the command-line shell with the ability to set the SQLITE_TESTCTRL_NEVER_CORRUPT flag using: ".testctrl never_corrupt 1". (user: drh, tags: trunk)
00:35
[10321910] Eliminate all use of sprintf(), strcpy() and strcat() from test logic because OpenBSD hates those functions. (user: drh, tags: trunk)
2015-01-18
20:30
[7096e6c0] Set binary mode for output on Windows when writing a quoted string that might contain newline characters. (user: drh, tags: trunk)
01:50
[80541e8b] Set the command-line shell stdin to binary mode on windows. (user: drh, tags: trunk)
2015-01-17
15:26
[ceac571f] Fix a harmless compiler warning the VFS for Windows. (user: drh, tags: trunk)
2015-01-16
12:08
[7d68a42f] Version 3.8.8 (user: drh, tags: trunk, release, version-3.8.8)