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