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 84 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
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 {} | 101 SQLITE_READ sqlite_master name main {} |
102 SQLITE_READ sqlite_master rootpage main {} | 102 SQLITE_READ sqlite_master rootpage main {} |
103 SQLITE_READ sqlite_master sql main {} | 103 SQLITE_READ sqlite_master sql main {} |
104 SQLITE_READ sqlite_master tbl_name main {} | 104 SQLITE_READ sqlite_master tbl_name main {} |
| 105 SQLITE_READ sqlite_master ROWID main {} |
105 } | 106 } |
106 do_test auth2-2.2 { | 107 do_test auth2-2.2 { |
107 set ::authargs {} | 108 set ::authargs {} |
108 db eval { | 109 db eval { |
109 CREATE VIEW v2 AS SELECT x+y AS a, y+z AS b from t2; | 110 CREATE VIEW v2 AS SELECT x+y AS a, y+z AS b from t2; |
110 } | 111 } |
111 set ::authargs | 112 set ::authargs |
112 } {SQLITE_INSERT sqlite_master {} main {} | 113 } {SQLITE_INSERT sqlite_master {} main {} |
113 SQLITE_CREATE_VIEW v2 {} main {} | 114 SQLITE_CREATE_VIEW v2 {} main {} |
114 SQLITE_UPDATE sqlite_master type main {} | 115 SQLITE_UPDATE sqlite_master type main {} |
115 SQLITE_UPDATE sqlite_master name main {} | 116 SQLITE_UPDATE sqlite_master name main {} |
116 SQLITE_UPDATE sqlite_master tbl_name main {} | 117 SQLITE_UPDATE sqlite_master tbl_name main {} |
117 SQLITE_UPDATE sqlite_master rootpage main {} | 118 SQLITE_UPDATE sqlite_master rootpage main {} |
118 SQLITE_UPDATE sqlite_master sql main {} | 119 SQLITE_UPDATE sqlite_master sql main {} |
119 SQLITE_READ sqlite_master ROWID main {} | 120 SQLITE_READ sqlite_master ROWID main {} |
120 SQLITE_READ sqlite_master name main {} | 121 SQLITE_READ sqlite_master name main {} |
121 SQLITE_READ sqlite_master rootpage main {} | 122 SQLITE_READ sqlite_master rootpage main {} |
122 SQLITE_READ sqlite_master sql main {} | 123 SQLITE_READ sqlite_master sql main {} |
123 SQLITE_READ sqlite_master tbl_name main {} | 124 SQLITE_READ sqlite_master tbl_name main {} |
| 125 SQLITE_READ sqlite_master ROWID main {} |
124 } | 126 } |
125 do_test auth2-2.3 { | 127 do_test auth2-2.3 { |
126 set ::authargs {} | 128 set ::authargs {} |
127 db eval { | 129 db eval { |
128 SELECT a, b FROM v2; | 130 SELECT a, b FROM v2; |
129 } | 131 } |
130 set ::authargs | 132 set ::authargs |
131 } {SQLITE_SELECT {} {} {} {} | 133 } {SQLITE_SELECT {} {} {} {} |
132 SQLITE_READ v2 a main {} | 134 SQLITE_READ v2 a main {} |
133 SQLITE_READ v2 b main {} | 135 SQLITE_READ v2 b main {} |
(...skipping 25 matching lines...) Expand all Loading... |
159 SQLITE_READ v2 a main {} | 161 SQLITE_READ v2 a main {} |
160 SQLITE_READ t2 x main v2 | 162 SQLITE_READ t2 x main v2 |
161 SQLITE_READ t2 y main v2 | 163 SQLITE_READ t2 y main v2 |
162 SQLITE_READ t2 y main v2 | 164 SQLITE_READ t2 y main v2 |
163 SQLITE_READ t2 z main v2 | 165 SQLITE_READ t2 z main v2 |
164 SQLITE_SELECT {} {} {} v2 | 166 SQLITE_SELECT {} {} {} v2 |
165 } | 167 } |
166 db2 close | 168 db2 close |
167 | 169 |
168 finish_test | 170 finish_test |
OLD | NEW |