wasCSharpSQLite – Blame information for rev 7
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | office | 1 | # 2007 Oct 3 |
2 | # |
||
3 | # The author disclaims copyright to this source code. In place of |
||
4 | # a legal notice, here is a blessing: |
||
5 | # |
||
6 | # May you do good and not evil. |
||
7 | # May you find forgiveness for yourself and forgive others. |
||
8 | # May you share freely, never taking more than you give. |
||
9 | # |
||
10 | #*********************************************************************** |
||
11 | # |
||
12 | # This file is to test that ticket #2767 has been fixed. |
||
13 | # Ticket #2767 is for a VDBE stack overflow on BEFORE |
||
14 | # triggers that run RAISE(IGNORE). |
||
15 | # |
||
16 | # $Id: tkt2767.test,v 1.3 2009/04/07 14:14:23 danielk1977 Exp $ |
||
17 | # |
||
18 | |||
19 | set testdir [file dirname $argv0] |
||
20 | source $testdir/tester.tcl |
||
21 | |||
22 | ifcapable !trigger { finish_test ; return } |
||
23 | |||
24 | do_test tkt2767-1.1 { |
||
25 | execsql { |
||
26 | -- Construct a table with many rows of data |
||
27 | CREATE TABLE t1(x); |
||
28 | INSERT INTO t1 VALUES(1); |
||
29 | INSERT INTO t1 VALUES(2); |
||
30 | INSERT INTO t1 SELECT x+2 FROM t1; |
||
31 | INSERT INTO t1 SELECT x+4 FROM t1; |
||
32 | INSERT INTO t1 SELECT x+8 FROM t1; |
||
33 | INSERT INTO t1 SELECT x+16 FROM t1; |
||
34 | |||
35 | -- BEFORE triggers that invoke raise(ignore). The effect of |
||
36 | -- these triggers should be to make INSERTs, UPDATEs, and DELETEs |
||
37 | -- into no-ops. |
||
38 | CREATE TRIGGER r1 BEFORE UPDATE ON t1 BEGIN |
||
39 | SELECT raise(ignore); |
||
40 | END; |
||
41 | CREATE TRIGGER r2 BEFORE DELETE ON t1 BEGIN |
||
42 | SELECT raise(ignore); |
||
43 | END; |
||
44 | CREATE TRIGGER r3 BEFORE INSERT ON t1 BEGIN |
||
45 | SELECT raise(ignore); |
||
46 | END; |
||
47 | |||
48 | -- Verify the table content |
||
49 | SELECT count(*), sum(x) FROM t1; |
||
50 | } |
||
51 | } {32 528} |
||
52 | |||
53 | # Try to delete all elements of the table. This will invoke the |
||
54 | # DELETE trigger 32 times, which should overflow the VDBE stack if |
||
55 | # the problem of #2767 is not fixed. If the problem is fixed, all |
||
56 | # the deletes should be no-ops so the table should remain unchanged. |
||
57 | # |
||
58 | do_test tkt2767-1.2 { |
||
59 | execsql { |
||
60 | DELETE FROM t1 WHERE x>0; |
||
61 | SELECT count(*), sum(x) FROM t1; |
||
62 | } |
||
63 | } {32 528} |
||
64 | |||
65 | # Try to update all elements of the table. This will invoke the |
||
66 | # UPDATE trigger 32 times, which should overflow the VDBE stack if |
||
67 | # the problem of #2767 is not fixed. If the problem is fixed, all |
||
68 | # the updates should be no-ops so the table should remain unchanged. |
||
69 | # |
||
70 | do_test tkt2767-1.3 { |
||
71 | execsql { |
||
72 | UPDATE t1 SET x=x+1; |
||
73 | SELECT count(*), sum(x) FROM t1; |
||
74 | } |
||
75 | } {32 528} |
||
76 | |||
77 | # Invoke the insert trigger. The insert trigger was working |
||
78 | # even prior to the fix of #2767. But it seems good to go ahead |
||
79 | # and verify that it works. |
||
80 | # |
||
81 | do_test tkt2767-1.4 { |
||
82 | execsql { |
||
83 | INSERT INTO t1 SELECT x+32 FROM t1; |
||
84 | SELECT count(*), sum(x) FROM t1; |
||
85 | } |
||
86 | } {32 528} |
||
87 | |||
88 | |||
89 | |||
90 | finish_test |