aboutsummaryrefslogtreecommitdiff
path: root/test/view.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/view.test')
-rw-r--r--test/view.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/test/view.test b/test/view.test
index 490dc65a6..b3f50dc00 100644
--- a/test/view.test
+++ b/test/view.test
@@ -38,6 +38,18 @@ do_test view-1.1 {
SELECT * FROM v1 ORDER BY a;
}
} {1 2 4 5 7 8}
+do_test view-1.1.100 {
+ db config enable_view off
+ catchsql {
+ SELECT * FROM v1 ORDER BY a;
+ }
+} {1 {access to view "v1" prohibited}}
+do_test view-1.1.110 {
+ db config enable_view on
+ catchsql {
+ SELECT * FROM v1 ORDER BY a;
+ }
+} {0 {1 2 4 5 7 8}}
do_test view-1.2 {
catchsql {
ROLLBACK;