Documentation Source Text

Check-in [92f6694092]
Login

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

Overview
Comment:Add a backwards compatibility note on the documentation of cache_size and its behavior when N is negative.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 92f6694092290ee0b93c25a98b26d6fd58b01ce5
User & Date: drh 2013-03-02 17:37:24
Context
2013-03-03
00:19
Fix a typo on the pragma documentation. check-in: 556fe1bb34 user: drh tags: trunk
2013-03-02
17:37
Add a backwards compatibility note on the documentation of cache_size and its behavior when N is negative. check-in: 92f6694092 user: drh tags: trunk
16:44
Fix a typo in the change log for 3.7.16. Remove forgotten debugging puts in the download.in script. check-in: bf5c2c74b2 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

   207    207       may choose to interpret the suggested cache size in different ways
   208    208       or to ignore it all together.
   209    209       ^The default suggested cache size is 2000 pages.</p>
   210    210   
   211    211       <p>^If the argument N is positive then the suggested cache size is set 
   212    212       to N. ^If the argument N is negative, then the
   213    213       number of cache pages is adjusted to use approximately N*1024 bytes
   214         -    of memory.</p>
          214  +    of memory.
          215  +    <i>Backwards compatibility note:</i>
          216  +    The behavior of cache_size with a negative N
          217  +    was different in SQLite versions prior to 3.7.10.  In
          218  +    version 3.7.9 and earlier, the number of pages in the cache was set
          219  +    to the absolute value of N.</p>
   215    220   
   216    221       <p>^When you change the cache size using the cache_size pragma, the
   217    222       change only endures for the current session.  ^The cache size reverts
   218    223       to the default value when the database is closed and reopened.</p>
          224  +
          225  +
   219    226   }
   220    227   
   221    228   Pragma case_sensitive_like {
   222    229       <p><b>PRAGMA case_sensitive_like = </b><i>boolean</i><b>;</b></p>
   223    230       <p>^(The default behavior of the [LIKE] operator is to ignore case
   224    231       for ASCII characters. Hence, by default <b>'a' LIKE 'A'</b> is
   225    232       true.)^  ^The case_sensitive_like pragma installs a new application-defined