Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix some test script bugs in src4.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
132d76341ef1a589374407382b7252fa |
| User & Date: | dan 2012-09-05 11:38:37 |
Context
|
2012-09-05
| ||
| 16:18 | When possible, reuse file-descriptors from the deferred-close list instead of opening new ones. check-in: 9350457414 user: dan tags: trunk | |
| 11:38 | Fix some test script bugs in src4.test. check-in: 132d76341e user: dan tags: trunk | |
| 11:23 | Merge in multi-process branch. check-in: ecae27d73a user: dan tags: trunk | |
Changes
Changes to test/fkey2.test.
478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 |
execsql {
DELETE FROM t2 WHERE node = 1;
SELECT node FROM t2;
ROLLBACK;
}
} {}
drop_all_tables
ifcapable vacuum {
do_test fkey2-6.1 {
execsql {
CREATE TABLE t1(a REFERENCES t2(c), b);
CREATE TABLE t2(c UNIQUE, b);
INSERT INTO t2 VALUES(1, 2);
INSERT INTO t1 VALUES(1, 2);
VACUUM;
}
} {}
}
#-------------------------------------------------------------------------
# Test that it is possible to use an INTEGER PRIMARY KEY as the child key
# of a foreign constraint.
#
drop_all_tables
do_test fkey2-7.1 {
execsql {
|
< < < < < < < < < < < < < |
478 479 480 481 482 483 484 485 486 487 488 489 490 491 |
execsql {
DELETE FROM t2 WHERE node = 1;
SELECT node FROM t2;
ROLLBACK;
}
} {}
#-------------------------------------------------------------------------
# Test that it is possible to use an INTEGER PRIMARY KEY as the child key
# of a foreign constraint.
#
drop_all_tables
do_test fkey2-7.1 {
execsql {
|
Changes to test/log2.test.
100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 |
execsql { INSERT INTO t1 VALUES(randstr(10,10), randstr(100, 100)) }
execsql { INSERT INTO t1 VALUES(randstr(10,10), randstr(100, 100)) }
execsql { INSERT INTO t1 VALUES(randstr(10,10), randstr(100, 100)) }
execsql COMMIT
} {}
do_test 3.11 {
sqlite4_lsm_info db main log-structure
} {0 0 139 1062 1272 1809}
do_recover_test 3.12 { SELECT * FROM t1 } [execsql {SELECT * FROM t1}]
#-------------------------------------------------------------------------
#
reset_db
do_execsql_test 4.1 {
CREATE TABLE t1(a PRIMARY KEY, b);
|
| |
100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 |
execsql { INSERT INTO t1 VALUES(randstr(10,10), randstr(100, 100)) }
execsql { INSERT INTO t1 VALUES(randstr(10,10), randstr(100, 100)) }
execsql { INSERT INTO t1 VALUES(randstr(10,10), randstr(100, 100)) }
execsql COMMIT
} {}
do_test 3.11 {
sqlite4_lsm_info db main log-structure
} {1124 1271 0 1062 1272 1809}
do_recover_test 3.12 { SELECT * FROM t1 } [execsql {SELECT * FROM t1}]
#-------------------------------------------------------------------------
#
reset_db
do_execsql_test 4.1 {
CREATE TABLE t1(a PRIMARY KEY, b);
|