/ Check-in [29d58617]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Another test for whereD.test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | multi-or-covering-index
Files: files | file ages | folders
SHA1: 29d586178dcfdb99eaf7ce768668ab0aa9898c83
User & Date: dan 2012-08-24 19:58:18
Context
2012-08-24
21:54
Remove a NEVER() that is in fact reachable on an OOM. This probably has nothing to do with the multi-or-covering-index change but just happened to be found while testing that change. check-in: 5499af53 user: drh tags: multi-or-covering-index
19:58
Another test for whereD.test. check-in: 29d58617 user: dan tags: multi-or-covering-index
19:52
Add extra tests to whereD.test. check-in: 7e961eef user: dan tags: multi-or-covering-index
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/whereD.test.

150
151
152
153
154
155
156






157
158
} {2 two 1 one search 4}
do_searchcount_test 3.4.4 {
  SELECT a, b FROM t3 WHERE 
        (a=2 AND b=(SELECT y FROM t4 WHERE x='b')) 
     OR (a=1 AND b=(SELECT y FROM t4 WHERE x='a')) 
} {2 two 1 one search 6}








finish_test







>
>
>
>
>
>


150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
} {2 two 1 one search 4}
do_searchcount_test 3.4.4 {
  SELECT a, b FROM t3 WHERE 
        (a=2 AND b=(SELECT y FROM t4 WHERE x='b')) 
     OR (a=1 AND b=(SELECT y FROM t4 WHERE x='a')) 
} {2 two 1 one search 6}

do_searchcount_test 3.5.1 {
  SELECT a, b FROM t3 WHERE (a=1 AND b='one') OR rowid=4
} {1 one 2 two search 2}
do_searchcount_test 3.5.2 {
  SELECT a, c FROM t3 WHERE (a=1 AND b='one') OR rowid=4
} {1 i 2 ii search 2}

finish_test