OLD | NEW |
1 # 2011 April 9 | 1 # 2011 April 9 |
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 141 matching lines...) Loading... |
152 sql1 { CREATE TABLE aux.t2(x) } | 152 sql1 { CREATE TABLE aux.t2(x) } |
153 sql1 { DROP INDEX IF EXISTS aux.i2 } | 153 sql1 { DROP INDEX IF EXISTS aux.i2 } |
154 sql2 { CREATE INDEX aux.i2 ON t2(x) } | 154 sql2 { CREATE INDEX aux.i2 ON t2(x) } |
155 sql1 { DROP INDEX IF EXISTS aux.i2 } | 155 sql1 { DROP INDEX IF EXISTS aux.i2 } |
156 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'index' } | 156 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'index' } |
157 } {} | 157 } {} |
158 do_test 3.$tn.2.2 { | 158 do_test 3.$tn.2.2 { |
159 sql1 { DROP INDEX IF EXISTS i2 } | 159 sql1 { DROP INDEX IF EXISTS i2 } |
160 sql2 { CREATE INDEX aux.i2 ON t2(x) } | 160 sql2 { CREATE INDEX aux.i2 ON t2(x) } |
161 sql1 { DROP INDEX IF EXISTS i2 } | 161 sql1 { DROP INDEX IF EXISTS i2 } |
162 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'index' } | 162 sql2 { SELECT * FROM aux.sqlite_master WHERE type = 'index' } |
163 } {} | 163 } {} |
164 | 164 |
165 # VIEW objects. | 165 # VIEW objects. |
166 # | 166 # |
167 do_test 3.$tn.3.1 { | 167 do_test 3.$tn.3.1 { |
168 sql1 { DROP VIEW IF EXISTS aux.v1 } | 168 sql1 { DROP VIEW IF EXISTS aux.v1 } |
169 sql2 { CREATE VIEW aux.v1 AS SELECT * FROM t2 } | 169 sql2 { CREATE VIEW aux.v1 AS SELECT * FROM t2 } |
170 sql1 { DROP VIEW IF EXISTS aux.v1 } | 170 sql1 { DROP VIEW IF EXISTS aux.v1 } |
171 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'view' } | 171 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'view' } |
172 } {} | 172 } {} |
(...skipping 16 matching lines...) Loading... |
189 sql1 { DROP TRIGGER IF EXISTS tr1 } | 189 sql1 { DROP TRIGGER IF EXISTS tr1 } |
190 sql2 { CREATE TRIGGER aux.tr1 AFTER INSERT ON t2 BEGIN SELECT 1; END } | 190 sql2 { CREATE TRIGGER aux.tr1 AFTER INSERT ON t2 BEGIN SELECT 1; END } |
191 sql1 { DROP TRIGGER IF EXISTS tr1 } | 191 sql1 { DROP TRIGGER IF EXISTS tr1 } |
192 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'trigger' } | 192 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'trigger' } |
193 } {} | 193 } {} |
194 } | 194 } |
195 } | 195 } |
196 | 196 |
197 | 197 |
198 finish_test | 198 finish_test |
OLD | NEW |