Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Another test for whereD.test. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | multi-or-covering-index |
Files: | files | file ages | folders |
SHA1: |
29d586178dcfdb99eaf7ce768668ab0a |
User & Date: | dan 2012-08-24 19:58:18.909 |
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: 5499af53eb user: drh tags: multi-or-covering-index) | |
19:58 | Another test for whereD.test. (check-in: 29d586178d user: dan tags: multi-or-covering-index) | |
19:52 | Add extra tests to whereD.test. (check-in: 7e961eef6b user: dan tags: multi-or-covering-index) | |
Changes
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 |