| 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 |