Documentation Source Text

Check-in [0aa5202f33]
Login

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

Overview
Comment:Add a change log for version 3.8.3. Fix a typo in the FAQ.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0aa5202f33facdcf7048ce86f109ad5db211b093
User & Date: drh 2013-12-14 12:40:07
Context
2013-12-14
14:42
Update the change log with SQLITE_DETERMINISTIC. check-in: 5bc4dbf151 user: drh tags: trunk
12:40
Add a change log for version 3.8.3. Fix a typo in the FAQ. check-in: 0aa5202f33 user: drh tags: trunk
2013-12-12
14:10
Fix missing "is" in the query planner document. check-in: 200941601a user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    13     13   <tcl>
    14     14   set nChng 0
    15     15   proc chng {date desc {options {}}} {
    16     16     global nChng aChng
    17     17     set aChng($nChng) [list $date $desc $options]
    18     18     incr nChng
    19     19   }
           20  +
           21  +chng {2014-02-?? (3.8.3)} {
           22  +<li>Add [SQLITE_READONLY_DBMOVED] error code, returned at the beginning of a
           23  +    transaction, to indicate that the underlying database file has been renamed
           24  +    or moved out from under SQLite.
           25  +<li>Performance enhancements.
           26  +}
    20     27   
    21     28   chng {2013-12-06 (3.8.2)} {
    22     29   <li>Changed the defined behavior for the [CAST expression] when floating point values
    23     30       greater than  +9223372036854775807 are cast into into integers so that the
    24     31       result is the largest possible integer, +9223372036854775807, instead of
    25     32       the smallest possible integer, -9223372036854775808.  After this change, 
    26     33       CAST(9223372036854775809.0 as INT) yields +9223372036854775807 instead

Changes to pages/faq.in.

    18     18   
    19     19     <p>Here is the long answer:
    20     20     If you declare a column of a table to be [INTEGER PRIMARY KEY], then
    21     21     whenever you insert a NULL
    22     22     into that column of the table, the NULL is automatically converted
    23     23     into an integer which is one greater than the largest value of that
    24     24     column over all other rows in the table, or 1 if the table is empty.
    25         -  (If the largest possible integer key, 9223372036854775807, then an
           25  +  (If the largest possible integer key 9223372036854775807 is in use then an
    26     26     unused key value is chosen at random.)
    27     27     For example, suppose you have a table like this:
    28     28   <blockquote><pre>
    29     29   CREATE TABLE t1(
    30     30     a INTEGER PRIMARY KEY,
    31     31     b INTEGER
    32     32   );

Changes to pages/index.in.

    91     91   
    92     92   </td>
    93     93   <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
    94     94   <td valign="top">
    95     95   <h3>Current Status</h3>
    96     96   
    97     97   <p><ul>
    98         -<li><a href="releaselog/3_8_2.html">Version 3.8.2</a>
           98  +<li><a href="releaselog/3_8_3.html">Version 3.8.3</a>
    99     99   of SQLite is recommended for all new development.
   100         -Upgrading from versions 3.7.17, 3.8.0.2, and 3.8.1 is optional.
          100  +Upgrading from versions 3.7.17, 3.8.0.2, 3.8.1, and 3.8.2 is optional.
   101    101   Upgrading from all other prior versions of SQLite
   102    102   is recommended.</li>
   103    103   </ul></p>
   104    104   
   105    105   <h3>Common Links</h3>
   106    106   
   107    107   <p><ul>