| 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 |