diff options
| author | Hans-Christoph Steiner <hans@eds.org> | 2014-10-16 22:51:35 -0400 |
|---|---|---|
| committer | Hans-Christoph Steiner <hans@eds.org> | 2014-10-16 22:51:35 -0400 |
| commit | 569c6676a6ddb0ff73821d7693b5e18ddef809b9 (patch) | |
| tree | 833538da7bba39105daff45e265aef386a200acd /test/whereA.test | |
| parent | 08119c361d1181b3e8f1abb429236e488a664753 (diff) | |
Imported Upstream version 3.2.0upstream
Diffstat (limited to 'test/whereA.test')
| -rw-r--r-- | test/whereA.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/test/whereA.test b/test/whereA.test index 5d0aca5..78826b1 100644 --- a/test/whereA.test +++ b/test/whereA.test @@ -68,6 +68,12 @@ do_test whereA-1.7 { SELECT * FROM t1; } } {3 4.53 {} 2 hello world 1 2 3} +do_execsql_test whereA-1.8 { + SELECT * FROM t1 WHERE b=2 AND a IS NULL; +} {} +do_execsql_test whereA-1.9 { + SELECT * FROM t1 WHERE b=2 AND a IS NOT NULL; +} {1 2 3} do_test whereA-2.1 { db eval { |