Index: third_party/sqlite/src/test/null.test |
diff --git a/third_party/sqlite/src/test/null.test b/third_party/sqlite/src/test/null.test |
index f3782a7531bc0d09c00cba36c9bcb26a1bc1176f..e8eeb9740bdd3a1ddbfaefe5b6661afc57638c01 100644 |
--- a/third_party/sqlite/src/test/null.test |
+++ b/third_party/sqlite/src/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 |