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 creating and dropping triggers, and interaction thereof | 10 # This file tests creating and dropping triggers, and interaction thereof |
(...skipping 682 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
693 } {1 {the NOT INDEXED clause is not allowed on UPDATE or DELETE statements withi
n triggers}} | 693 } {1 {the NOT INDEXED clause is not allowed on UPDATE or DELETE statements withi
n triggers}} |
694 do_test trigger1-16.7 { | 694 do_test trigger1-16.7 { |
695 catchsql { | 695 catchsql { |
696 CREATE TRIGGER main.t16err7 AFTER INSERT ON tA BEGIN | 696 CREATE TRIGGER main.t16err7 AFTER INSERT ON tA BEGIN |
697 DELETE FROM t16 INDEXED BY t16a WHERE a=123; | 697 DELETE FROM t16 INDEXED BY t16a WHERE a=123; |
698 END; | 698 END; |
699 } | 699 } |
700 } {1 {the INDEXED BY clause is not allowed on UPDATE or DELETE statements within
triggers}} | 700 } {1 {the INDEXED BY clause is not allowed on UPDATE or DELETE statements within
triggers}} |
701 | 701 |
702 finish_test | 702 finish_test |
OLD | NEW |