Documentation Source Text

Check-in [dc132e270c]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add new bullets to the change log for 3.8.1.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:dc132e270c3ad522c73a3758c2cfa7af66cbafa1
User & Date: drh 2013-10-04 17:27:20
Context
2013-10-07
08:27
Add documentation on the optional timezone suffixes to timestrings in the date and time functions. check-in: d4924d1139 user: drh tags: trunk
2013-10-04
17:27
Add new bullets to the change log for 3.8.1. check-in: dc132e270c user: drh tags: trunk
2013-10-02
13:34
Additional notes on how to corrupt an SQLite database file. check-in: 7c6ef04be8 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    26     26       that cannot be used with indices.
    27     27   <li>Added support for [SQLITE_ENABLE_STAT4]
    28     28   <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
    29     29   <li>Added the win32-longpath VFS on windows.
    30     30   <li>The [Date And Time Functions] are enhanced so that the current time
    31     31       (ex: julianday('now')) is always the same for multiple function invocations
    32     32       within the same [sqlite3_step()] call.
           33  +<li>[FTS4] queries are better able to make use of docid<$limit constraints to
           34  +    limit the amount of I/O required.
           35  +<li>The [VACUUM] command packs the database about 1% tighter.
           36  +<li>The sqlite3_analyzer utility program is updated to provide better descriptions
           37  +    and to compute a more accurate estimate for "Non-sequential pages"
           38  +<li><b>Bug fix:</b> Return the correct answer for "SELECT count(*) FROM table" even if
           39  +    there is a [partial index] on the table. Ticket
           40  +    [http://www.sqlite.org/src/info/a5c8ed66ca|a5c8ed66ca].
    33     41   }
    34     42   
    35     43   chng {2013-09-03 (3.8.0.2)} {
    36     44   <li>Fix a bug in the optimization that attempts to omit unused LEFT JOINs
    37     45   
    38     46   <li>SQLITE_SOURCE_ID: 
    39     47       "2013-09-03 17:11:13 7dd4968f235d6e1ca9547cda9cf3bd570e1609ef"