diff options
Diffstat (limited to 'test/index6.test')
-rw-r--r-- | test/index6.test | 10 |
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 |