aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authordan <dan@noemail.net>2020-01-04 18:38:58 +0000
committerdan <dan@noemail.net>2020-01-04 18:38:58 +0000
commit664d80bbf78c23f84d970f2c1755afae5e86cf4f (patch)
tree03dc4ff82e2315104fe080291bb0af80593e9a4e /test
parent56ea69bf0e08988ded0e95a75a0ba5b6cab5e7d1 (diff)
downloadsqlite-664d80bbf78c23f84d970f2c1755afae5e86cf4f.tar.gz
sqlite-664d80bbf78c23f84d970f2c1755afae5e86cf4f.zip
Omit the omit flat from eq constraints on column "name" of dbstat virtual tables. Fix for [74a4c386].
FossilOrigin-Name: cfff5cb2279088aa66f435bd0d627b2c74c9a99ad9addfd44a4df8ba770b795a
Diffstat (limited to 'test')
-rw-r--r--test/stat.test7
1 files changed, 7 insertions, 0 deletions
diff --git a/test/stat.test b/test/stat.test
index b3edc7e28..34f977bca 100644
--- a/test/stat.test
+++ b/test/stat.test
@@ -298,6 +298,7 @@ do_catchsql_test 7.2.4 {
SELECT * FROM x3;
} {1 {unrecognized token: "123corp"}}
+
do_execsql_test 8.1 {
CREATE VIRTUAL TABLE st4 USING dbstat;
}
@@ -307,5 +308,11 @@ do_execsql_test 8.2 {
do_execsql_test 8.3 {
SELECT aggregate=1 FROM st4 WHERE aggregate = 5
}
+do_execsql_test 8.4 {
+ SELECT * FROM st4 WHERE name = NULL;
+}
+do_catchsql_test 8.5 {
+ SELECT * FROM st4 WHERE schema = NULL;
+} {1 {no such schema: }}
finish_test