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 23 matching lines...) Expand all Loading... |
34 || coalesce(old.a,'NULL') || ',' || quote(old.b) || ',' || old.c || ');'; | 34 || coalesce(old.a,'NULL') || ',' || quote(old.b) || ',' || old.c || ');'; |
35 END; | 35 END; |
36 DELETE FROM Item WHERE a = 1; | 36 DELETE FROM Item WHERE a = 1; |
37 SELECT * FROM Undo; | 37 SELECT * FROM Undo; |
38 } | 38 } |
39 } {{INSERT INTO Item (a,b,c) VALUES (1,38205.60865,340);}} | 39 } {{INSERT INTO Item (a,b,c) VALUES (1,38205.60865,340);}} |
40 | 40 |
41 integrity_check trigger5-99.9 | 41 integrity_check trigger5-99.9 |
42 | 42 |
43 finish_test | 43 finish_test |
OLD | NEW |