| 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...) Expand 10 before | Expand all | Expand 10 after 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...) Expand all 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 |