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 file delete -force trigtest.db trigtest.db-journal | 198 file delete -force trigtest.db trigtest.db-journal |
199 | 199 |
200 finish_test | 200 finish_test |
OLD | NEW |