Lines Matching refs:notnull
15 # $Id: notnull.test,v 1.4 2006/01/17 09:35:02 danielk1977 Exp $
25 do_test notnull-1.0 {
37 do_test notnull-1.1 {
44 do_test notnull-1.2 {
51 verify_ex_errcode notnull-1.2b SQLITE_CONSTRAINT_NOTNULL
52 do_test notnull-1.3 {
59 do_test notnull-1.4 {
66 verify_ex_errcode notnull-1.4b SQLITE_CONSTRAINT_NOTNULL
67 do_test notnull-1.5 {
74 verify_ex_errcode notnull-1.5b SQLITE_CONSTRAINT_NOTNULL
75 do_test notnull-1.6 {
82 do_test notnull-1.7 {
89 do_test notnull-1.8 {
96 do_test notnull-1.9 {
103 do_test notnull-1.10 {
110 verify_ex_errcode notnull-1.10b SQLITE_CONSTRAINT_NOTNULL
111 do_test notnull-1.11 {
118 do_test notnull-1.12 {
125 do_test notnull-1.13 {
132 do_test notnull-1.14 {
139 do_test notnull-1.15 {
146 do_test notnull-1.16 {
153 verify_ex_errcode notnull-1.16b SQLITE_CONSTRAINT_NOTNULL
154 do_test notnull-1.17 {
161 verify_ex_errcode notnull-1.17b SQLITE_CONSTRAINT_NOTNULL
162 do_test notnull-1.18 {
169 do_test notnull-1.19 {
176 do_test notnull-1.20 {
183 verify_ex_errcode notnull-1.20b SQLITE_CONSTRAINT_NOTNULL
184 do_test notnull-1.21 {
192 do_test notnull-2.1 {
200 verify_ex_errcode notnull-2.1b SQLITE_CONSTRAINT_NOTNULL
201 do_test notnull-2.2 {
209 verify_ex_errcode notnull-2.2b SQLITE_CONSTRAINT_NOTNULL
210 do_test notnull-2.3 {
218 do_test notnull-2.4 {
226 verify_ex_errcode notnull-2.4b SQLITE_CONSTRAINT_NOTNULL
227 do_test notnull-2.5 {
235 verify_ex_errcode notnull-2.6b SQLITE_CONSTRAINT_NOTNULL
236 do_test notnull-2.6 {
244 do_test notnull-2.7 {
252 do_test notnull-2.8 {
260 do_test notnull-2.9 {
268 do_test notnull-2.10 {
276 verify_ex_errcode notnull-2.10b SQLITE_CONSTRAINT_NOTNULL
278 do_test notnull-3.0 {
288 do_test notnull-3.1 {
295 do_test notnull-3.2 {
302 verify_ex_errcode notnull-3.2b SQLITE_CONSTRAINT_NOTNULL
303 do_test notnull-3.3 {
310 do_test notnull-3.4 {
317 verify_ex_errcode notnull-3.4b SQLITE_CONSTRAINT_NOTNULL
318 do_test notnull-3.5 {
325 verify_ex_errcode notnull-3.5b SQLITE_CONSTRAINT_NOTNULL
326 do_test notnull-3.6 {
333 do_test notnull-3.7 {
340 do_test notnull-3.8 {
347 do_test notnull-3.9 {
354 do_test notnull-3.10 {
361 verify_ex_errcode notnull-3.10b SQLITE_CONSTRAINT_NOTNULL
362 do_test notnull-3.11 {
369 do_test notnull-3.12 {
376 do_test notnull-3.13 {
383 do_test notnull-3.14 {
390 do_test notnull-3.15 {
397 do_test notnull-3.16 {
404 verify_ex_errcode notnull-3.16b SQLITE_CONSTRAINT_NOTNULL
405 do_test notnull-3.17 {
412 verify_ex_errcode notnull-3.17b SQLITE_CONSTRAINT_NOTNULL
413 do_test notnull-3.18 {
420 do_test notnull-3.19 {
427 do_test notnull-3.20 {
434 verify_ex_errcode notnull-3.20b SQLITE_CONSTRAINT_NOTNULL
435 do_test notnull-3.21 {
443 do_test notnull-4.1 {
451 verify_ex_errcode notnull-4.1b SQLITE_CONSTRAINT_NOTNULL
452 do_test notnull-4.2 {
460 verify_ex_errcode notnull-4.2b SQLITE_CONSTRAINT_NOTNULL
461 do_test notnull-4.3 {
469 do_test notnull-4.4 {
477 verify_ex_errcode notnull-4.4b SQLITE_CONSTRAINT_NOTNULL
478 do_test notnull-4.5 {
486 verify_ex_errcode notnull-4.5b SQLITE_CONSTRAINT_NOTNULL
487 do_test notnull-4.6 {
495 do_test notnull-4.7 {
503 do_test notnull-4.8 {
511 do_test notnull-4.9 {
519 do_test notnull-4.10 {
527 verify_ex_errcode notnull-4.10b SQLITE_CONSTRAINT_NOTNULL
531 do_test notnull-5.1 {
540 do_test notnull-5.2 {
546 verify_ex_errcode notnull-5.2b SQLITE_CONSTRAINT_NOTNULL
547 do_test notnull-5.3 {
550 do_test notnull-5.4 {
559 verify_ex_errcode notnull-5.4b SQLITE_CONSTRAINT_NOTNULL
560 do_test notnull-5.5 {
579 do_execsql_test notnull-6.0 {
595 do_uses_op_next_test notnull-6.1 "SELECT * FROM t1 WHERE a IS ?" 1
596 do_uses_op_next_test notnull-6.2 "SELECT * FROM t2 WHERE a IS ?" 0
597 do_uses_op_next_test notnull-6.3 "SELECT * FROM t3 WHERE a IS ?" 0
598 do_uses_op_next_test notnull-6.4 "SELECT * FROM t4 WHERE a IS ?" 0
600 do_uses_op_next_test notnull-6.5 "SELECT * FROM t5 WHERE a IS ?" 1
601 do_uses_op_next_test notnull-6.6 "SELECT * FROM t6 WHERE a IS ?" 0
602 do_uses_op_next_test notnull-6.7 "SELECT * FROM t7 WHERE a IS ?" 0
603 do_uses_op_next_test notnull-6.8 "SELECT * FROM t8 WHERE a IS ?" 0
605 do_uses_op_next_test notnull-6.9 "SELECT * FROM t8 WHERE a IS ?" 0
606 do_uses_op_next_test notnull-6.10 "SELECT * FROM t8 WHERE a IS ?" 0