OLD | NEW |
1 # 2001 September 15 | 1 # 2001 September 15 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 28 matching lines...) Expand all Loading... |
39 execsql { | 39 execsql { |
40 CREATE TABLE t2( | 40 CREATE TABLE t2( |
41 x INTEGER PRIMARY KEY, | 41 x INTEGER PRIMARY KEY, |
42 y TEXT | 42 y TEXT |
43 ); | 43 ); |
44 } | 44 } |
45 } {} | 45 } {} |
46 do_test fkey1-1.2 { | 46 do_test fkey1-1.2 { |
47 execsql { | 47 execsql { |
48 CREATE TABLE t3( | 48 CREATE TABLE t3( |
49 a INTEGER REFERENCES t2 ON INSERT RESTRICT, | 49 a INTEGER REFERENCES t2, |
50 b INTEGER REFERENCES t1, | 50 b INTEGER REFERENCES t1, |
51 FOREIGN KEY (a,b) REFERENCES t2(x,y) | 51 FOREIGN KEY (a,b) REFERENCES t2(x,y) |
52 ); | 52 ); |
53 } | 53 } |
54 } {} | 54 } {} |
55 | 55 |
56 do_test fkey1-2.1 { | 56 do_test fkey1-2.1 { |
57 execsql { | 57 execsql { |
58 CREATE TABLE t4(a integer primary key); | 58 CREATE TABLE t4(a integer primary key); |
59 CREATE TABLE t5(x references t4); | 59 CREATE TABLE t5(x references t4); |
(...skipping 13 matching lines...) Expand all Loading... |
73 | 73 |
74 do_test fkey1-3.1 { | 74 do_test fkey1-3.1 { |
75 execsql { | 75 execsql { |
76 CREATE TABLE t5(a PRIMARY KEY, b, c); | 76 CREATE TABLE t5(a PRIMARY KEY, b, c); |
77 CREATE TABLE t6( | 77 CREATE TABLE t6( |
78 d REFERENCES t5, | 78 d REFERENCES t5, |
79 e REFERENCES t5(c) | 79 e REFERENCES t5(c) |
80 ); | 80 ); |
81 PRAGMA foreign_key_list(t6); | 81 PRAGMA foreign_key_list(t6); |
82 } | 82 } |
83 } [concat \ | 83 } [concat \ |
84 {0 0 t5 e c RESTRICT RESTRICT NONE} \ | 84 {0 0 t5 e c {NO ACTION} {NO ACTION} NONE} \ |
85 {1 0 t5 d {} RESTRICT RESTRICT NONE} \ | 85 {1 0 t5 d {} {NO ACTION} {NO ACTION} NONE} \ |
86 ] | 86 ] |
87 do_test fkey1-3.2 { | 87 do_test fkey1-3.2 { |
88 execsql { | 88 execsql { |
89 CREATE TABLE t7(d, e, f, | 89 CREATE TABLE t7(d, e, f, |
90 FOREIGN KEY (d, e) REFERENCES t5(a, b) | 90 FOREIGN KEY (d, e) REFERENCES t5(a, b) |
91 ); | 91 ); |
92 PRAGMA foreign_key_list(t7); | 92 PRAGMA foreign_key_list(t7); |
93 } | 93 } |
94 } [concat \ | 94 } [concat \ |
95 {0 0 t5 d a RESTRICT RESTRICT NONE} \ | 95 {0 0 t5 d a {NO ACTION} {NO ACTION} NONE} \ |
96 {0 1 t5 e b RESTRICT RESTRICT NONE} \ | 96 {0 1 t5 e b {NO ACTION} {NO ACTION} NONE} \ |
97 ] | 97 ] |
98 do_test fkey1-3.3 { | 98 do_test fkey1-3.3 { |
99 execsql { | 99 execsql { |
100 CREATE TABLE t8(d, e, f, | 100 CREATE TABLE t8(d, e, f, |
101 FOREIGN KEY (d, e) REFERENCES t5 ON DELETE CASCADE ON UPDATE SET NULL | 101 FOREIGN KEY (d, e) REFERENCES t5 ON DELETE CASCADE ON UPDATE SET NULL |
102 ); | 102 ); |
103 PRAGMA foreign_key_list(t8); | 103 PRAGMA foreign_key_list(t8); |
104 } | 104 } |
105 } [concat \ | 105 } [concat \ |
106 {0 0 t5 d {} {SET NULL} CASCADE NONE} \ | 106 {0 0 t5 d {} {SET NULL} CASCADE NONE} \ |
107 {0 1 t5 e {} {SET NULL} CASCADE NONE} \ | 107 {0 1 t5 e {} {SET NULL} CASCADE NONE} \ |
108 ] | 108 ] |
109 do_test fkey1-3.4 { | 109 do_test fkey1-3.4 { |
110 execsql { | 110 execsql { |
111 CREATE TABLE t9(d, e, f, | 111 CREATE TABLE t9(d, e, f, |
112 FOREIGN KEY (d, e) REFERENCES t5 ON DELETE CASCADE ON UPDATE SET DEFAULT | 112 FOREIGN KEY (d, e) REFERENCES t5 ON DELETE CASCADE ON UPDATE SET DEFAULT |
113 ); | 113 ); |
114 PRAGMA foreign_key_list(t9); | 114 PRAGMA foreign_key_list(t9); |
115 } | 115 } |
116 } [concat \ | 116 } [concat \ |
117 {0 0 t5 d {} {SET DEFAULT} CASCADE NONE} \ | 117 {0 0 t5 d {} {SET DEFAULT} CASCADE NONE} \ |
118 {0 1 t5 e {} {SET DEFAULT} CASCADE NONE} \ | 118 {0 1 t5 e {} {SET DEFAULT} CASCADE NONE} \ |
119 ] | 119 ] |
120 | 120 |
121 finish_test | 121 finish_test |
OLD | NEW |