OLD | NEW |
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 Loading... |
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 Loading... |
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 |
OLD | NEW |