Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | d7b7f038a2c5e81a58c1dd4b556096b58ce10c30eb74fd4b770445927fdb62f3 |
| User & Date: | drh 2017-09-12 00:24:45 |
Context
|
2017-09-12
| ||
| 13:27 | Changes to (hopefully) get the build working with recent Intel compilers. check-in: b22cdd67 user: drh tags: trunk | |
| 00:24 | Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. check-in: d7b7f038 user: drh tags: trunk | |
|
2017-09-11
| ||
| 23:46 | New test case for ticket [b899b6042f97f52d]. check-in: 9d91ee5e user: drh tags: trunk | |
Changes
Changes to test/pragma.test.
1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 |
DROP TABLE t2;
CREATE TABLE t2(x, y INTEGER REFERENCES t1);
}
db2 eval {
PRAGMA foreign_key_list(t2);
}
} {0 0 t1 y {} {NO ACTION} {NO ACTION} NONE}
reset_db
do_execsql_test 24.0 {
PRAGMA page_size = 1024;
CREATE TABLE t1(a, b, c);
CREATE INDEX i1 ON t1(b);
INSERT INTO t1 VALUES('a', 'b', 'c');
|
> |
1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 |
DROP TABLE t2;
CREATE TABLE t2(x, y INTEGER REFERENCES t1);
}
db2 eval {
PRAGMA foreign_key_list(t2);
}
} {0 0 t1 y {} {NO ACTION} {NO ACTION} NONE}
db2 close
reset_db
do_execsql_test 24.0 {
PRAGMA page_size = 1024;
CREATE TABLE t1(a, b, c);
CREATE INDEX i1 ON t1(b);
INSERT INTO t1 VALUES('a', 'b', 'c');
|