aboutsummaryrefslogtreecommitdiff
path: root/test/where.test
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2018-06-07 16:07:00 +0000
committerdrh <drh@noemail.net>2018-06-07 16:07:00 +0000
commit056f5396fef186c23f654b06872c9f478d530016 (patch)
tree5567892af1074da4e07e3dcdf11e9ede703e9577 /test/where.test
parent64c1f77a8e066e0bdbd640cfd97c87a5094cefb9 (diff)
downloadsqlite-056f5396fef186c23f654b06872c9f478d530016.tar.gz
sqlite-056f5396fef186c23f654b06872c9f478d530016.zip
Test cases.
FossilOrigin-Name: 085e863713a3f2d420c0076b275a6ac445a59d4d93f9eb0e8503b4e3f5589249
Diffstat (limited to 'test/where.test')
-rw-r--r--test/where.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/test/where.test b/test/where.test
index 7ac173802..216325d03 100644
--- a/test/where.test
+++ b/test/where.test
@@ -490,12 +490,12 @@ ifcapable subquery {
count {
SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,10) ORDER BY 1;
}
- } {2 1 9 5}
+ } {2 1 9 4}
do_test where-5.15 {
count {
SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,16) ORDER BY 1;
}
- } {2 1 9 3 1 16 9}
+ } {2 1 9 3 1 16 8}
do_test where-5.100 {
db eval {
SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)