OLD | NEW |
1 # 2006 October 27 | 1 # 2006 October 27 |
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 53 matching lines...) Loading... |
64 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL} | 64 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL} |
65 } {2 2} | 65 } {2 2} |
66 do_test where4-1.4 { | 66 do_test where4-1.4 { |
67 count {SELECT rowid FROM t1 WHERE w=1 AND +x IS NULL} | 67 count {SELECT rowid FROM t1 WHERE w=1 AND +x IS NULL} |
68 } {2 3} | 68 } {2 3} |
69 do_test where4-1.5 { | 69 do_test where4-1.5 { |
70 count {SELECT rowid FROM t1 WHERE w=1 AND x>0} | 70 count {SELECT rowid FROM t1 WHERE w=1 AND x>0} |
71 } {1 2} | 71 } {1 2} |
72 do_test where4-1.6 { | 72 do_test where4-1.6 { |
73 count {SELECT rowid FROM t1 WHERE w=1 AND x<9} | 73 count {SELECT rowid FROM t1 WHERE w=1 AND x<9} |
74 } {1 3} | 74 } {1 2} |
75 do_test where4-1.7 { | 75 do_test where4-1.7 { |
76 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL AND y=3} | 76 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL AND y=3} |
77 } {2 2} | 77 } {2 2} |
78 do_test where4-1.8 { | 78 do_test where4-1.8 { |
79 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL AND y>2} | 79 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL AND y>2} |
80 } {2 2} | 80 } {2 2} |
81 do_test where4-1.9 { | 81 do_test where4-1.9 { |
82 count {SELECT rowid FROM t1 WHERE w='a' AND x IS NULL AND y='c'} | 82 count {SELECT rowid FROM t1 WHERE w='a' AND x IS NULL AND y='c'} |
83 } {4 2} | 83 } {4 2} |
84 do_test where4-1.10 { | 84 do_test where4-1.10 { |
85 count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL} | 85 count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL} |
86 } {6 2} | 86 } {6 2} |
87 do_test where4-1.11 { | 87 do_test where4-1.11 { |
88 count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL AND y=123} | 88 count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL AND y=123} |
89 } {1} | 89 } {1} |
90 do_test where4-1.12 { | 90 do_test where4-1.12 { |
91 count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL AND y=x'7A'} | 91 count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL AND y=x'7A'} |
92 } {6 2} | 92 } {6 2} |
93 do_test where4-1.13 { | 93 do_test where4-1.13 { |
94 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL} | 94 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL} |
95 } {7 2} | 95 } {7 2} |
96 do_test where4-1.14 { | 96 do_test where4-1.14 { |
97 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y IS NULL} | 97 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y IS NULL} |
98 } {7 2} | 98 } {7 2} |
99 do_test where4-1.15 { | 99 do_test where4-1.15 { |
100 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y<0} | 100 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y<0} |
101 } {2} | 101 } {1} |
102 do_test where4-1.16 { | 102 do_test where4-1.16 { |
103 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y>=0} | 103 count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y>=0} |
104 } {1} | 104 } {1} |
105 | 105 |
106 do_test where4-2.1 { | 106 do_test where4-2.1 { |
107 execsql {SELECT rowid FROM t1 ORDER BY w, x, y} | 107 execsql {SELECT rowid FROM t1 ORDER BY w, x, y} |
108 } {7 2 1 4 3 6 5} | 108 } {7 2 1 4 3 6 5} |
109 do_test where4-2.2 { | 109 do_test where4-2.2 { |
110 execsql {SELECT rowid FROM t1 ORDER BY w DESC, x, y} | 110 execsql {SELECT rowid FROM t1 ORDER BY w DESC, x, y} |
111 } {6 5 4 3 2 1 7} | 111 } {6 5 4 3 2 1 7} |
(...skipping 152 matching lines...) Loading... |
264 execsql { | 264 execsql { |
265 SELECT sum(( | 265 SELECT sum(( |
266 SELECT d FROM t8 WHERE a = i AND b = i AND c < NULL | 266 SELECT d FROM t8 WHERE a = i AND b = i AND c < NULL |
267 )) FROM t7; | 267 )) FROM t7; |
268 } | 268 } |
269 } {{}} | 269 } {{}} |
270 | 270 |
271 }; #ifcapable subquery | 271 }; #ifcapable subquery |
272 | 272 |
273 finish_test | 273 finish_test |
OLD | NEW |