Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add another test case to temptable3.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 223640243efc52c14bb2bb540833a2a6 |
| User & Date: | dan 2016-05-10 20:16:43 |
Context
|
2016-05-11
| ||
| 10:57 | Add pcache tracing macros. Off by default. Requires changing an "#if 0" and recompiling to enable. check-in: d9313d19 user: drh tags: trunk | |
|
2016-05-10
| ||
| 20:16 | Add another test case to temptable3.test. check-in: 22364024 user: dan tags: trunk | |
| 20:03 | Fix a problem in sqlite3PagerMovepage() when working on a temp table for which pages have been spilled. check-in: 20cf8811 user: drh tags: trunk | |
Changes
Changes to test/temptable3.test.
21 22 23 24 25 26 27 28 29 |
PRAGMA auto_vacuum = 2;
CREATE TABLE t1(x);
INSERT INTO t1 VALUES( randomblob(800) );
INSERT INTO t1 VALUES( randomblob(800) );
CREATE TABLE t2(x);
PRAGMA integrity_check;
} {ok}
finish_test
|
> > > > > > > > > > > > |
21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
PRAGMA auto_vacuum = 2;
CREATE TABLE t1(x);
INSERT INTO t1 VALUES( randomblob(800) );
INSERT INTO t1 VALUES( randomblob(800) );
CREATE TABLE t2(x);
PRAGMA integrity_check;
} {ok}
db close
sqlite3 db {}
do_execsql_test 1.2 {
PRAGMA cache_size = 1;
PRAGMA auto_vacuum = 2;
CREATE TABLE t1(x);
CREATE TABLE t2(x UNIQUE);
INSERT INTO t2 VALUES(1), (2), (3);
DROP TABLE t1;
PRAGMA integrity_check;
} {ok}
finish_test
|