summaryrefslogtreecommitdiff
path: root/components/external/SQLite-3.8.1/test/trigger5.test
diff options
context:
space:
mode:
Diffstat (limited to 'components/external/SQLite-3.8.1/test/trigger5.test')
-rw-r--r--components/external/SQLite-3.8.1/test/trigger5.test43
1 files changed, 0 insertions, 43 deletions
diff --git a/components/external/SQLite-3.8.1/test/trigger5.test b/components/external/SQLite-3.8.1/test/trigger5.test
deleted file mode 100644
index 75c56b19c9..0000000000
--- a/components/external/SQLite-3.8.1/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