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
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
|