Index: third_party/sqlite/sqlite-src-3080704/test/trigger5.test |
diff --git a/third_party/sqlite/sqlite-src-3080704/test/trigger5.test b/third_party/sqlite/sqlite-src-3080704/test/trigger5.test |
deleted file mode 100644 |
index 75c56b19c9af14170e9ffab15541e74082b07d9f..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3080704/test/trigger5.test |
+++ /dev/null |
@@ -1,43 +0,0 @@ |
-# The author disclaims copyright to this source code. In place of |
-# a legal notice, here is a blessing: |
-# |
-# May you do good and not evil. |
-# May you find forgiveness for yourself and forgive others. |
-# May you share freely, never taking more than you give. |
-# |
-#*********************************************************************** |
-# |
-# This file tests the triggers of views. |
-# |
- |
-set testdir [file dirname $argv0] |
-source $testdir/tester.tcl |
-ifcapable {!trigger} { |
- finish_test |
- return |
-} |
- |
-# Ticket #844 |
-# |
-do_test trigger5-1.1 { |
- execsql { |
- CREATE TABLE Item( |
- a integer PRIMARY KEY NOT NULL , |
- b double NULL , |
- c int NOT NULL DEFAULT 0 |
- ); |
- CREATE TABLE Undo(UndoAction TEXT); |
- INSERT INTO Item VALUES (1,38205.60865,340); |
- CREATE TRIGGER trigItem_UNDO_AD AFTER DELETE ON Item FOR EACH ROW |
- BEGIN |
- INSERT INTO Undo SELECT 'INSERT INTO Item (a,b,c) VALUES (' |
- || coalesce(old.a,'NULL') || ',' || quote(old.b) || ',' || old.c || ');'; |
- END; |
- DELETE FROM Item WHERE a = 1; |
- SELECT * FROM Undo; |
- } |
-} {{INSERT INTO Item (a,b,c) VALUES (1,38205.60865,340);}} |
- |
-integrity_check trigger5-99.9 |
- |
-finish_test |