Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a problem in test script e_fkey.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | acfd0a05a8957728c1f0eb936f4121ce |
| User & Date: | dan 2018-11-17 13:08:07 |
Context
|
2018-11-17
| ||
| 14:19 | Remove a C++-style comment. check-in: 645232f2 user: drh tags: trunk | |
| 13:08 | Fix a problem in test script e_fkey.test. check-in: acfd0a05 user: dan tags: trunk | |
|
2018-11-16
| ||
| 20:50 | Fix a test case so that it works on windows. check-in: 2d92d25f user: drh tags: trunk | |
Changes
Changes to test/e_fkey.test.
2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 |
SELECT sql FROM sqlite_master WHERE name = 'c';
ROLLBACK;
}
} {{CREATE TABLE c(b REFERENCES "parent"(a))}}
do_test e_fkey-61.2.2 {
execsql {
PRAGMA foreign_keys = OFF;
ALTER TABLE p RENAME TO parent;
SELECT sql FROM sqlite_master WHERE name = 'c';
}
} {{CREATE TABLE c(b REFERENCES p(a))}}
do_test e_fkey-61.2.3 {
execsql { PRAGMA foreign_keys = ON }
} {}
do_test e_fkey-61.3.1 {
drop_all_tables
execsql {
CREATE TABLE p(a UNIQUE);
CREATE TABLE c(b REFERENCES p(a) ON DELETE SET NULL);
|
> > |
2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 |
SELECT sql FROM sqlite_master WHERE name = 'c';
ROLLBACK;
}
} {{CREATE TABLE c(b REFERENCES "parent"(a))}}
do_test e_fkey-61.2.2 {
execsql {
PRAGMA foreign_keys = OFF;
PRAGMA legacy_alter_table = ON;
ALTER TABLE p RENAME TO parent;
SELECT sql FROM sqlite_master WHERE name = 'c';
}
} {{CREATE TABLE c(b REFERENCES p(a))}}
do_test e_fkey-61.2.3 {
execsql { PRAGMA foreign_keys = ON }
execsql { PRAGMA legacy_alter_table = OFF }
} {}
do_test e_fkey-61.3.1 {
drop_all_tables
execsql {
CREATE TABLE p(a UNIQUE);
CREATE TABLE c(b REFERENCES p(a) ON DELETE SET NULL);
|