| OLD | NEW |
| 1 # The author disclaims copyright to this source code. In place of | 1 # The author disclaims copyright to this source code. In place of |
| 2 # a legal notice, here is a blessing: | 2 # a legal notice, here is a blessing: |
| 3 # | 3 # |
| 4 # May you do good and not evil. | 4 # May you do good and not evil. |
| 5 # May you find forgiveness for yourself and forgive others. | 5 # May you find forgiveness for yourself and forgive others. |
| 6 # May you share freely, never taking more than you give. | 6 # May you share freely, never taking more than you give. |
| 7 # | 7 # |
| 8 #*********************************************************************** | 8 #*********************************************************************** |
| 9 # | 9 # |
| 10 # This file tests the triggers of views. | 10 # This file tests the triggers of views. |
| (...skipping 180 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 191 } {0 {}} | 191 } {0 {}} |
| 192 do_test trigger4-7.2 { | 192 do_test trigger4-7.2 { |
| 193 execsql {select a, b from vw where a<=102 or a>=227 order by a} | 193 execsql {select a, b from vw where a<=102 or a>=227 order by a} |
| 194 } {101 1001 102 2002 227 2127 228 2128} | 194 } {101 1001 102 2002 227 2127 228 2128} |
| 195 | 195 |
| 196 integrity_check trigger4-99.9 | 196 integrity_check trigger4-99.9 |
| 197 db close | 197 db close |
| 198 forcedelete trigtest.db trigtest.db-journal | 198 forcedelete trigtest.db trigtest.db-journal |
| 199 | 199 |
| 200 finish_test | 200 finish_test |
| OLD | NEW |