| 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 |