diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/check.test | 6 | ||||
| -rw-r--r-- | test/index6.test | 10 |
2 files changed, 16 insertions, 0 deletions
diff --git a/test/check.test b/test/check.test index 99b72ac8a..f7ebc2cb4 100644 --- a/test/check.test +++ b/test/check.test @@ -451,5 +451,11 @@ do_test 7.8 { catchsql { INSERT INTO t6 VALUES(12) } db2 } {1 {constraint failed}} +# 2013-08-02: Silently ignore database name qualifiers in CHECK constraints. +# +do_execsql_test 8.1 { + CREATE TABLE t810(a, CHECK( main.t810.a>0 )); + CREATE TABLE t811(b, CHECK( xyzzy.t811.b BETWEEN 5 AND 10 )); +} {} finish_test 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 |