Lines Matching refs:cache_size
28 # pragma-1.*: Test cache_size, default_cache_size and synchronous on main db.
31 # pragma-4.*: Test cache_size and default_cache_size on attached db.
41 # pragma-15.*: Test that the value set using the cache_size pragma is not
86 # EVIDENCE-OF: R-13861-56665 PRAGMA schema.cache_size; PRAGMA
87 # schema.cache_size = pages; PRAGMA schema.cache_size = -kibibytes;
96 PRAGMA cache_size;
106 PRAGMA cache_size=1234;
107 PRAGMA cache_size;
116 PRAGMA cache_size;
124 PRAGMA cache_size;
131 PRAGMA cache_size=-4321;
132 PRAGMA cache_size;
140 PRAGMA cache_size;
149 PRAGMA cache_size;
157 PRAGMA cache_size;
166 PRAGMA cache_size;
175 PRAGMA cache_size;
184 PRAGMA cache_size;
192 PRAGMA cache_size;
200 PRAGMA cache_size;
209 PRAGMA cache_size;
585 # Test modifying the cache_size of an attached database.
590 pragma aux.cache_size;
596 pragma aux.cache_size = 50;
597 pragma aux.cache_size;
604 pragma aux.cache_size;
610 pragma cache_size;
618 pragma aux.cache_size;
626 pragma aux.cache_size;
1125 PRAGMA temp.cache_size = 1;
1409 PRAGMA temp.cache_size = 400;
1410 PRAGMA temp.cache_size;
1511 # Test that the value set using the cache_size pragma is not reset when the
1519 PRAGMA cache_size=59;
1520 PRAGMA cache_size;
1533 # point there was a bug that reset the cache_size to its default value
1536 execsql { PRAGMA cache_size }