aboutsummaryrefslogtreecommitdiff
path: root/test/index6.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/index6.test')
-rw-r--r--test/index6.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/test/index6.test b/test/index6.test
index ddd200c40..e9ea570b8 100644
--- a/test/index6.test
+++ b/test/index6.test
@@ -217,4 +217,14 @@ do_execsql_test index6-4.0 {
PRAGMA integrity_check;
} {ok}
+# Silently ignore database name qualifiers in partial indices.
+#
+do_execsql_test index6-5.0 {
+ CREATE INDEX t3b ON t3(b) WHERE xyzzy.t3.b BETWEEN 5 AND 10;
+ /* ^^^^^-- ignored */
+ ANALYZE;
+ SELECT count(*) FROM t3 WHERE t3.b BETWEEN 5 AND 10;
+ SELECT stat+0 FROM sqlite_stat1 WHERE idx='t3b';
+} {6 6}
+
finish_test