| Index: third_party/sqlite/sqlite-src-3100200/test/null.test
|
| diff --git a/third_party/sqlite/src/test/null.test b/third_party/sqlite/sqlite-src-3100200/test/null.test
|
| similarity index 93%
|
| copy from third_party/sqlite/src/test/null.test
|
| copy to third_party/sqlite/sqlite-src-3100200/test/null.test
|
| index f3782a7531bc0d09c00cba36c9bcb26a1bc1176f..e8eeb9740bdd3a1ddbfaefe5b6661afc57638c01 100644
|
| --- a/third_party/sqlite/src/test/null.test
|
| +++ b/third_party/sqlite/sqlite-src-3100200/test/null.test
|
| @@ -278,6 +278,23 @@ do_test null-8.15 {
|
| }
|
| } {1}
|
|
|
| +do_execsql_test null-9.1 {
|
| + CREATE TABLE t5(a, b, c);
|
| + CREATE UNIQUE INDEX t5ab ON t5(a, b);
|
| +
|
| + INSERT INTO t5 VALUES(1, NULL, 'one');
|
| + INSERT INTO t5 VALUES(1, NULL, 'i');
|
| + INSERT INTO t5 VALUES(NULL, 'x', 'two');
|
| + INSERT INTO t5 VALUES(NULL, 'x', 'ii');
|
| +}
|
| +
|
| +do_execsql_test null-9.2 {
|
| + SELECT * FROM t5 WHERE a = 1 AND b IS NULL;
|
| +} {1 {} one 1 {} i}
|
| +
|
| +do_execsql_test null-9.3 {
|
| + SELECT * FROM t5 WHERE a IS NULL AND b = 'x';
|
| +} {{} x two {} x ii}
|
|
|
|
|
| finish_test
|
|
|