Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(123)

Side by Side Diff: third_party/sqlite/src/test/tkt3832.test

Issue 6990047: Import SQLite 3.7.6.3. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src
Patch Set: Created 9 years, 7 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch | Annotate | Revision Log
« no previous file with comments | « third_party/sqlite/src/test/tkt3824.test ('k') | third_party/sqlite/src/test/tkt3838.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 # 2009 April 30 1 # 2009 April 30
2 # 2 #
3 # The author disclaims copyright to this source code. In place of 3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing: 4 # a legal notice, here is a blessing:
5 # 5 #
6 # May you do good and not evil. 6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others. 7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give. 8 # May you share freely, never taking more than you give.
9 # 9 #
10 #*********************************************************************** 10 #***********************************************************************
11 # 11 #
12 # Ticket #3832 12 # Ticket #3832
13 # 13 #
14 # A segfault when using a BEFORE trigger on an INSERT and inserting 14 # A segfault when using a BEFORE trigger on an INSERT and inserting
15 # a NULL into the INTEGER PRIMARY KEY. 15 # a NULL into the INTEGER PRIMARY KEY.
16 # 16 #
17 # $Id: tkt3832.test,v 1.1 2009/05/01 02:08:04 drh Exp $ 17 # $Id: tkt3832.test,v 1.1 2009/05/01 02:08:04 drh Exp $
18 18
19 set testdir [file dirname $argv0] 19 set testdir [file dirname $argv0]
20 source $testdir/tester.tcl 20 source $testdir/tester.tcl
21 ifcapable {!trigger} {
22 finish_test
23 return
24 }
21 25
22 26
23 do_test tkt3832-1.1 { 27 do_test tkt3832-1.1 {
24 db eval { 28 db eval {
25 CREATE TABLE t1(a INT, b INTEGER PRIMARY KEY); 29 CREATE TABLE t1(a INT, b INTEGER PRIMARY KEY);
26 CREATE TABLE log(x); 30 CREATE TABLE log(x);
27 CREATE TRIGGER t1r1 BEFORE INSERT ON t1 BEGIN 31 CREATE TRIGGER t1r1 BEFORE INSERT ON t1 BEGIN
28 INSERT INTO log VALUES(new.b); 32 INSERT INTO log VALUES(new.b);
29 END; 33 END;
30 INSERT INTO t1 VALUES(NULL,5); 34 INSERT INTO t1 VALUES(NULL,5);
31 INSERT INTO t1 SELECT b, a FROM t1 ORDER BY b; 35 INSERT INTO t1 SELECT b, a FROM t1 ORDER BY b;
32 SELECT rowid, * FROM t1; 36 SELECT rowid, * FROM t1;
33 SELECT rowid, * FROM log; 37 SELECT rowid, * FROM log;
34 } 38 }
35 } {5 {} 5 6 5 6 1 5 2 -1} 39 } {5 {} 5 6 5 6 1 5 2 -1}
36 40
37 finish_test 41 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/tkt3824.test ('k') | third_party/sqlite/src/test/tkt3838.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698