diff options
author | dan miller | 2007-10-21 08:36:32 +0000 |
---|---|---|
committer | dan miller | 2007-10-21 08:36:32 +0000 |
commit | 2f8d7092bc2c9609fa98d6888106b96f38b22828 (patch) | |
tree | da6c37579258cc965b52a75aee6135fe44237698 /libraries/sqlite/unix/sqlite-3.5.1/test/trigger5.test | |
parent | * Committing new PolicyManager based on an ACL system. (diff) | |
download | opensim-SC-2f8d7092bc2c9609fa98d6888106b96f38b22828.zip opensim-SC-2f8d7092bc2c9609fa98d6888106b96f38b22828.tar.gz opensim-SC-2f8d7092bc2c9609fa98d6888106b96f38b22828.tar.bz2 opensim-SC-2f8d7092bc2c9609fa98d6888106b96f38b22828.tar.xz |
libraries moved to opensim-libs, a new repository
Diffstat (limited to 'libraries/sqlite/unix/sqlite-3.5.1/test/trigger5.test')
-rw-r--r-- | libraries/sqlite/unix/sqlite-3.5.1/test/trigger5.test | 43 |
1 files changed, 0 insertions, 43 deletions
diff --git a/libraries/sqlite/unix/sqlite-3.5.1/test/trigger5.test b/libraries/sqlite/unix/sqlite-3.5.1/test/trigger5.test deleted file mode 100644 index 75c56b1..0000000 --- a/libraries/sqlite/unix/sqlite-3.5.1/test/trigger5.test +++ /dev/null | |||
@@ -1,43 +0,0 @@ | |||
1 | # The author disclaims copyright to this source code. In place of | ||
2 | # a legal notice, here is a blessing: | ||
3 | # | ||
4 | # May you do good and not evil. | ||
5 | # May you find forgiveness for yourself and forgive others. | ||
6 | # May you share freely, never taking more than you give. | ||
7 | # | ||
8 | #*********************************************************************** | ||
9 | # | ||
10 | # This file tests the triggers of views. | ||
11 | # | ||
12 | |||
13 | set testdir [file dirname $argv0] | ||
14 | source $testdir/tester.tcl | ||
15 | ifcapable {!trigger} { | ||
16 | finish_test | ||
17 | return | ||
18 | } | ||
19 | |||
20 | # Ticket #844 | ||
21 | # | ||
22 | do_test trigger5-1.1 { | ||
23 | execsql { | ||
24 | CREATE TABLE Item( | ||
25 | a integer PRIMARY KEY NOT NULL , | ||
26 | b double NULL , | ||
27 | c int NOT NULL DEFAULT 0 | ||
28 | ); | ||
29 | CREATE TABLE Undo(UndoAction TEXT); | ||
30 | INSERT INTO Item VALUES (1,38205.60865,340); | ||
31 | CREATE TRIGGER trigItem_UNDO_AD AFTER DELETE ON Item FOR EACH ROW | ||
32 | BEGIN | ||
33 | INSERT INTO Undo SELECT 'INSERT INTO Item (a,b,c) VALUES (' | ||
34 | || coalesce(old.a,'NULL') || ',' || quote(old.b) || ',' || old.c || ');'; | ||
35 | END; | ||
36 | DELETE FROM Item WHERE a = 1; | ||
37 | SELECT * FROM Undo; | ||
38 | } | ||
39 | } {{INSERT INTO Item (a,b,c) VALUES (1,38205.60865,340);}} | ||
40 | |||
41 | integrity_check trigger5-99.9 | ||
42 | |||
43 | finish_test | ||