Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| 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 |
|
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 to pages/pragma.in.
207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 |
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.</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
|
| > > > > > > > |
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
|