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

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

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 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
« no previous file with comments | « third_party/sqlite/src/test/instrfault.test ('k') | third_party/sqlite/src/test/interrupt.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 November 10 1 # 2009 November 10
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 #***********************************************************************
(...skipping 24 matching lines...) Expand all
35 SELECT b FROM t1 WHERE a IN (12,34,56,78) ORDER BY a 35 SELECT b FROM t1 WHERE a IN (12,34,56,78) ORDER BY a
36 } 36 }
37 } {x012 x034 x056 x078} 37 } {x012 x034 x056 x078}
38 38
39 do_test intarray-1.1 { 39 do_test intarray-1.1 {
40 set ia1 [sqlite3_intarray_create db ia1] 40 set ia1 [sqlite3_intarray_create db ia1]
41 set ia2 [sqlite3_intarray_create db ia2] 41 set ia2 [sqlite3_intarray_create db ia2]
42 set ia3 [sqlite3_intarray_create db ia3] 42 set ia3 [sqlite3_intarray_create db ia3]
43 set ia4 [sqlite3_intarray_create db ia4] 43 set ia4 [sqlite3_intarray_create db ia4]
44 db eval { 44 db eval {
45 SELECT type, name FROM sqlite_temp_master 45 SELECT type, name FROM temp.sqlite_master
46 ORDER BY name 46 ORDER BY name
47 } 47 }
48 } {table ia1 table ia2 table ia3 table ia4} 48 } {table ia1 table ia2 table ia3 table ia4}
49 49
50 do_test intarray-1.2 { 50 do_test intarray-1.2 {
51 db eval { 51 db eval {
52 SELECT b FROM t1 WHERE a IN ia3 ORDER BY a 52 SELECT b FROM t1 WHERE a IN ia3 ORDER BY a
53 } 53 }
54 } {} 54 } {}
55 55
(...skipping 44 matching lines...) Expand 10 before | Expand all | Expand 10 after
100 } {999} 100 } {999}
101 101
102 do_test intarray-2.2 { 102 do_test intarray-2.2 {
103 set ia5 [sqlite3_intarray_create db ia5] 103 set ia5 [sqlite3_intarray_create db ia5]
104 db eval { 104 db eval {
105 SELECT count(*) FROM t3 WHERE p IN ia1; 105 SELECT count(*) FROM t3 WHERE p IN ia1;
106 } 106 }
107 } {999} 107 } {999}
108 108
109 finish_test 109 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/instrfault.test ('k') | third_party/sqlite/src/test/interrupt.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698