Chromium Code Reviews

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

Issue 949043002: Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch (Closed) Base URL: git@github.com:domokit/mojo.git@master
Patch Set: Created 5 years, 9 months ago
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View unified diff |
« no previous file with comments | « third_party/sqlite/src/test/where3.test ('k') | third_party/sqlite/src/test/where7.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 # 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...)
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...)
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
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/where3.test ('k') | third_party/sqlite/src/test/where7.test » ('j') | no next file with comments »

Powered by Google App Engine