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

Side by Side Diff: third_party/sqlite/sqlite-src-3080704/test/tkt-d82e3f3721.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 2 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
OLDNEW
(Empty)
1 # 2009 September 2
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 # This file implements regression tests for SQLite library.
12 #
13 # This file implements tests to verify that ticket [d82e3f3721] has been
14 # fixed.
15 #
16
17 set testdir [file dirname $argv0]
18 source $testdir/tester.tcl
19
20 ifcapable !compound {
21 finish_test
22 return
23 }
24
25 do_test tkt-d82e3-1.1 {
26 db eval {
27 CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
28 INSERT INTO t1 VALUES(null,'abc');
29 INSERT INTO t1 VALUES(null,'def');
30 DELETE FROM t1;
31 INSERT INTO t1 VALUES(null,'ghi');
32 SELECT * FROM t1;
33 }
34 } {3 ghi}
35 do_test tkt-d82e3-1.2 {
36 db eval {
37 CREATE TEMP TABLE t2(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
38 INSERT INTO t2 VALUES(null,'jkl');
39 INSERT INTO t2 VALUES(null,'mno');
40 DELETE FROM t2;
41 INSERT INTO t2 VALUES(null,'pqr');
42 SELECT * FROM t2;
43 }
44 } {3 pqr}
45 do_test tkt-d82e3-1.3 {
46 db eval {
47 SELECT 'main', * FROM main.sqlite_sequence
48 UNION ALL
49 SELECT 'temp', * FROM temp.sqlite_sequence
50 ORDER BY 2
51 }
52 } {main t1 3 temp t2 3}
53 do_test tkt-d82e3-1.4 {
54 db eval {
55 VACUUM;
56 SELECT 'main', * FROM main.sqlite_sequence
57 UNION ALL
58 SELECT 'temp', * FROM temp.sqlite_sequence
59 ORDER BY 2
60 }
61 } {main t1 3 temp t2 3}
62
63 sqlite3 db2 test.db
64 do_test tkt-d82e3-2.1 {
65 db eval {
66 CREATE TEMP TABLE t3(x);
67 INSERT INTO t3 VALUES(1);
68 }
69 db2 eval {
70 CREATE TABLE t3(y,z);
71 INSERT INTO t3 VALUES(8,9);
72 }
73 db eval {
74 SELECT * FROM temp.t3 JOIN main.t3;
75 }
76 } {1 8 9}
77 do_test tkt-d82e3-2.2 {
78 db eval {
79 VACUUM;
80 SELECT * FROM temp.t3 JOIN main.t3;
81 }
82 } {1 8 9}
83 db2 close
84
85 finish_test
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698