OLD | NEW |
1 # 2006 Aug 24 | 1 # 2006 Aug 24 |
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 80 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
91 } | 91 } |
92 set ::authargs | 92 set ::authargs |
93 } {SQLITE_INSERT sqlite_master {} main {} | 93 } {SQLITE_INSERT sqlite_master {} main {} |
94 SQLITE_CREATE_TABLE t2 {} main {} | 94 SQLITE_CREATE_TABLE t2 {} main {} |
95 SQLITE_UPDATE sqlite_master type main {} | 95 SQLITE_UPDATE sqlite_master type main {} |
96 SQLITE_UPDATE sqlite_master name main {} | 96 SQLITE_UPDATE sqlite_master name main {} |
97 SQLITE_UPDATE sqlite_master tbl_name main {} | 97 SQLITE_UPDATE sqlite_master tbl_name main {} |
98 SQLITE_UPDATE sqlite_master rootpage main {} | 98 SQLITE_UPDATE sqlite_master rootpage main {} |
99 SQLITE_UPDATE sqlite_master sql main {} | 99 SQLITE_UPDATE sqlite_master sql main {} |
100 SQLITE_READ sqlite_master ROWID main {} | 100 SQLITE_READ sqlite_master ROWID main {} |
101 SQLITE_READ sqlite_master name main {} | |
102 SQLITE_READ sqlite_master rootpage main {} | |
103 SQLITE_READ sqlite_master sql main {} | |
104 SQLITE_READ sqlite_master tbl_name main {} | |
105 SQLITE_READ sqlite_master type main {} | |
106 SQLITE_READ sqlite_master ROWID main {} | |
107 } | 101 } |
108 do_test auth2-2.2 { | 102 do_test auth2-2.2 { |
109 set ::authargs {} | 103 set ::authargs {} |
110 db eval { | 104 db eval { |
111 CREATE VIEW v2 AS SELECT x+y AS a, y+z AS b from t2; | 105 CREATE VIEW v2 AS SELECT x+y AS a, y+z AS b from t2; |
112 } | 106 } |
113 set ::authargs | 107 set ::authargs |
114 } {SQLITE_INSERT sqlite_master {} main {} | 108 } {SQLITE_INSERT sqlite_master {} main {} |
115 SQLITE_CREATE_VIEW v2 {} main {} | 109 SQLITE_CREATE_VIEW v2 {} main {} |
116 SQLITE_UPDATE sqlite_master type main {} | 110 SQLITE_UPDATE sqlite_master type main {} |
117 SQLITE_UPDATE sqlite_master name main {} | 111 SQLITE_UPDATE sqlite_master name main {} |
118 SQLITE_UPDATE sqlite_master tbl_name main {} | 112 SQLITE_UPDATE sqlite_master tbl_name main {} |
119 SQLITE_UPDATE sqlite_master rootpage main {} | 113 SQLITE_UPDATE sqlite_master rootpage main {} |
120 SQLITE_UPDATE sqlite_master sql main {} | 114 SQLITE_UPDATE sqlite_master sql main {} |
121 SQLITE_READ sqlite_master ROWID main {} | 115 SQLITE_READ sqlite_master ROWID main {} |
122 SQLITE_READ sqlite_master name main {} | |
123 SQLITE_READ sqlite_master rootpage main {} | |
124 SQLITE_READ sqlite_master sql main {} | |
125 SQLITE_READ sqlite_master tbl_name main {} | |
126 SQLITE_READ sqlite_master type main {} | |
127 SQLITE_READ sqlite_master ROWID main {} | |
128 } | 116 } |
129 do_test auth2-2.3 { | 117 do_test auth2-2.3 { |
130 set ::authargs {} | 118 set ::authargs {} |
131 db eval { | 119 db eval { |
132 SELECT a, b FROM v2; | 120 SELECT a, b FROM v2; |
133 } | 121 } |
134 set ::authargs | 122 set ::authargs |
135 } {SQLITE_SELECT {} {} {} {} | 123 } {SQLITE_SELECT {} {} {} {} |
136 SQLITE_READ t2 x main v2 | 124 SQLITE_READ t2 x main v2 |
137 SQLITE_READ t2 y main v2 | 125 SQLITE_READ t2 y main v2 |
(...skipping 25 matching lines...) Expand all Loading... |
163 SQLITE_READ t2 y main v2 | 151 SQLITE_READ t2 y main v2 |
164 SQLITE_READ t2 y main v2 | 152 SQLITE_READ t2 y main v2 |
165 SQLITE_READ t2 z main v2 | 153 SQLITE_READ t2 z main v2 |
166 SQLITE_READ v2 b main {} | 154 SQLITE_READ v2 b main {} |
167 SQLITE_READ v2 a main {} | 155 SQLITE_READ v2 a main {} |
168 SQLITE_SELECT {} {} {} v2 | 156 SQLITE_SELECT {} {} {} v2 |
169 } | 157 } |
170 db2 close | 158 db2 close |
171 | 159 |
172 finish_test | 160 finish_test |
OLD | NEW |