SQLite
Timeline
Not logged in

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

2014-07-22
12:05
[b22dd165da] Leaf: Enhance the comment on whereLoopAddBtree(). No changes to code. (user: drh, tags: trunk)
00:40
[b67a6e33f2] For the OR-optimization, avoid generating OP_OpenRead opcodes that reopen exactly the same index. (user: drh, tags: trunk)
2014-07-21
20:07
[f1c76c7c4c] Limit the maximum SQLITE_MAX_ATTACHED to 127, since a signed character is sometimes used to store the database index. (user: drh, tags: trunk)
15:44
[1a817ae2f3] Allow the SQLITE_MAX_ATTACHED compile-time option to be larger than 62. The default limit on the number of attached databases remains 10. (user: drh, tags: trunk)
2014-07-19
17:57
[61cee3c067] Update the sqlite3_stmt_busy() function so that it correctly returns true for "ROLLBACK" statements that have been stepped but not yet reset. (user: dan, tags: trunk)
17:49
[574cc8eb14] Fix harmless compiler warnings in the showdb and showwal tools and in the unicode tokenizer of FTS3. (user: drh, tags: trunk)
2014-07-18
21:02
[2beefa68c0] Update clean targets with the recently added command-line tools. (user: mistachkin, tags: trunk)
19:06
[ca92c02406] Improved documentation for checkpoints and the busy handler. No changes to code. (user: drh, tags: trunk)
17:39
[824dde7fc4] SQLite has long accepted some unadvertised and non-standard join syntax. Add a test to ensure that future versions continue to accept this non-standard syntax, to avoid breaking legacy applications that use the undefined syntax. (user: drh, tags: trunk)
14:43
[fa80c64caa] Improvements to the ".fullschema" command in the command-line shell. (user: drh, tags: trunk)
2014-07-07
18:03
[1cec1e0300] Fix harmless compiler warnings in the fts3view utility program that can occur with MSVC. (user: mistachkin, tags: trunk)
17:57
[b04751bd59] Add the fts3view utility program to the MSVC makefile. (user: mistachkin, tags: trunk)
16:07
[64f02699b4] Fix a division-by-zero error in the fts3view utility program. Add the fts3view utility program to the "main.mk" makefile. (user: drh, tags: trunk)
2014-07-03
12:18
[0cc0230ae9] Change fts3/4 so that the "unicode61" is included in builds by default. It may now be excluded by defining SQLITE_DISABLE_FTS3_UNICODE. (user: dan, tags: trunk)
2014-07-01
15:22
[0df1fe72f8] Add another test to verify that SQLite is using stat4 data for composite primary keys on WITHOUT ROWID tables. (user: dan, tags: trunk)
11:54
[21981e3506] Ensure that all fields are loaded from the stat4 table for records that correspond to indexes on WITHOUT ROWID tables with composite primary keys. (user: dan, tags: trunk)
2014-06-30
19:28
[f925e9baaf] Bump the version number to 3.8.6. (user: drh, tags: trunk)
19:07
[d09ca6d5ef] Attempt to use STAT4 information to estimate the selectivity of WHERE clause terms when using the skip-scan optimization. (user: drh, tags: trunk)
18:57
[bc2de8095f] Fix for ticket [b2fa5424e6fcb15]: Better define the format of the sqlite_stat4 file for WITHOUT ROWID tables and make sure the ANALYZE command generates a file in the appropriate format. Use the sqlite_stat4 data to enable the use of WHERE terms that cover all indexed columns plus some prefix of columns in the primary key. (user: drh, tags: trunk)
11:14
[6f86d89b88] Add makefile targets for various diagnostic tools, such as showstat4. Fix harmless compiler warnings in diagnostic tools. (user: drh, tags: trunk)
2014-06-26
22:17
[fb32e374b7] Add some more IN operator tests. (user: mistachkin, tags: trunk)
21:28
[92f7ad43db] Revise the affinity returned for expressions flagged as 'generic'. Fix for [9a8b09f8e6]. (user: mistachkin, tags: trunk)
2014-06-24
20:19
[9ca737c0b4] Fix showstat4.c so that it decodes typecodes 8 and 9 correctly. (user: drh, tags: trunk)
00:59
[b4d9f6053d] Add the showstat4.exe utility program for decoding and displaying the content of the sqlite_stat4 table in a database. (user: drh, tags: trunk)
2014-06-23
23:28
[ebec48921c] Add the .fullschema command to the sqlite3.exe utility. This command shows the schema and the content of the sqlite_stat tables, all in one go. Useful when reporting problems with the query planner. (user: drh, tags: trunk)
10:18
[07dda49c1b] Fix a problem with SQLITE_OMIT_WSD builds. (user: dan, tags: trunk)
10:04
[612b6d1b1f] Fix a problem with SQLITE_OMIT_WAL builds. (user: dan, tags: trunk)
2014-06-20
13:55
[f735c2497e] Improved display of record data in the "NNNbd" output of the showdb.exe utility program. (user: drh, tags: trunk)
01:32
[b451fe0cb9] In the showdb.exe utility, for the "NNNbd" command, also show data fields in addition to header fields on each record decoded. Improvements to formatting. (user: drh, tags: trunk)
2014-06-19
23:38
[306b461d7c] Add the ability to decode the headers of individual cells, byte-by-byte, in the "showdb.exe" utility. (user: drh, tags: trunk)
2014-06-18
18:10
[7b91b0581d] Add the "LogEst" and "LogEst.exe" target to the makefiles. (user: drh, tags: trunk)
15:24
[5e514f6ace] Fix a comment on the sqlite3Utf8Read() routine. No changes to code. (user: drh, tags: trunk)
15:11
[0a52bddd9d] Prevent an automatic index from taking the place of a declared index. (user: drh, tags: trunk)
2014-06-17
17:00
[b500f2a097] Fix a missing space in a "wheretrace" comment. No changes to production code. (user: drh, tags: trunk)
16:11
[38965484199153e] Add the likely() function for symmetry with unlikely(). The likely(X) function means the same thing as likelihood(X,0.9375). (user: drh, tags: trunk)
15:53
[1272fb8991] Improvements to query planning, especially in regards to estimating the cost and benefit of automatic indexes. (user: drh, tags: trunk)
2014-06-16
22:45
[fc918f7d33] Fix CSV import issue, reported via the mailing list, in the shell when the file to be imported ends with an empty line. (user: mistachkin, tags: trunk)
21:30
[3181d2069a] In the "wheretrace" logic (disabled for normal builds) expand the print width of the flags field to be wide enough for all 17 bits. (user: drh, tags: trunk)
18:35
[e43a2f92b6] Add the SQLITE_UNLINK_AFTER_CLOSE compile-time option. If enabled, the unlink of temporary files on unix is deferred until after the file is closed. (user: drh, tags: trunk)
18:17
[837f640423] Add an application ID for MBTiles tilesets. (user: drh, tags: trunk)
16:41
[0617e20a33] Back out the unix VFS changes that seeks to avoid fstat() calls after an unlink(). That change did not clear the problem on FuseFS. (user: drh, tags: trunk)
15:01
[b0b4c776c3] Add the ".eqp" dot-command to the ".help" output in the command-line shell. This was accidently omitted when the ".eqp" command was originally implemented for SQLite 3.8.4 (check-in e6ecf7337658624). (user: drh, tags: trunk)
12:51
[baf95a1909] Fix the extension01.test script so that it works on windows. Fix a harmless compiler warning in the fileio extension. (user: drh, tags: trunk)
12:44
[8634333127c] Add test cases for the fileio extension. (user: drh, tags: trunk)
2014-06-13
13:43
[0ca104d821] Add the fileio.c loadable extension, that implements readfile() and writefile() SQL functions. (user: drh, tags: trunk)
13:08
[d5c17d1a42] Add an extension that implements compress() and uncompress() SQL functions. (user: drh, tags: trunk)
2014-06-12
17:10
[2aeacf81df] Increase the WAL-mode SQLITE_PROTOCOL timeout to 10 seconds. (user: drh, tags: trunk)
15:46
[6c68d758bc] Simplify the estLog() routine. (user: drh, tags: trunk)
2014-06-09
20:39
[6484fb5a25] Avoid an unnecessary initialization of the szFile field of unixFile in the unix VFS. (user: drh, tags: trunk)
20:24
[10707d3578] Enhance the unix VFS so that it keeps track of the size of unlinked files internally and thus avoids the need to call fstat() on those files, since fstat() does not work reliably on unlinked files on some implementations of FuseFS. (user: drh, tags: trunk)
13:11
[1925f3a0a2] Modify the %nonassoc directive in lemon so that it generates a run-time error rather than a parsing conflict. This changes is due to a bug report on the mailing list. SQLite does not use the %nonassoc directive in its grammar so this change does not affect SQLite. (user: drh, tags: trunk)
2014-06-06
20:49
[813469d985] Add a test case to ensure that estLog() works for negative numbers. (user: drh, tags: trunk)
20:20
[75437bee49] Make sure the estLog() routine in the query planner handles negative values correctly (always returning 1). Prior to this change, estLog(-1) would return a large number which could throw off the cost computations in the query planner in obscure circumstances. (user: drh, tags: trunk)
17:09
[b16bf8518b] Fix an obsolete comment on the whereRangeScanEst() routine. No changes to code. (user: drh, tags: trunk)
2014-06-05
11:15
[7123bb2605] Fix a problem that was causing the FTS4 integrity-check command to fail if the table had one or more "notindexed" columns. (user: dan, tags: trunk)
2014-06-04
14:06
[b1ed4f2a34] Version 3.8.5 (user: drh, tags: trunk, release, version-3.8.5)