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. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
92f6694092290ee0b93c25a98b26d6fd |
| 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
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