OLD | NEW |
1 # 2010 July 14 | 1 # 2010 July 14 |
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 142 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
153 do_execsql_test tkt-80e031a00f.316 {SELECT 4 IN t6n} 1 | 153 do_execsql_test tkt-80e031a00f.316 {SELECT 4 IN t6n} 1 |
154 do_execsql_test tkt-80e031a00f.317 {SELECT 2 NOT IN t6n} 0 | 154 do_execsql_test tkt-80e031a00f.317 {SELECT 2 NOT IN t6n} 0 |
155 do_execsql_test tkt-80e031a00f.318 {SELECT 'b' IN t7} 1 | 155 do_execsql_test tkt-80e031a00f.318 {SELECT 'b' IN t7} 1 |
156 do_execsql_test tkt-80e031a00f.319 {SELECT 'c' NOT IN t7} 0 | 156 do_execsql_test tkt-80e031a00f.319 {SELECT 'c' NOT IN t7} 0 |
157 do_execsql_test tkt-80e031a00f.320 {SELECT 'c' IN t7n} 1 | 157 do_execsql_test tkt-80e031a00f.320 {SELECT 'c' IN t7n} 1 |
158 do_execsql_test tkt-80e031a00f.321 {SELECT 'd' NOT IN t7n} 0 | 158 do_execsql_test tkt-80e031a00f.321 {SELECT 'd' NOT IN t7n} 0 |
159 do_execsql_test tkt-80e031a00f.322 {SELECT 'b' IN t8} 1 | 159 do_execsql_test tkt-80e031a00f.322 {SELECT 'b' IN t8} 1 |
160 do_execsql_test tkt-80e031a00f.323 {SELECT 'c' NOT IN t8} 0 | 160 do_execsql_test tkt-80e031a00f.323 {SELECT 'c' NOT IN t8} 0 |
161 do_execsql_test tkt-80e031a00f.324 {SELECT 'c' IN t8n} 1 | 161 do_execsql_test tkt-80e031a00f.324 {SELECT 'c' IN t8n} 1 |
162 do_execsql_test tkt-80e031a00f.325 {SELECT 'd' NOT IN t8n} 0 | 162 do_execsql_test tkt-80e031a00f.325 {SELECT 'd' NOT IN t8n} 0 |
| 163 do_execsql_test tkt-80e031a00f.326 {SELECT 'a' IN (NULL,'a')} 1 |
| 164 do_execsql_test tkt-80e031a00f.327 {SELECT 'a' IN (NULL,'b')} {{}} |
| 165 do_execsql_test tkt-80e031a00f.328 {SELECT 'a' NOT IN (NULL,'a')} 0 |
| 166 do_execsql_test tkt-80e031a00f.329 {SELECT 'a' NOT IN (NULL,'b')} {{}} |
163 # | 167 # |
164 # Row 4: | 168 # Row 4: |
165 do_execsql_test tkt-80e031a00f.400 {SELECT 1 IN (2,3,4,null)} {{}} | 169 do_execsql_test tkt-80e031a00f.400 {SELECT 1 IN (2,3,4,null)} {{}} |
166 do_execsql_test tkt-80e031a00f.401 {SELECT 1 NOT IN (2,3,4,null)} {{}} | 170 do_execsql_test tkt-80e031a00f.401 {SELECT 1 NOT IN (2,3,4,null)} {{}} |
167 do_execsql_test tkt-80e031a00f.402 {SELECT 'a' IN ('b','c',null,'d')} {{}} | 171 do_execsql_test tkt-80e031a00f.402 {SELECT 'a' IN ('b','c',null,'d')} {{}} |
168 do_execsql_test tkt-80e031a00f.403 {SELECT 'a' NOT IN (null,'b','c','d')} {{}} | 172 do_execsql_test tkt-80e031a00f.403 {SELECT 'a' NOT IN (null,'b','c','d')} {{}} |
169 do_execsql_test tkt-80e031a00f.404 {SELECT 1 IN t4n} {{}} | 173 do_execsql_test tkt-80e031a00f.404 {SELECT 1 IN t4n} {{}} |
170 do_execsql_test tkt-80e031a00f.405 {SELECT 5 NOT IN t4n} {{}} | 174 do_execsql_test tkt-80e031a00f.405 {SELECT 5 NOT IN t4n} {{}} |
171 do_execsql_test tkt-80e031a00f.406 {SELECT 6 IN t6n} {{}} | 175 do_execsql_test tkt-80e031a00f.406 {SELECT 6 IN t6n} {{}} |
172 do_execsql_test tkt-80e031a00f.407 {SELECT 7 NOT IN t6n} {{}} | 176 do_execsql_test tkt-80e031a00f.407 {SELECT 7 NOT IN t6n} {{}} |
(...skipping 24 matching lines...) Expand all Loading... |
197 do_execsql_test tkt-80e031a00f.518 {SELECT null IN t7} {{}} | 201 do_execsql_test tkt-80e031a00f.518 {SELECT null IN t7} {{}} |
198 do_execsql_test tkt-80e031a00f.519 {SELECT null NOT IN t7} {{}} | 202 do_execsql_test tkt-80e031a00f.519 {SELECT null NOT IN t7} {{}} |
199 do_execsql_test tkt-80e031a00f.520 {SELECT null IN t7n} {{}} | 203 do_execsql_test tkt-80e031a00f.520 {SELECT null IN t7n} {{}} |
200 do_execsql_test tkt-80e031a00f.521 {SELECT null NOT IN t7n} {{}} | 204 do_execsql_test tkt-80e031a00f.521 {SELECT null NOT IN t7n} {{}} |
201 do_execsql_test tkt-80e031a00f.522 {SELECT null IN t8} {{}} | 205 do_execsql_test tkt-80e031a00f.522 {SELECT null IN t8} {{}} |
202 do_execsql_test tkt-80e031a00f.523 {SELECT null NOT IN t8} {{}} | 206 do_execsql_test tkt-80e031a00f.523 {SELECT null NOT IN t8} {{}} |
203 do_execsql_test tkt-80e031a00f.524 {SELECT null IN t8n} {{}} | 207 do_execsql_test tkt-80e031a00f.524 {SELECT null IN t8n} {{}} |
204 do_execsql_test tkt-80e031a00f.525 {SELECT null NOT IN t8n} {{}} | 208 do_execsql_test tkt-80e031a00f.525 {SELECT null NOT IN t8n} {{}} |
205 | 209 |
206 finish_test | 210 finish_test |
OLD | NEW |