OLD | NEW |
1 # 2014-02-11 | 1 # 2014-02-11 |
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 29 matching lines...) Expand all Loading... |
40 } {A/B/C A/B/C-move} | 40 } {A/B/C A/B/C-move} |
41 | 41 |
42 do_execsql_test tkt-4c86b126f2-2.1 { | 42 do_execsql_test tkt-4c86b126f2-2.1 { |
43 CREATE TABLE t1(x TEXT UNIQUE, y TEXT UNIQUE, z); | 43 CREATE TABLE t1(x TEXT UNIQUE, y TEXT UNIQUE, z); |
44 INSERT INTO t1 VALUES('ghi','jkl','y'); | 44 INSERT INTO t1 VALUES('ghi','jkl','y'); |
45 SELECT * FROM t1 WHERE (x='ghi' OR y='jkl') AND z IS NOT NULL; | 45 SELECT * FROM t1 WHERE (x='ghi' OR y='jkl') AND z IS NOT NULL; |
46 } {ghi jkl y} | 46 } {ghi jkl y} |
47 | 47 |
48 | 48 |
49 finish_test | 49 finish_test |
OLD | NEW |